maheshrk81
Board Regular
- Joined
- Jan 5, 2010
- Messages
- 153
Hi All,
I have a file with 5 tabs. In first Tab, i provide the selection criteria (Slicers/Drop downs etc.), 2nd tab for few of the mapping tables. 3rd tab with few pivot tables which are not connected to slicers (1st tab). Now in the 5th tab i have report where the data is populated based on Cubevalue/Cubemember formulas.
Now i am thinking of rebuilding the report based on GetPivot formulas as the current report refresh is taking very long time to refresh.
Is there a way where a pivot table can work based on MDX query which is saved in a cell. Based on the selection criteria i will create a formula to create a MDX Query and then the pivot table should take that query and get refreshed using Macro.
Is there any way?
Thanks,
Mahi
I have a file with 5 tabs. In first Tab, i provide the selection criteria (Slicers/Drop downs etc.), 2nd tab for few of the mapping tables. 3rd tab with few pivot tables which are not connected to slicers (1st tab). Now in the 5th tab i have report where the data is populated based on Cubevalue/Cubemember formulas.
Now i am thinking of rebuilding the report based on GetPivot formulas as the current report refresh is taking very long time to refresh.
Is there a way where a pivot table can work based on MDX query which is saved in a cell. Based on the selection criteria i will create a formula to create a MDX Query and then the pivot table should take that query and get refreshed using Macro.
Is there any way?
Thanks,
Mahi
