Forum Discussion

WillVitale's avatar
WillVitale
Contributor
5 months ago

UD8 Viewing Level 2 Filter

Hello,

I'm creating a cube view and I created a U8 that looks at Entity text 5. Using the following formula.

Dim cfoHelper As New OneStream.BusinessRule.Finance.CFO_FormulaHelper.MainClass
Return cfoHelper.GetMember("Entity","Text5", api, si)

I've added it to the my CV but it only gives me the text 5 for the entity and not the IC, in which I need it to be. Since IC and Entity go together, is there a way to have it read the IC value for text  5 which is my Level 2 filter? Entity is the level 1 filter and I need to pull all base level entities and the IC entity it has done business with a particular account.

So the final column shouldn't all say "CTB" since that's the text associated with the USA entity. I need to it read what text 5 says for the IC member in the level 2 filter.

Thanks,

Will

  • WillVitale's avatar
    WillVitale
    5 months ago

    Yes, I was able to create a UD8 that pulled the text value for the IC dimension that looked at the entity

    Return api.entity.text(api.pov.ic.memberID,5,0,0)