N
-Nate
Hello, I have question about OLAP queries. I have to update about 10 pivot
tables in 10 separate .xls files daily. All 10 link to the same OLAP cube
information and the primary pivot table is actually the same (I built 10
separate 2nd pivot tables/.xls' off of the original for 10 different
workgroups). The data is stored remotely and each report takes 2mins 43sec
to complete.
Question: Is there a way to update the cube table pivot table and store it
locally and use that in the 10 separate reports? I don’t want to put in an
IT request for a new report if I can avoid it, but reconfiguring the 2nd
pivot table takes as long as refreshing it.
tables in 10 separate .xls files daily. All 10 link to the same OLAP cube
information and the primary pivot table is actually the same (I built 10
separate 2nd pivot tables/.xls' off of the original for 10 different
workgroups). The data is stored remotely and each report takes 2mins 43sec
to complete.
Question: Is there a way to update the cube table pivot table and store it
locally and use that in the 10 separate reports? I don’t want to put in an
IT request for a new report if I can avoid it, but reconfiguring the 2nd
pivot table takes as long as refreshing it.