J
Jason Wilson
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
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