Pivot table from olap cube Warning and datasource

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

suppress warning and locate cube in a pivot table from olap cube 0
Changing OLAP Pivot Table Connection Source 0
Message from Pivot having OLAP cube as datasource 0
OLAP cube in 2003 0
Refresh CubeFields for existing Pivot Table on OLAP cube 1
OLAP Pivot Table 1
Pivot table hierarchical dimension expansion 0
Pivot Table accessing data from OLAP cube 0

Top