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,

 

I cannot have access to your report as I don't have permission.

 

You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry