Forum Discussion

Colin's avatar
Colin
New Contributor II
2 years ago

Variable Name in Bi VIewer

Hi All,

For a Bi Viewer Dashboard I use a Cube View which calculates values with a GetDataCell calculation. I display the values in a line chart. The values are displayed correctly, but the calculated variable name in the legend does not match the defined name in the Cube View calculation, instead the first used account name from the calculation is used.

How can I use the name I defined in the cube view cell in BI Viewer, or if it is not possible, how can I rename the variable name manually in BI Viewer?

BI Viewer
Cube View
Dashboards
  • JackLacava's avatar
    JackLacava
    2 years ago

    If I understand correctly, you'd want those records to be marked "COGS %", is that right?

    The easiest way to go about that is to create a Calculated Field in Bi Viewer, by right-clicking on the datasource name:

    In the Expression Editor that comes up, you just enter the name you want, surrounded by single-quotes:

    That will return the value 'My Name' in that field for all records. If you need more complex logic, you can implement it with a more complex expression, like IIF etc. For example, to replace an account name, you'd use Replace([Account], 'MyWrongAccount', 'COGS %')

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    Hey Colin,

    could you post the CV calculation definition please? And are you using the CV Data Adapter or the CV MD one?

    • Colin's avatar
      Colin
      New Contributor II
      2 years ago

      Hi Jack,

      this is my CV calculation: GetDataCell(Divide((A#GP - A#Sales), A#Sales)):Name(COGS %)

      And I´m using the CV MD Command Type.

      • JackLacava's avatar
        JackLacava
        Honored Contributor
        2 years ago

        If I understand correctly, you'd want those records to be marked "COGS %", is that right?

        The easiest way to go about that is to create a Calculated Field in Bi Viewer, by right-clicking on the datasource name:

        In the Expression Editor that comes up, you just enter the name you want, surrounded by single-quotes:

        That will return the value 'My Name' in that field for all records. If you need more complex logic, you can implement it with a more complex expression, like IIF etc. For example, to replace an account name, you'd use Replace([Account], 'MyWrongAccount', 'COGS %')