View Dimension

The View is how to see the data or look at the text that was entered in certain Dimension Members. Common calculations are included because the data is easily available, and it saves having to create custom formulas. Also included is CalcStatus which shows the calculation status for a Data Unit and several views into different types of Data Attachment comments, such as Annotation, Assumptions, Footnote and VarianceExplanation. 

View Member Abbreviations

When using View Members, shorthand versions of the Members are recognized.

Periodic  Per	Trailing2MonthAverage-Trailing12MonthAverage Trailing2MonthAvg-Trailing12MonthAvg, T2Avg-T12AVG
Month to Date MTD	QuarterAverage QuarterAvg, QAvg
Quarter to Date   QTD	HalfYearAverage HalfYearAvg, HAvg
Half Year to Date HTD	YearAverage YearAvg, YAvg
Year to Date YTD	YearSumToDate YSumTD
Calculation Status  CalcStatus, CS	YearSumToDatePrior YSumTDPrio
AuditComment  Audit	Trailing2MonthTotal-Trailing12MonthTotal  T2Total-T12Total
VarianceExplanation  VarExp