Forum Discussion

AiLie's avatar
AiLie
New Contributor II
4 days ago

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 repeater" where the component is data explorer report.

Data explorer report has data adapter component to the Cube View. I thought the way to do this would be to use the template parameter values in the collections. But it shows error as attached below.

It seems that the template parameter value was not passed to Entity_select parameter. 

Is data explorer report component compatible for dashboard embedded dynamic repeater?

Is there any sample of Embedded dynamic repeater dashboard using data explorer report component?

TIA,

Nuryana

Dashboards
Parameters
Reports

3 Replies

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    4 days ago

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

    • AiLie's avatar
      AiLie
      New Contributor II
      4 days ago

      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