How to Avoid Future Dates Categories

[Kiran Kandavalli]

Team,

When I generate the Cube and see the Date hierarchy, I see the future Dates.

Is there a way that we can restrict the date hierarchy not to show the future dates either in the Cube OR at the report level (report Studio)

Thanks!
Kiran

[cognostechie]

Right-click on the Data Dimension header and in the properties, there is a tab where you can set the Earliest and the Last Date. In the Last Date, you can restrict that to the end of this year. This will require an yearly maintenance to change this next year.

Since the categories have already been generated, you might also have to go to the diagram mode and delete the categories for the future dates.

In addition to this, you can also set a filter on the query (in the Data sources window) to restrict the date to the end of this year by setting a dynamic filter which can determine the end date of the current year. As there is no way in Transformer to set a filter, you will have to do this in the source which is generating that query, maybe Framework Manager in your case.