Measure Default from Amt to Qty?
I would like to change the measure from displaying as a AMT to a QTY.
How do I go about this?
If the data model you are using was built in BI Office with the Data Modeler (yellow button), you can change the default measure on the last screen of the Data Model Wizard (see screenshot #1 below).
If the model was built outside of BI Office via SQL Server Data Tools, then you can set the default measure in the project file (see screenshot #2). You would need to select the cube name in the upper left (see highlight) and then modify the Default Measure property in the Properties pane in the lower right (see highlight). *NOTE - this only applies to multi-dimensional cubes and not tabular models.Reply