Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
0 votes
0 answers
29 views

Define MDX Update Allocation Method - Excel What-If Calculate Change

I have setup up a multi-dimensional data model in SSAS which is embedded in Microsoft Excel as a Pivot Table. In Excel I want to use the OLAP what-If analysis functionalities. Screenshort Excel ...
DataScientist's user avatar
2 votes
0 answers
245 views

Connection String not valid - MDX query error in Power Pivot

I am trying to execute MDX query in Power Pivot. While creating connection I have selected Model.odc. The connection string gets validated successfully by Test Connection. In further step when I ...
Amruta's user avatar
  • 731