Enabling Dynamic Criteria through SSAS

The demo is split into two sections: One section with a description on how to enable Dynamic Criteria in the Period dimension in the Analysis Services Project, and another section with a description on how to use the Dynamic Criteria options in the TARGIT Client.

Enabling Dynamic Criteria for the Period dimension

Open the Period dimension in Visual Studio and right click the dimension’s name in the Attributes list to select Properties.

mceclip0.png

First we need to set the Type property to Time for the Period dimension.

mceclip1.png

Repeat this step for the three attributes of the Period dimension:

Attribute

Type

YearName

Years

MonthName

Months

Date

Days

Once the appropriate types have been selected for the dimension and for the attributes, we must open the properties for the Hierarchy. Right click the Hierarchy header to select Properties.

mceclip2.png

In the Description property we must now enter the syntax that enables Dynamic Criteria in the TARGIT Client for all four levels of the Time dimension..

mceclip3.png

Complete the enabling of the Dynamic Criteria on the Time dimension by deploying and processing the Sales cube.

Was this article helpful?
0 out of 0 found this helpful

Comments

1 comment
  • How would the setup be if you have a SSAS Tabular Model?

    1

Please sign in to leave a comment.