We are under construction!

You may experience downtime, errors or visual oddities, but we anticipate all will be resolved by the end of the day.

Forum Discussion

KurtMayer's avatar
KurtMayer
Contributor
5 days ago

Basic Question about BI Viewer and Cube View MD data source Column Expression

I have a Cube View with three Account dimension columns - Net_Rev, Std_Cost, and a CVC calculated division column to calculate Std_Margin (Std_Cost/Net_Rev). Rows are a UD dimension representing the Product.  In my Dashboard, I have a Cube View MD Data Adapter using this Cube View as the data. 

When I add a BI Viewer Pivot Grid, I want to display the same three columns - Net_Rev, Std_Cost, and the calculated column. I see CalcScript in the Pivot Grid's Data Source dimensions. How do I use it in the Pivot Grid to display the calculation that the Cube View was doing for that third column?

I thought I might reference it in the Value filter along with the two Accounts, but it doesn't appear as a column in the Pivot Grid.

 

BI Viewer
Cube View
Reports
  • VishalPai's avatar
    VishalPai
    Contributor
    2 days ago

    KurtMayer  - we can use CalcScript as column and it will show the calculated value as 3rd Column, the column header will show the formula

  • Pete's avatar
    Pete
    New Contributor
    2 days ago

    You may also want to try using the Account filters in the getdatacell in the cube view instead of CVC math, if possible. I'm curious to see if that would make a difference. When you run just the data adapter, do the values come in for the calculated column?

  • T_Kress's avatar
    T_Kress
    Contributor III
    3 days ago

    One solve may be to make your 3rd CV column a dynamic U8 calc that you can pull into your CV versus CV math.  Then that 3rd column may pull through correctly to BI viewer without having to re-write the calc in BI viewer.  Maybe a round about solve.