How to Use the tree in report Studio

Environment: for example, in a sales data, the user must select the Year, the month, the day, or one of them as the filtering condition at will, if it is a cube, you can drag different dimension levels to implement this function. But what if it is a DMR model developed by FM? The answer is to use the tree tip in reportstudio to achieve hierarchical selection. For example

1: drag a tree prompt

2: Next Step

3: The selection is complete.

4: drag a list to create a date data item. The content of the date data item is as follows:

Set ([order Data Analysis]. [date dimension]. [date dimension]. [year]->? Time ?)

5: Select "2014", select "August 2014", and run

The following error is reported: The month does not belong to the Year.

Go to query and delete the filter in the list query.

6: select the year, month, and day to display the data of the year, month, and day respectively.

Select month separately

Select a day

As shown above, data is displayed based on user-selected conditions.