Large Dataset Report (9G) Refresh Failed After Adding Calculated Columns, Tables, Measures

Hi there,

I have a large dataset report with around 9 GB raw data retrieving from SQL database based on defined query parameters. I have no issue to change the query parameters (which are time ranges) and refresh the report.

However, after adding serveral calculated columns, tables and measures to the report (some of them involves entensive calculations and depending on each other), when I change the queqry parameters and do the refresh, it takes forever to finish. I think it was due to that dependencies of "added calculated columns, tables and measures" on each other. I just wonder if there is a way to manually define the execuation order of "added calcuated columns, tables and measures" or disable them first when doing the query fresh.

Thanks,

Ty