Help using Base SAS procedures

Proc OLAP and MDX instructions

Reply
N/A
Posts: 0

Proc OLAP and MDX instructions

Hi... I need help with proc olap and instruction MDX.

I have a cube that contains one 'Dimension' ( name: DIM_Local ) , four 'Hierarchies', and, in each hierarchie, there are several 'Level's. So, in 'Calculated Members' I have the following instruction:

([DIM_Local].CurrentMember,[Measures].[volSUM]) /([DIM_Local].CurrentMember.Parent,[Measures].[volSUM])

However, the result of the calculated members only happens to hierarchies selected as default. When I select a different hierarchie the result is "missing".

Which instruction I must use that calculates any selected hierarchy, independently if the hierarchy is "default" or "not default"?

Thanks.
Ask a Question
Discussion stats
  • 0 replies
  • 111 views
  • 0 likes
  • 1 in conversation