Label of a Derived Dimension in Drill Down Group

[#1]

Hi All,

I have a dimension group with five dimension, called DimGroup1:

2 of the bottom most dimensions in the group are calculated dimensions and they work find in a straight table.

My problem is that the labels for the 2 calculated dimension in the group throw out the whole expression.

I tired changing the label in the Group Tab of the Document Properties, but that label works only within the chart while drilling up and down.

However, If I try to use the the expression =getCurrentField(DimGroup1), and reach the hierarchy level of the calculated dimension, it just throws out the whole expression there instead of the label I set.

This is really strange. I am stuck as I am trying to base some logic on the =getCurrentField(DimGroup1) expression value, and it goes bust.

Please help

Thanks

Raghu

[#2]

Hi,

Make use of Pick and WildMatch function on your expression.

there must be some specific words matching on your two calculated dimension.. use it as a reference on your wildmatch.

[#3]

I am having same problem. Were you able to get any solution??

[#4]

Give labels for calculated dimensions in group settings which may solve the problem.