Skip to main content
S
Sergey
October 22, 2024

nested CustomMemberList with |MFUD1| ?

  • October 22, 2024
  • 2 replies
  • 0 views

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 ?


Sergey_0-1729586863393.png

Regards,

2 replies

T
T_Kress
October 22, 2024

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?


T_Kress_0-1729608420105.png

 

D
db_pdx
October 22, 2024

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.

Terms & ConditionsAccessibility statement