Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
I am having same problem. Were you able to get any solution??
Give labels for calculated dimensions in group settings which may solve the problem.