Y
Yan
Hi all,
I created some calculated members in a cube and tried to
display them in a PivotTable List. I set the
DisplayCalculatedMembers property of PivotTable ActiveView
to TRUE. But only one calculated member which does simple
division of two measures was shown in the PivotTable. For
other calculated members which use Iif function were not
shown. I am using OWC10. But I found out a strange
solution. If I multiply the SOLVE_ORDER of all the
calculated members by 10 in Cube Editor, and then tried to
display them in the PivotTable. Now I can see all of the
calculated members. But the multiplication does not change
the order in which the calculated members get solved. Can
anyone tell me what the problem might be? Thanks a lot.
Confused
I created some calculated members in a cube and tried to
display them in a PivotTable List. I set the
DisplayCalculatedMembers property of PivotTable ActiveView
to TRUE. But only one calculated member which does simple
division of two measures was shown in the PivotTable. For
other calculated members which use Iif function were not
shown. I am using OWC10. But I found out a strange
solution. If I multiply the SOLVE_ORDER of all the
calculated members by 10 in Cube Editor, and then tried to
display them in the PivotTable. Now I can see all of the
calculated members. But the multiplication does not change
the order in which the calculated members get solved. Can
anyone tell me what the problem might be? Thanks a lot.
Confused