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.
First we need to set the Type property to Time for the Period dimension.
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.
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..
Complete the enabling of the Dynamic Criteria on the Time dimension by deploying and processing the Sales cube.
Comments
How would the setup be if you have a SSAS Tabular Model?
Steen Gøbel, you can do this through TARGIT Decorations. I believe there's an article on here that walks you through how to set up dynamic dates through decorations. This is what we're doing for a tabular model.
Please sign in to leave a comment.