Forum Discussion

Clinkscake's avatar
Clinkscake
New Contributor III
11 months ago

Advanced Chart Secondary Y Axis

We are trying to create an advanced chart using a secondary y axis and are running into issues.  We referenced https://community.onestreamsoftware.com/t5/Implementation-Q-A-Archive/Question-In-Advanced-Chart-component-of-a-Dashboard-can-you-show/ta-p/1551 blog which explains how to code the business rule.  However, there is no place within the chart to reference the cubeview and when we run the dashboard, we get an error message stating the data adapter type does not match the chart type.  Any solutions or if there's any document we can refer to which would show end to end flow around the cubeview, data adapter, business rule, and chart?  Below are screenshots of our data adapter, chart, and dashboard error.

 

Dashboards
Parameters
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    11 months ago

    You can't mix and match Cube Views and Dashboard DataSets; the Data Adapter linked to the chart must be pointed at the DDS business rule, which will provide all the data.

    In the example you linked, basically there will be two data adapters: one of type Cube View (let's call it "daCV") and one Method / Business Rule ("daBR"). The chart is linked exclusively to daBR; on execution, daBR will invoke daCV and wrap the result to apply the changes mentioned.

    • Clinkscake's avatar
      Clinkscake
      New Contributor III
      11 months ago

      Thank you for the help!  We created a new data adapter that is Method which should run the Business Rule and one that is Cube View the Business Rule points to.  The Cube View data adapter runs as expected, but we aren't sure we setup the Method data adapter properly.  Is this the right coding for method query?  When we run the Business Rule data adapter, we don't get any results.

      • JackLacava's avatar
        JackLacava
        Honored Contributor
        11 months ago

        Try with square brackets instead of single quotes, around TTM_EBITDA. The rest looks fine. If it still doesn't work, you'll have to troubleshoot the rule... Looking at the post you linked, I'd make sure your original series is actually populated before it's modified, because all those parameters to FillUsingCubeViewDataAdapter look tricky to get right.