suppress warning and locate cube in a pivot table from olap cube

T

Tewari

I have created a Pivot table which has an External datasource OLAP
cube( created by 'create offline OLAP cube wizard' by Excel from MS
Access database ).
I distribute my report comprising of An Excel workbook and olap cube
vy zipping the two files together.
When the other users unzip the file to see the report the Pivot asks
for the datasource again which they have to locate and then save.Is
there any way where can I define the path of the datasource same as
the path of the workbook?

When I create a Pivot table from OLAP cube once I click any page field
for the first time I get an error message "The Operation connects to
an external data source'
How can I suppress this warning message?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLAP Pivot Table 1
Excel 2007 pivot table using analysis services cube as data source 0
Pivot table from olap cube Warning and datasource 0
Pivot Table refresh question 0
How to save a cube pivot as an offline dataset? 0
olap data cube 0
Remove data from OLAP pivot table 0
Pivot Table accessing data from OLAP cube 0

Top