Forum Discussion

CLU's avatar
CLU
New Contributor II
17 days ago

Bi Designer

Working with BI Designer and cannot get the Time order in place sequentially. The Cube View data source is pulling the correct time, data, alongside the POV for workflow. The WF filter builder is in order. However, cannot get the two months (Oct and Nov) in the appropriate place. Tried to sort and use Start/End Dates too in settings for 

WF Time Filter: 

T#WF, T#WFPrior1, T#WFPrior2, T#WFPrior3, T#WFPrior4, T#WFPrior5, T#WFPrior6, T#WFPrior7, T#WFPrior8, T#WFPrior9, T#WFPrior10, T#WFPrior11, T#WFPrior12, T#WFPrior13

Has anyone experienced this before? 

 

 

BI Viewer
Reports
  • CLU's avatar
    CLU
    17 days ago

    That did the trick... needed the Month-Year. Thank you!

  • matt515's avatar
    matt515
    New Contributor III
    17 days ago

    Set the data source to use a cube view MD. Set Add Start End Calendar Time to True which looks like you've done. I sometimes will just set the Time to use the Description instead of Name and Description. 

    Then use these two new fields: EndDate/StartDate in the BI Viewer graph. Place either Start/End Dates in the Arguments and right click and change it to Month-Year.

    • CLU's avatar
      CLU
      New Contributor II
      17 days ago

      That did the trick... needed the Month-Year. Thank you!