[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

Calculated measure can be replaced with named query to improve performance

I have a calculated measure. It is just an average and it is taking lots of time to execute. Can I remove the calculated member and replace the fact table with named query? will that somehow improve the performance?
0
himabindu_nvn
Asked:
himabindu_nvn
1 Solution
 
Tim HumphriesDirectorCommented:
No. A named query is just a shortcut.
Can you post your calculated member s o ican see what you're trying to do?
Details of  the number of rows in the fact table and any aggregations you have created will help too.

Thanks

Tim

p.s. zone should be changed to OLAP
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now