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)
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.
