06-09-2022 11:35 AM - last edited on 05-23-2023 05:48 AM by JackLacava
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,
Solved! Go to Solution.
06-09-2022 02:41 PM
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.
06-09-2022 12:25 PM
You could try an dashboard XFBR which would return the list of entity based on the workflow directly in your cubeviews
06-09-2022 02:41 PM
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.
06-10-2022 02:50 AM
Thank you, you guys rock !