Solved

Calculated measure can be replaced with named query to improve performance

Posted on 2011-09-16
1
469 Views
Last Modified: 2016-02-15
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
Comment
Question by:himabindu_nvn
1 Comment
 
LVL 15

Accepted Solution

by:
Tim Humphries earned 500 total points
ID: 36553714
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SQL Server connect issues 4 37
Need sql in string 2 28
Want an individual results display div 8 39
SQL Server Express or Standard? 5 18
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question