performance impact of aliasing

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

Percentage measure

Hi,

easy question for advanced users:

I have a dimension called "Movement rate". The members are "1" to "6".
There is a measure called "No. of Products".

What i easily like to do is showing the percentages "No. of Product" for each "Movement rate" of the amount of "No. of Products" without using the frontend-tool.

Thx in advance for any help.

AndreasWhat is your table layout?|||Just for ur further explanation:

I like to get the following (red) result:

Movement rate No. of Products No. of Products in %
1 100 10
2 100 10
3 200 20
4 300 30
5 200 20
6 100 10
Amount: 1000 100

My table design is the following:

"Movement rate" int
"No of Products" int

I don't know for what reason u need this table design, cause what I need is the MDX - Query for my cube.

Thx.

Percentage Calucated Measure across several dimensions

> You can use tuple. For example,
> [Measures].[expenditure amount] / ([Expenditure].[All expe
nditures],
> [Measures].[expenditure amount])
I used this formular but in my case it only works properly with one
dimension. The formular I want to write is quite simple
[Measures].[Value] / <Queryresult>
where <Queryresult> is the sum of all values. But I am a complete newby in
MDX and don't know how to accomplish it. Can anyone give me a hand?
OliverYou can use tuple again.
[Measures].[Value] / ([Measures].[Value], [All Dim1], &#
91;All Dim2], [All
Dim3], ..., [All DimN])
Next version will support Root() for this purpose.
Ohjoo Kwon
"Oliver Kerber" <okerber@.bigfoot.de> wrote in message
news:d1jsjh$pvr$02$1@.news.t-online.com...
> I used this formular but in my case it only works properly with one
> dimension. The formular I want to write is quite simple
> [Measures].[Value] / <Queryresult>
> where <Queryresult> is the sum of all values. But I am a complete newby in
> MDX and don't know how to accomplish it. Can anyone give me a hand?
> Oliver
>