QTD Column in a Cube View

Sam_OS
New Contributor

Hi, Is it possible to bring in two Scenarios in a QTD column that are not Quarterly periods like M5 or M7 or M10.

For example if I use Q1 by default it will be March period and for Q2 it will be June. 

But if the user wants to pull in data for M5, In Q2 column can we retrieve two months Actual (M4 & M5) plus One Month Forecast (M6)? Or if the user wants to retrieve data for M4,  can we retrieve one month Actual (M4) plus Forecast (M5 and M6) for Q2 period. Please advise if there is any function to retrieve this in Quarterly Periods or if we need to create a business rule for each quarter. 

Thanks

Samuel

1 REPLY 1

SC
New Contributor III

Hi,

You can use an XFBR rule to dynamically retrieve the scenarios in the report columns based on the current period selection. Use View as 'Periodic' for the respective columns with a 'Total' column at the end.

 

Regards,

S