Convert Webi Report Queries to one SQL

[former_member194139]

Hello Experts,

I've a requirement to convert the webi report in to One SQL and give to to client so they can find the SQL in database and get the results.

This WEBI report has 2 Queries and using the MERGE dimension feature.

And I've a column in report having variable as AMT = SUM(Query1.X_Amt + Query2.Y_Amt)

Please help me on how to put these two queries together and calculate the AMT.

Thanks in advance

[former_member194139]

Thank You Sanjay for quick response. These are not Bex queries. The database is Netezza and report created on Universe. All three repor queries using same universe.

Here is query 1

Select Case ID, Dimension Object1, Dimension Object 2, Amt_1

From ............

Where

Condition1

Prompt Enter Month

Query 2

Select Cse ID, Dimension Object 3, Amt 2, Amt3, Amt 4

From ...

Where

Condition2

Prompt Enter Month

Query 3

Select Cse ID, Dimension Object 4, Amt5

From ...

Where

Condition2

Prompt Enter Month

Now final output I need is

Dimenison Object1, Dimenison Object 2, AMT = Amt1+Amt4+Amt5

This is how my queries are. Please help me whether UNION is possible or Not.

Thanks!