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,

If you've data coming from multiple queries, did you merge dimensions on Level 0, Level 1, Level 2 and Level 3? If not, please do that, and use the merged objects in the variables for grouping, to create a Section on, and in the table.

Thanks,
Mahboob Mohammed

[Former Member]

Denis, thanks for fixing my tags!

Mahboob, thanks for your answer. Yes, I merged all of the common dimensions and created detail variables, which are displayed in the tables. The first screen shot above shows that the queries are working, but the problem I'm having is with "Set as Section" option. It breaks when I add the 2nd Section, which is the first Section within a Section. The screenshot below shows the merges.