creating a cube 'library' for users

Category: sql server dw


Three peaks on Thu, 10 Aug 2017 14:04:36


Having created a suite of cubes for end users I've been challenged to make a more industrial way to publish them.

Attaching to a data source via the 'Data' tab in excel and then using either 'From Other Sources' , 'From Analysis Services;' and completing the wizard is deemed insufficient.

Is there a way to list a set of data sources from a library of sorts and have them open in excel?

I recognize I can create excel workbook templates already connected to the data source but prefer not to go that route.

Thanks in advance.



Olaf Helper on Sat, 19 Aug 2017 04:47:00

Hello Steve,

After you added a new datasource in Excel it should be available from "Existing Datasource".