How to do multi pivoting in Hyperion IR

Hello,

I am new in Hyperion IR. We can easily buid a single Pivot view from Hyperion IR Studio. But don't know the right way to build a pivot view which consists multiple pivots (multiple columns).

Currently, we have to union 'Append Query' into one query, then pivot the single column we need, which is actually single pivoting. Does someone know better way to do it in Hyperion IR?

Thank you very much.

Megan