I have a report which always requires me to show a particular field which is
a non-numeric (nvarchar(50)) datatype.

Just imagine it as a comment column which always has to be displayed in the
end report regardless of which combination of dimensions are chosen.

Is there a way to define a non numeric measure in AS in this case?

Just for a better understanding, the end report might carry columns like
Month of year (dimension), Customers of Region A (dimension), Total amount A
(Measure), Total amount B (Measure), Gross amount (Measure A+B), Description
(this is the measure that's not fitting into the picture)

Anyone got a better idea on how to do this? I would imagine defining
Description as 1 dimension of its own but that will not make the report
sensible.

Help please?

anyone can be of any assistance here?

"Nestor" <n3570r (AT) yahoo (DOT) com> wrote

Nestor,

Create a Calculated Measure and set its value expression to be an MDX query
that returns a string value.
For example, something like

iif(IsLeaf([Product].[Dept].Currentmember),[Product].[Dept].Currentmember.Properties("Name"),"")

This will return the value of the name property of the current member if it
is a leaf member of the Product dimension.

HTH

Keith

@yahoo.com> wrote

You can also make UDF(User Defined Function) to read the comment column or
others.

Regardless of any level or any cell, if you pass current cell's information
as a paramter to the UDF and receive its related comments, it will be much
more flexible.

Ohjoo Kwon
www.olapforum.com


"Keith" <keith (AT) alh (DOT) com> wrote

operties("Name"),"")