Forum Discussion

Sergey's avatar
Sergey
Contributor III
2 months ago

nested CustomMemberList with |MFUD1| ?

Dear community,

I'm currently stuck with a cube view.

My cube view have Projects (UD1) is first element of the row, then Cost Center (UD4) is second element of the row.

The requirement is to show "Tot_CC" (UD4 dimension) when we are NOT in base level of project, but show base members of cost centers when we are in base member of project.

I am using a CustomMemberList which should look at |MFUD1|, however the business rule is not parsing it, as the ErrorLog show me that the formula is looking for |MFUD1| and not the element which was specified in the first level of the row (see below). IS there another way to define conditional list of elements based on the first level ?

Regards,

Cube View
  • T_Kress's avatar
    T_Kress
    Contributor III
    2 months ago

    Can you double-stack both U1 and U2 in the first row?  I think |MFUD1| is not available in the second row because the dimension in the second row is U4.  I think that is the problem.

    Wondering if you put them both in row 1 if that would work?

     

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    2 months ago

    Hi Sergey: if memory serves me correctly, |MF-MemberFilters| cannot be used in CustomMemberLists.

    What if it was U1#Total_UD1.Tree with U4 nested as U4#Total_UD4.Member.Base? Use either Collapse all, or one of the TreeExpansionLevelX settings for the header format

    The combo of the two should allow a user to drill down the UD1 while the default UD4 is at top. When they get to the level they want they can switch to drilling into the detail of UD4.