BI #MULTIVALUE error when grouping

[denis_konovalov]

Hi, I am using 3 linked queries to build a hierarchical report of committees and subcommittees from a flat table of parent-child references. I've been able to get the results I want from my queries as below (1.), but when I set the first two columns as Sections I get the #MULTIVALUE error shown below (2.). If I undo the the inner Section, then it works fine (3). Any suggestions for fixing this problem with the inner section? I would like to be able to nest the Sections no matter how many levels of parent-child relationships. I only have permissions to use the BI platform and do not have access to the universes Thank you.

Figure 1.

Figure 2.

Figure 3.

[denis_konovalov]

I have fixed your tags, please do select more careful next time.

[mhmohammed]

Hi Tom,

I see that you created Detail variables for some columns to be displayed in the tables, I assume that may be causing the issue. E.g. The 4 different L02 Related Comm Name values you see under Coastal Council (L01 Comm Name), are they coming from the same query or different query? You can only show detail objects in a table, if it's relation to it's Associated Dimension is 1:1.

Apart from that, if you've all dimensions coming from the all the queries, you don't have to create Detail objects.

Thanks,
Mahboob Mohammed