Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

webi reporting

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.

replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question