Breakdown analysis
Show multiple dimensions in order of contribution.
Breakdown analyses show nested dimensions of data that provide a breakdown of relative contributions to a measure.
Creating breakdown analyses
Do the following:
-
In Assets, click Analysis.
-
Drag and drop Breakdown into the sheet.
-
Click Add dimension and select a dimension.
-
Optionally, click Add dimension to add an additional dimension.
-
Click Add measure and select a measure.
-
Optionally, to add an analysis period, do the following:
-
In the properties panel, under Analysis properties, turn on Analysis period.
-
Under Calendar period, select the calendar period to use.
-
Under Period, select a specific period to use.
Information noteAnalysis periods requires calendar periods in the logical model. For more information, see Defining analysis periods with calendar periods. -
-
Optionally, in the properties panel, under Appearance, adjust the appearance of the analysis.