I am new to this.
I built a pivot report in excel 2007 on SSAS. It connects to a cube on my local pc. Now I want to send this pivot report to other people to make them be able to view the pivot report and do some analysis by themselves (expanding year-month-day etc).
When my colleague tried he couldn't expand.
How can I achieve this?
Thank you, Nian
Your colleague needs to be able to access the cube in order to refresh it. This means that your cube should be on a shared machine (like a server). I would recommend putting the cube on a server and setup a database read-only user login and setup the Excel file to use that username/password. You may be able to have your local machine be accessible, but I don't have experience with this and I would advise against it anyhow (your users wouldn't be able to refresh the cube if you don't have your computer on the network).
Also, even if you send them the file with data cached from the cube, only so much data gets cached. When you expand items, it won't need to request the data from the cube (on your machine/server) if it has that particular data cached. The same may happen when you create filters.