October 22, 2012 at 9:20 am
Hi all,
I am very new to this. I built a pivot report (excel 2007) on ssas. It has data, rows, columns. And columns has hierarchy likes day-month. Now I want to send this report to a customer, so he can view it by himself and expand the hierarchy as he likes. But he can only see the contents as I saved the report. E.g. I saved it as month hierarchy and he can only see the monthly figures and can not expand the hierarchy to day. What should I do? The customer has no access to the ssas data source.
N.Z
October 22, 2012 at 11:12 am
The way Excel pivot table works against SSAS is by sending MDX queries to the SSAS server every time you manipulate the data. (Slice/Dice/Expand/Collapse dimensions) If the customer cannot be granted access to the SSAS source, I would think the only way to give him an expand/collapse pivot table is to dump your cube data into a new sheet and use the sheet as the source for the pivot table.
October 22, 2012 at 1:49 pm
Thanks for the reply. How can I dump all cube data to an excel?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply