Skip to Content

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

Merge dimension issue

Hi All,

Need help on this

Issue:

The issue is in using the u2018Merge Dimensionsu2019 utility. After I merge the two results based on the dimension they share in common, I get duplicate rows.

Background:

Universe #1 and Universe #2 have a dimension in common u2013 UCS ID. The user builds a query against Universe #1 and brings back the distinct UCS ID and the UCS Name. He builds a second query against Universe #2. The query brings back UCS ID and passenger count.

The results of query #1 are:

UCS ID UCS NAME

=====================

257 Motorola

5 AON Service Corporation

6 Altria Client Services Inc

The results of Query #2 are:

UCS ID Passenger Count

=========================

257 6892

5 2767

6 382

The user would like to see the results of the merge dimensions utility to show up as one row for each UCS ID, as shown below:

UCS ID UCS NAME Passenger Count

257 Motorola 6892

5 AON Service Corporation 2767

6 Altria Client Services 382

Instead, they get the following (i.e, duplicate row with a null or blank):

UCS ID UCS NAME Passenger Count

257 Motorola

..............................................................................

257 6892

.............................................................................

5 AON Service Corporation

...................................................................................

5 2767

.................................................................................

6 Altria Client Services

...................................................................................

6 382

Environment details:

BOXIR2,SP2.

Database :SQL server

Thnnks in advance,

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