Skip to main content
R
RafMarques
Newcomer
July 18, 2023

Return items from one dimension based on another dimension

  • July 18, 2023
  • 1 reply
  • 0 views

Hello

I have a CubeView with 2 nested rows.

Row 1 - |!varEntity!|.Base (say this will return 5 entities - this is a drop down in a Dashboard)

Row 2 - XFBR(myModule_ParamHelper, GetWBS_by_Entity, Entity=|!varEntity!|)

This rule checks for WBSs where Text2 = Entity (i.e. WBS1 - Text2 = Entity1, WBS2 - Text2 = Entity2)

When I execute the CubeView, I see all the 5 Entities, and in the nested Row, I get the WBSs where Text2 = the first Entity only).

I understand why it is doing this, as the variable gets the same value and passes to the rule.

I also tried |PovEntity| and |CVEntity|. 

PovEntity returns blank, and CVEntity return what is in the Cube Pov section, which I tried with a value or blank.

I also tried WBSDim.Base.Where(Text2 = |CVEntity|) --- or PovEntity - comes blank

Is there a way to pass the value of each evaluated Entity row to the WBS row?

The result should be something like:

Entity1 WBS1
  WBS2
Entity2 WBS3
  WBS4
  WBS5

 

Thx

Raf

    1 reply

    C
    cjohnson
    Newcomer
    July 19, 2023

    I've done something similar in the past using the XFMemberProperty. If I'm understanding the desired outcome correctly, try something like WBSDim.Base.Where(Text2 = XFMemberProperty(DimType=Entity, Member = |MFEntity|, Property=Name). I want to say MFEntity works in this situation, but it's been a minute since I did this.

    R
    RafMarquesAuthor
    Newcomer
    July 19, 2023

    Hi,

    I tried this now but it complains about ","

    U3#WBSDim.Base.Where(Text2 = XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Name))

    RafMarques_0-1689777020555.png

    I believe I can't use it since, based on the documentation, it should be used with Name and GetDataCell.

    "Use this function with the Name() and GetDataCell() portion of a Member Filter."

    Thank you

    C
    cjohnson
    Newcomer
    July 19, 2023

    Went back and reviewed and you are correct. I was using a param to pass it along...

    E#|!varEntity!|

    U3#WBSDim.Base.Where(Text2 = XFMemberProperty(DimType=Entity, Member=|!varEntity!|, Property=Name))

    But because you are pulling the E# at .Base it makes it a bit more tricky.

    Terms & ConditionsAccessibility statement