webi reporting

[Former Member]

Hi...

We have a webi report which is build from two databases.one is oracle and the other is sybase. So the common objects are merged.As they are merged it gives me all the values from both the databases.But i need to have a column in such way that it should display all values of oracle and the uncommon values of sybase.

Oracle:a,b,c,d,e(values)

Sybase:a,k,j,b,i,c(values)

Now when i merge these two objects i get a,b,c,d,e,a,k,j,b,i,c.

But i only need a,b,c,d,e(all oracle values) + k,j,i(sybase values not common with oracle).

Note:it is similar to the minus function.

Please help....i need to build this report soon.

[Former Member · Accepted solution]

Hi,

When you use merged dimensions it is normally a union or a full outer join between the two dimensions. To achieve Minus try using the following work around:

First of all you need to have additional dimensions in both the queries apart from merged dimensions. For example:

Oracle(values):_Dim A_ Dim B

A - ABC

B - BCD

C - CDE

D - DEF

Sybase(values):Dim C Dim D

B - SKL

D - WER

E - KDF

Consider Dim A and Dim C are merged dimensions. Make Dim B and Dim D as details and include everything in the report, the report looks something like this:

Dim A Dim B Dim C Dim D

A ABC NULL NULL

B BCD B SKL

C CDE NULL NULL

D DEF D WER

NULL NULL E KDF

Now if you want values from Oracle and not values from Sybase keep a filter on Dim B which will filter out all the null values in Dim B. Then the report looks some thing like this:

Dim A Dim B Dim C Dim D

A ABC NULL NULL

B BCD B SKL

C CDE NULL NULL

D DEF D WER

If you want values from sybase and not values from oracle keep a filter on Dim D. After that you can hide the dimensions you don't need. However, they have to be in the report you just have to hide them.

Hope this workaround helps.

Regards,

Sanjay

Edited by: Sanjay Madala on Oct 10, 2008 9:12 AM

[Former Member · Accepted solution]

Hi Sanjay,

Thanks for the prompt reply. Will try and let you know the results...

Thanks again.

[Former Member · Accepted solution]

Hi Sanjay,

Could you please tell me hat filter condition should i use.

[Former Member · Accepted solution]

What filter condition should i use

[former_member212749 · Accepted solution]

Hi Jk,

Continuation with Sanjay .

JK please open the Query panel at the Top you can see the

SQL,User Objects,Combine Query etc.

Click on Combine query and take the required objects from Both Database and click on the Query tab till you get Minus symbol.

Hope this would help you.

Regards

Prashant

Edited by: Prashant Sathyapalan on Oct 13, 2008 9:33 AM

[Former Member · Accepted solution]

Thanks Sanjay...

My report is running now sucessfully...

Thanks Again..