Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A transportable solution using Data Connection Libraries in ShareP
We have approximately 5 Analysis Services cubes that we deliver with our
product that we want to build some predefined pivot tables and graphs in Excel that will pull data from our cubes that we want to display in SharePoint. I am able to get this working in my development system. We have built basically 23 different workbooks that are displayed on 23 different SharePoint pages. I am not looking for a way to make this a redployable solution for customers. The SSAS server name, SSAS DB name will change, and the sharepoint site/location will change, the rest should remain the same (cube names, OLAP query, etc.). I am thinking I should create a Data Connection Library for each cube, and then have the worksheets point to them. I am hoping that would eliminate me/the customer from having to edit all 23 workbooks individually, and just edit the 5 data connection libraries at install time. Using that solution, it looks to me like I would still have to go into each workbook and point it to the customers SharePoint Data Connection library location. Is there anyway to eliminate/automate this process at our product's install time? What I am ulitmately trying to get to is an install process that will deploy these 23 workbooks to display on each page and deliver them so they are configured to run against the SSAS cubes. I want the customer to provide all the parameters up front, and run a process and not have to go into SharePoint and do anything manually. Thanks, Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
Trusted Data Connection | Excel Discussion (Misc queries) | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
always recheck data connection library in MOSS for latest data sou | Excel Discussion (Misc queries) | |||
remove data connection | Excel Discussion (Misc queries) |