Skip to main content
J
jana_seinige
Contributor
September 13, 2022

WF POV within a member list

  • September 13, 2022
  • 1 reply
  • 0 views

Hi

I'm trying to get the current pov - cube and entity - within a member list (i'm using for selection as drop-down).

Unfortunately the api.pov.entity.name is in this case not returning the wf pov, but the cube pov.

The args.SubstVarSourceInfo.WFCubeRoot doesn't work as well.

Any ideas?

Thanks Jana

1 reply

J
jana_seinigeAuthor
Contributor
September 13, 2022

In the meantime, i have managed to give the wfcube as paramater, but not the entity (and this I need as well).

H
OneStream Employee
HenningOneStream Employee
OneStream Employee
September 13, 2022

Hi Jana,

not sure where the WFEntity is that you are referring to. In the WF POV, the selection is WF Profile, Scenario and Time:

Henning_0-1663075264838.png

Do you have the entity name in the name of the workflow? Or do you mean the entities that are assigned to the workflow profile?

Assuming you have the entity name in the workflow profile name, you could e.g. use an XFBR like that:

 

'XFBR(ReportingHelper, ReturnEntityFromWFName, WFProfile = [|WFProfile|])


If args.FunctionName.XFEqualsIgnoreCase("ReturnEntityFromWFName") Then
Dim WFProfileName As String = args.NameValuePairs.XFGetValue("WFProfile")
Dim entityName As String = ...derive entity name from WFProfileName string...

Return entityName

End if

 

As for assigned entities, you can use a bound list parameter (as more than one entity may be assigned):

Henning_1-1663075880988.png

Select a profile with assigned entities and then run the parameter to see what it returns exactly:

Henning_2-1663076028543.png

 

J
jana_seinigeAuthor
Contributor
September 13, 2022

Hi Henning

Thanks for your help!

 

I was trying earlier with the WFProfile name, but it was not working until putting it in square brackets. Now it works fine, many thanks.

 

Just strange, that this works:

I#Root.CustomMemberList(BRName=MemberLists, MemberListName=Entity_Recon, P1=|WFCube|)

but this not:

I#Root.CustomMemberList(BRName=MemberLists, MemberListName=Entity_Recon, P1=|WFProfile|)

 

it only works like this:

I#Root.CustomMemberList(BRName=MemberLists, MemberListName=Entity_Recon, P1=[|WFProfile|])

    Terms & ConditionsAccessibility statement