Forum Discussion

EG's avatar
EG
New Contributor II
25 days ago

How do I remove parameter prompts from WF?

I am using a Cube View (IS) within a dashboard. The client does not want users to be prompted with parameters for selecting Entity, Time, or View. Instead, they expect these dimensions to be driven automatically by the Workflow Point of View 

While I’ve successfully applied WF  Time and View dimensions in the CV to align with the Workflow POV, I’m encountering an issue with the Entity dimension. It does not respond to the Workflow POV such sd WF, WFProfile, etc..  I either have to hardcode it, or use the Parmeter. Can I create a parameter that does not prompt a user make a selection?

Cube View
Dashboards
Parameters
Reports

3 Replies

  • Olaf_A's avatar
    Olaf_A
    New Contributor III
    25 days ago

    The problem is probably that you can have multiple Entities assigned to a WF, so OneStream would not know which ones to choose. There are no substitution variables for Entity in WF. 

    If you only have 1 entity assigned, an option could be to create an XFBR that just retrieves and returns the assigned entity (GetProfileEntities).

    • EG's avatar
      EG
      New Contributor II
      25 days ago

      Ahhh, yes — I have a parent entity with seven base entities under it, each managed by its own controller. The client requested separate Workflows (WF) for each of these base entities. So essentially, I’ll need to use an entity parameter to handle this structure, correct?

  • Olaf_A's avatar
    Olaf_A
    New Contributor III
    22 days ago

    It could be just an XFBR. The idea here is to return the exact string as you would enter it if you wanted to fix the Entity in the Cubeview. The following would work (in the example I use a Service Factory in a WSMU, but other XFBR calls would work as well):

    And then in the XFBR something like:

    If args.FunctionName.XFEqualsIgnoreCase("GetProfileEntity") Then
	Dim profileEntities As List(Of workflowprofileentityinfo) = BRApi.Workflow.Metadata.GetProfileEntities(si, si.WorkflowClusterPk.ProfileKey)
	Dim ProfileEntity As workflowprofileentityinfo = profileEntities(0)
	Dim ProfileEntityName As String = ProfileEntity.EntityName
	Return ProfileEntityName
End If

    We actualy also have the situation with one workflow for each entity. The names of the workflow correspond more or less to the entity name, so we use the workflow name as well to derive the entity sometimes.