How to combine multiple pivot into one pivot in oracle fdi

Question

How to combine multiple pivots into one pivot in oracle fdi workbook..

User_OCIPE · Answer

Hi Experts, how to get the Variance and Variance % in Pivot

I have columns

Label         Split by Scenario

Revenue   Actual     Budget

JohnW-Oracle · Answer

Hi @SaravananPandian

You could create multiple Canvases, each with its own Pivot.

Also, one Dashboard could include multiple pivot Visualizations.

You generally can’t merge several existing pivot views into one. Build one pivot from the combined data instead.

If the pivots are from the same FDI subject area:

Create or edit one analysis/workbook.

Add the common row attributes once.

Add the measures from each pivot to the same visualization.

Put the comparison attribute—such as fiscal period, scenario, ledger, or category—on the pivot columns.

Use filters or calculated measures to distinguish each prior pivot’s subset.

See the documentation here:

https://docs.oracle.com/en/cloud/saas/analytics/23r2/fawug/create-workbook-and-add-visualizations-fawug.html

Regards,

John