Forum Discussion
Hierarchy not available
Hi ibarrau,
Indeed, my data source is a tabular model.
i can't put my fields one under the other because I have the field "value" in my lesion table and another field "value" in my lesion_details table. So if I put lesion.level 1 field and lesion_detail.level 2 field in the legend of my pie, there is no data displayed at all, it's not compatible.
Do I have to put all my lesions in the same table with level 1 and level 2 in the table directly ? and then build the hierarchy with level 1 and level 2 ?
Or do I have to build a hierarchy in my cube ? if so, how can I do this ?
Thanks a lot, AnneSo
Super UserI'm sorry I have just checked again and you shouldn't put anything in Details. Just add level 1 and level 2 in legend. Then drag the value and you will have your drilldown in the pie chart!
About tabular you can't modify anyting of the model when you have a live connections. It will only let you create measures. If you want anything else you need to modify the source data model.
Regards,
Hi,
Thank ibarrau, it works now. But I am facing another issue now 😞
Let me explain. As I said, I have 2 levels of injuries in my report. I have created 2 separated table to do so, one for global level, let's say level 1, one for details, level2.
The problem is the (sum of ) number of injuries is not the same between level 1 and level2.
Here is my data to explain :
So, as you can see, the total number of injuries at level 1 is 36. And at level 2, it's 39. Because one accident can have several injuries, but we only count one for the global, the worst let's say.
My problem is the % calculated in my drill-down for level 1 : it is calculated based on level 2 total, not on level 1 total...
Here are the fields I put in my pie for the drill down :
Don't know if my model should be built differently ?
Do you have an idea how to solve this ?
Thanks a lot for your help, AnSo