Forum Discussion

ysapiyev's avatar
ysapiyev
Responsive Resident
7 years ago
Solved

Data selection in heirarchy

Hi everyone.   I have a report with live connection to SSAS cube. There are hierarchy of org units: org_unit1 => org_unit2 => org_unit3. I have values in measures for org_unit2, so at org_unit1 th...
Need Help
  • ysapiyev's avatar
    ysapiyev
    7 years ago

    Hi,

     

    I solved it by using calculations in OLAP cube, by setting case for hierarchy level. Here is more information.

     

    Regards,

    Yerkhan

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi ysapiyev,

 

Sorry for the delay.

I have values in measures for org_unit2, so at org_unit1 they sum, which is correct, and at level of org_unit3 it shows value for org_unit2. Is it possible to get 0 at org_unit3 level? 

Is the Value column a measure? If it is, please share the formula of the measure.

 

I'm confused about getting 0 at org_unit3 level. If it is convenient, could you share your desired output and explain your logic.

 

Best Regards,

Cherry

ysapiyev's avatar
ysapiyev
Responsive Resident
7 years ago

Hi,

 

I solved it by using calculations in OLAP cube, by setting case for hierarchy level. Here is more information.

 

Regards,

Yerkhan