MDX function for previous month

[babu babu]

Hi,

How to calculate the previous month bases on the sysdate from the transformer cube in report studio.

Thanks,
Anand.

[RobsWalker68]

Hi Anand,

There are different ways to handle this.  A couple of suggestions:

1. Set up a data source feed based on sysdate and use it to set the current period. Use relative dates for current and previous month

2. Same as above to identify current month then:

In your Report Studio report using the dimensional function linkmember return the corresponding month value from your time dimension.

Finally, apply the lag dimensional function to produce previous month.

Option 1 is the simplest, although option 2 is more useful if you are looking to work out YTD etc

Rgds

Rob