Cube View to automatically select Workflow entities

Sergey
Contributor III

Hi,

I am building cube views that should be accessible by several users based on the workflow they are affected to.

 

These cube views are the same, but each workflow has its own entity. Therefore, the same cube view will be available through several workflow, and the entity (or entity selection) should change based on entity affected to each workflow profile.

 

I'm probably missing something, but the problem is that there are no (known) parameters that would simply give me the list of entities attached to the current workflow profile... what would be the best way to achieve this ?

 

Regards,

1 ACCEPTED SOLUTION

Cosimo
Contributor II

Is the workflow entity set in the cube view's POV? You can use  E#Root.WFProfileEntities as a member filter to fetch entities that are assigned to a workflow though you need to have the Entity dimension setup as a cube view row or column. 

Option 2 would be to create a dashboard parameter of type Member List and and set the Member Filter field to E#Root.WFProfileEntities. You then assign this parameter to your cube view Entity POV.

 

Option 3 like Sudarshan mentioned above is to create an XFBR rule that returns the entity assigned to workflow:

Dim WfGUID As guid = si.WorkflowClusterPk.ProfileKey 'gets the profile key from user's current workflow
Dim EntityList As List(Of WorkflowProfileEntityInfo) = BRApi.Workflow.Metadata.GetProfileEntities(si, WfGUID)

Return EntityList(0).EntityName 'Returns to calling XFBR the 1st entity assigned to workflow.

 

View solution in original post

3 REPLIES 3

sudarshan
New Contributor III

You could try an dashboard XFBR which would return the list of entity based on the workflow directly in your cubeviews

Cosimo
Contributor II

Is the workflow entity set in the cube view's POV? You can use  E#Root.WFProfileEntities as a member filter to fetch entities that are assigned to a workflow though you need to have the Entity dimension setup as a cube view row or column. 

Option 2 would be to create a dashboard parameter of type Member List and and set the Member Filter field to E#Root.WFProfileEntities. You then assign this parameter to your cube view Entity POV.

 

Option 3 like Sudarshan mentioned above is to create an XFBR rule that returns the entity assigned to workflow:

Dim WfGUID As guid = si.WorkflowClusterPk.ProfileKey 'gets the profile key from user's current workflow
Dim EntityList As List(Of WorkflowProfileEntityInfo) = BRApi.Workflow.Metadata.GetProfileEntities(si, WfGUID)

Return EntityList(0).EntityName 'Returns to calling XFBR the 1st entity assigned to workflow.

 

Sergey
Contributor III

Thank you, you guys rock !