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 a...
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.