Forum Discussion

Sam_OS's avatar
Sam_OS
New Contributor
2 years ago

QTD Column in a Cube View

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

Cube View
  • SC's avatar
    SC
    New Contributor III
    2 years ago

    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