Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.