Performance Comparing Months

[HMejia]

Hi, I have a Fact table with 300 Millions of records, i need compare data with a previous month, i used Set analysis and alternate States and works OK, however, the response time is slow (20 Seconds), somebody kowns a better way to do that ?

Thanks.

1.  Using Set Analysis // Sum({<T_Month={$(vPrevM)}>} Sales)

2.  Using Alternate States // Sum({ComparePM} Sales)

3.  Using Alternate States // Sum({$<T_Month = ComparePM::T_Month>}  Sales)

[Gysbert_Wassenaar]

I don't think there's a better way then set analysis.

300 million rows shouldn't be a problem provided unless the data model is complex or you're using lots of dimensions and/or expression in a table or your machine has quite low cpu and ram specs. Or a combination of those things.