Forum Discussion

bdean's avatar
bdean
New Contributor
7 days ago

Guided Reporting - Multiple Extensible Hierarchy Selection - List Selector Error

I have a Cube View report in Guided Reporting where the user needs to be able to select from anywhere inside of the following three hierarchies. The hierarchies contain extensibility. I am running into an issue where the hierarchies are not appearing correctly, and member are missing in the 'List Selector' on Guided Reporting.

I created my parameter to pull the tree views of all three entity hierarchies.

I have confirmed that the Cube View parameter selection shows up as expected.

When I try to select Entity in Guided Reporting, I see the following:

The only items that are showing under the tree views are the members that do not have any extensibility. Output is showing its children, but it is not collapsable to the parent. If I switch the order over the tree views in the parameter, whichever is the last one listed has its members listed out like Output does in the screenshot. 

I have tried multiple different ways to write the parameter out and have been unsuccessful.

Has anyone else experience this issue? Is there any way to get the hierarchies to display correctly? I am having trouble since the code behind Guided Reporting is locked by OneStream.

 

Thank you!

Cube View
Parameters
Reports
  • sameburn's avatar
    sameburn
    Contributor II
    5 days ago

    Hi bdean

    Have you tried changing your parameter type to Member List instead of Member Dialog?

    Guided reporting is trying to open your parameter using a Member Select button.  

    The Member Dialog parameter type is typically used in a different component e.g Member Tree

    I haven't tested this, but worth a try :D

    • bdean's avatar
      bdean
      New Contributor
      4 days ago

      Hi sameburn ,

      Thank you for the advise. This does help bring back all of the members that are missing when doing the 'Member Dialog'. However, it is still pulling the extensible members out of their original hierarchies. 

      It wouldn't be as big of a deal, if all of the selection came collapsed. With everything coming in expanded, it makes it a lot to click through, if I am looking at a hierarchy further down the list (i.e OP_DEPARTMENT 4).

       

       

  • sameburn's avatar
    sameburn
    Contributor II
    2 days ago

    Have you tried passing your member filter to a QuickView / Cube View, to check it actually returns the desired results based on your data model?

    E.g outside of Guided Reporting 

    • bdean's avatar
      bdean
      New Contributor
      2 days ago

      Yes. The hierarchy looks as expected when running the Cube View outside of Guided Reporting.