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 sho...
Cube View
Parameters
Reports
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.