hi,
is there a way to reduce the performance overhead of calculations - thin about physical measure "XYZ original" and i create a caculated member called "XYZ" by the following definiton
CREATE MEMBER CURRENTCUBE.[MEASURES].[XYZ]
AS [Measures].[XYZ original],
FORMAT_STRING = "#",
NON_EMPTY_BEHAVIOR = { [XYZ original] },
VISIBLE = 1
I would expect the same performance, but its 15 - 25% slower on my sample querie (
select
{measures.[XYZ]} on columns,
[Dimension].[Hierarchie].members on rows
from
Cube
)
returning 25000 cells.
Does someone know ways to imporve this querie? reduce the overhead of this really simple calculation (alias for the measure name)?
It do this because of .. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1109927&SiteID=1&mode=1
LG, HANNES
Hi Hannes
In your calculated member definition you should replace
NON_EMPTY_BEHAVIOR = { [XYZ original] }
with
NON_EMPTY_BEHAVIOR = [Measures].[XYZ original]
Why? Well - unless you are running SP2 (CTP), you are dealing with a limitation in how the AS engine interprets the NON_EMPTY_BEHAVIOR definitions. For more info, see:
http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!914.entry
