Forum Discussion

Marco's avatar
Marco
Contributor II
7 months ago

Quickview: Exclude entity if it does not contain a Text1

Hi All.
Is there a way to exclude entities that do not have a Text1 from the following?

E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base

or

E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1)

Since I have that in my data management and it shows an error if it does not find Text1, I need to exclude those that do not have Text1

Cube View
Excel Add In

1 Reply

  • chul's avatar
    chul
    Icon for OneStream Employee rankOneStream Employee
    6 months ago

    Hi, the filter you're using returns the text1 rather than the entity name. So based on what you've described, you'll want to use a filter that returns the entity name where text1 isn't blank. Something along the lines of E#Parent.base.where(Text1 <> ''). Now it adds a bit of complexity if the text1 you're returning contains a different entity name than the entity that's being processed. For example, if entity E1000 has a text1 of E2000, then E2000 is being sent to this DM job. You can accomplish this using an XFBR rather than a member filter.