Forum Discussion

ysapiyev's avatar
ysapiyev
Icon for Responsive Resident rankResponsive 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

ysapiyev's avatar
ysapiyev
Icon for Responsive Resident rankResponsive Resident
7 years ago

v-piga-msft

 

Attached report. You can see, that org_unit_2_2 has value 1400. How can I save this value and set value of org_unit_2_2_1 and org_unit_2_2_2 to 0?

 

Regards,

Yerkhan

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident 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