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