Re-using Logical Column in a different Level-Based Heirarchy — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Re-using Logical Column in a different Level-Based Heirarchy

Received Response
12
Views
1
Comments
Prasanna M
Prasanna M Rank 4 - Community Specialist

Dear Friends,

I have a Business Model with the structure as below.

TF_BMM.JPG

The Dimension Table Products has three columns which are used in an Hierarchy 'Products'. And a couple of reports are designed based on this and are working fine.

Now, I have a Request which is a summary at customer level and has to breakdown into Product level. So, I tried to create another Hierarchy with Customer Name as Parent and 'Product category' as Child and so on, which the system is not supporting.

I could drag customer Name to Parent, but I couldn't drag the other columns into new Hierarchy as shown below.

TF_BMM_1.JPG

Please suggest how to achieve this or any workaround for the solution.

Regards

Prasanna

Answers