Hi all,

I want to compare the data of current month with previous month where
current month would be decided runime. How can we pass parameters to
Trend/status MDX expressions in KPI of a cube in SSAS?

Thanks in advance
Gayatri.

when you query your cube to retrieve your KPI you create an MDX syntax

so you can put in row / column / filter any standard MDX statement:
select kpivalue()..... from Cube where (Time.Month.200501)

The KPI will be evaluated like any calculated measure.

"gayu" <gayatri.kulkarni (AT) gmail (DOT) com> wrote