Derive default values on Page level items based on a calculation


#1

I have a set of reports that have the Time Dimension at Page level and from which the given month can be selected.

I am yet to find a way to default the month that’s selected by default to be the current month.

So, my request is that we can derive default values on Page level items based on a calculation.


#2

Hi Graeme,

You can create a calculated member in Time dimension that always returns current month. The formula for that would be as follows

Aggregate({
  [Time].[Month].CurrentDateMember
})

Further, you can select this calculated member as the Time page filter and save the report. Automatically the month would be filtered to the current. See an example report in eazyBI demo account.

Lauma / support@eazybi.com