Hi,

I am buidling some MOLAP cubes with Analysis Services and
came across a few issues :
- How can I change the location where my cubes' data is
stored? In Analysis Manager, I tried changing the
Properties - Data Folder, and copied my data files to the
new location. It didn't change anything, even after
reprocessing some cubes.
- When using pivot tables in Excel, how do users see
what cubes they are actually accessing on what machine,
when opening a pivot table built earlier?
- If a user builds a report and double-ticks parents A
and B in order to see their children, but on that day B
has no child. Then it seems that Excel automatically
transforms the double-tick into a single tick, so that
the next day, even if B has children, then they wouldn't
show automatically.

Any help on these questions would be welcome!

Thanks,
Celine