Performance Comparing Months

HMejia — Wed, 15 Sep 2021 17:29:41 GMT

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)

Re: Performance Comparing Months

Gysbert_Wassenaar — Thu, 16 Sep 2021 11:53:29 GMT

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.

topic Re: Performance Comparing Months in App Development

Performance Comparing Months

Re: Performance Comparing Months