Forum Discussion

cebalorena's avatar
cebalorena
New Contributor II
2 years ago

BI Viewer dynamic calculation graph using Cube View MD

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

 

  

 

 

 

BI Viewer
Dashboards
Parameters
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

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

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

    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