Skip to main content
O
OSuser
November 17, 2025
Solved

Monthly Breakdown and Annual Total in Cube View

  • November 17, 2025
  • 1 reply
  • 0 views

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|)

 

Best answer by TGG_Alex

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.

1 reply

T
TGG_AlexAnswer
November 18, 2025

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.

Terms & ConditionsAccessibility statement