Forum Discussion

OSuser's avatar
OSuser
New Contributor
7 days ago

Monthly Breakdown and Annual Total in Cube View

I am creating a cube view. 

Currently, it is showing monthly view and annual total for Workflow year, but future years (2027 and 2028) are not showing annual total only.

What should change to show both monthly breakdown and annual total for outer years (2027 and 2028)?

T#|WFYear|.Months, T#|WFYear|, XFBR(Year_ParmSelect, SelectYearsRPT, YearsReport = |!ProcessYears!|, CurrScenario = |WFScenario|, wfYear= |WFYear|)

 

Cube View
Parameters
Reports

1 Reply

  • TGG_Alex's avatar
    TGG_Alex
    Contributor II
    6 days ago

    Your initial syntax is on the right track.  T#{Year}.Month will return the months of the specified year.

    You have an XFBR handling the rest of the selection under Year_ParmSelect function SelectYearsRPT.  It is likely with a small tweak to that rule, you can also return the .month of that year.

    Just be cognizant of the number of columns this might return and its usability.

     

    Cheers,

    A.