|Dimension_Expression||MDX expression that returns a dimension.|
[Time].CurrentHierarchyMember can be used in calculated member formulas to handle both
Example below verifies if the Time dimension is used on report with a particular period or not used in the report. The formula validates if All Times (default member) is used in the report or Time dimension is absent from the report.
See example report Control chart (cycle time) in our Demo account. Time dimension usage in the report might impact calculation. The calculated measures Rolling Average cycle time and Rolling Average cycle time alternative uses a formula above to validate if the Time dimension is used in the report. If no time dimension is used in the report a simple calculation for a cycle time can be used. The report uses Time dimension in the report, therefore, in the particular example the more complex calculation with iteration through issues is needed.