BI Viewer dynamic calculation graph using Cube View MD

[cebalorena]

Hi , wonder if someone can help me, I have a dynamic account 

% = Dynamic calc Return api.Data.GetDataCell("Divide((A#Account ), (A#Account2 * 1060))") which works great in the CV , but in the graph it does not bring the calculation correctly, 

BI pulls the "average" of the YTD of the CV (orange cell)

value I am looking for is the YTD calc.  should be %75.1

it does work if I bring the Time in the filter for the YTD graphs, 

  

my CV is bringing T#WFTime, so the filter wont work as dynamic dashboard. 

Same issue with QTD, amounts in the CV in yellow are the correct values, 

BI Viewer is has the average of the year

if I hard key the WFTime it will only display one QTR

I think my problem in the value, what condition rule do I need to have? the closest to actuals is average, but is not correct

Hopefully is something simple, I just cannot figure it out. 

thank you

LC

[JackLacava]

What type of Data Adapter are you using, CubeView or CubeView MD? I tend to find the MD one easier to work with.

[cebalorena]

Hello, I am using Cube View MD, I think the work around is to do 3 different CVs with the value,  but I was wondering if there was a trick to read the WFtime, or to get the last period of the view.

TIA