Merge Dimension Problem

building reports webintelligence
1

Hello

I have two data providers:

DP1
object11
object12
object13
object14

DP2
object21
object22

Now I merged these two data providers on Object11 and object21. And I took all objects from data provider one and object22 from data provider 2.

Now when I am doing this, I am getting #MULTIVALUE error and to resolve this I am using Avoid Duplicate Row Aggregation property. So my problem got resolved.

But I don’t know why I am getting duplicate records even I have checked the SQL and there also DISTINCT word exists.

Could some one please help in solving this issue. Seriously saying it’s critical and I am struggling since morning. :frowning:

aniketp :uk: (BOB member since 2007-10-05)

2

If there is more than one value for same object 11 distinct will not work

for eg:

Object11 = 1234
object12 = xxx
object13 = yyy
object14 = zzz

Object 11 = 1234
object12 = xxx
object13 = yye
object14 = zzz

In this case distinct will not work

Regards,
GKY

ganeshky (BOB member since 2007-09-21)

3

I think,If you check Avoid Duplicate Row aggregation, you will get duplicate rows as you are suppressing the duplicate row aggregation. Are you getting multivalue because of any variables or just by pulling theose objects? Which object gives you the multivalue error? Is this from DP2? Can you please explain the problem in detail with screen shot.

madhu kothamasu :us: (BOB member since 2007-07-31)

4

All objects are from DP! , but also I am taking object22 from DP2 in the output. For that I created a detailed object and used it in the output. This particular field is giving MULTIVALUE error for some records and to resolve this I used Avoid duplicate values property. And then i started getting duplicate rows.

Could you please suggest me the best way to implement this? Thanks in advance.

aniketp :uk: (BOB member since 2007-10-05)

5

Hi Aniket,

Few questions:

On which dimension (object) you merged the queries (DPs)?

To which object you linked the detail object (object22)?

Without merging the queries you should not use query2 objects.

Prashant Purohit :india: (BOB member since 2009-02-18)

6

Prashant thanks for response.

I merged these two data providers on Object11 and object21. And I took all objects from data provider one and object22(detailed object , associated with object11 of data provider 1) from data provider 2.

aniketp :uk: (BOB member since 2007-10-05)

7

Sorry Aniket my 1st question was already answered by you in actual post, just checked it later.
Why don’t you link the detail object to merged dimension (merged dimension name instead of object11)?

Prashant Purohit :india: (BOB member since 2009-02-18)