Grouping Columns based on Data like MTD,QTD,YTD in OAC/OTBI

Vaigu_27

Hello,

We have a requirement to display Data based on the Time Series to group MTD Data Columns under MTD Group Column in OAC/OTBI

We can display data by placing columns side by side in the Pivot Table for Actual, Budget,Prior Year Actual, is there a way we can display Additional column as MTD as group column at above & display respective Actual, Budget MTD columns below .

Attaching Example Report Layout for Reference

Please let us know your thoughts to achieve above requirement

BalagurunathanBagavathy-Oracle

@Vaigu_27

In Classic analytics / OTBI, you can create a UNION ALL report. Each query in the UNION ALL will correspond to each type of measures such as MTD, QTD and YTD and have a dummy column to identify the type of measure as shown below:

Final output looks like this:

Vaigu_27

@BalagurunathanBagavathy-Oracle ,

Thanks much we could achieve our layout with your mentioned approach.

Is there a way we can bring this layout without Union Query ?

BalagurunathanBagavathy-Oracle

@Vaigu_27

If the approach helped you achieve the requirement, please accept my answer. I am afraid if there is any other approach.

Vaigu_27

@BalagurunathanBagavathy-Oracle ,

Thank you for the response, i have accepted the answer.

Just wanted to know is there a way to group columns apart from Union Query.

Do post your thoughts on this.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/56003#Comment_56003

Very helpful information.

Thank you very much @BalagurunathanBagavathy-Oracle!