Embedded dynamic repeater
I have a cube view with a parameter on Entity |!Entity_select!| that I would like to put in a tabbed dashboard that has one tab for specific Entity member. I am using dashboard type "Embedded dynamic...
Forum Discussion
JackLacava
OneStream Employee
OneStream EmployeeThe only way to go about this without code is to reference the template parameter directly in the cube view (rather than going through a Parameter), which works fine if you embed Cube View Components directly. Obviously this does not give you a report, but the CV can export as Report - it's just an extra click.
If you try to go through Data Adapters, this strategy breaks. It is doable via a full Dynamic Dashboard Service implementation (i.e. in code), although in 8.5-9.1 this too is not possible because of a known issue which should be fixed in 9.2.
A workaround (again in code) could be to implement your own DataSet rule that uses FdxExecuteCubeView and returns the same table that a Cube View adapter would return; you then create a Data Adapter of type Method/Business Rule to execute the rule, passing as argument a template parameter (e.g. {MyBR}{MyFunction}{Entity=~!myTplParamEntity!~} ). This should work, although I've not tested it...
Hi Jack,
Thank you for your explanation. I tried your suggestion without code by referencing the template parameter directly in the cube view.
Then on the workspace I create component cube view.
Then in dashboard, use embedded dynamic repeater with collection as below and use the cv component in dashboard component.
I can't see the result on the dashboard. It seems that the cubeview doesn't get the template parameter value.
Did i set it correctly?
Regards,
Nuryana
- JackLacava
Yes, that looks correct. It works for me on 9.2.
