Creating a universe with oracle database

[former_member270991]

I am trying to build a universe on an oracle database that was designed to be dynamic, meaning that all the data fields are in one table in different rows.  I am able to create dimensions using a Case Statement but queries will return results on different rows.  I realize that this is due to the data residing in one table in rows as opposed to columns but is there a way to build a business layer so that the results will be on one row? 

[Former Member]

Hi Heather,

You may want to explore the options for Pivot/Unpivot in Oracle. The following link would help in understanding how to turn rows into columns and vice versa.

11g-pivot.html

[Former Member]

Sample data and expected output might help us provide you more detailed solutions.

[Former Member]

Hi Heather,

You need to use aggregate function on top of your case statement. May be using max.

[Former Member]

Hi,

Have your tried converting your vertical table into a cross tab? Check if it helps.

Try sharing some screenshots with sample data if possible.

Regards,

Yuvraj

[Former Member]

I would suggest to go for a Database view or a Derived table on Universe level if that suits your requirement.

Regards

Niraj