merge dimension queries not able to aggregate correctly

building reports webintelligence
1

I am merging two queries over a common dimension.
One: Name, ID
Other: Cost,ID

Now final report is
Name, Cost , ID
Cost is a measure and all other are objects.

But when i am trying to get sum of cost in Name. then it is displaying same number in all rows which total of cost in all names.
I am trying
– Sum([Cost]) In ([Name])
– tried Sum([Cost] In ([Name]))
– tried to set the “Extend Merged Dimension Values” as a default
– tried Sum([Cost] ForAll ([ID])) In ([Name])

Nothing is working…
Can anyone please help me out in finding out the problem?

I came to know that we can only group by(aggregate) object from 1st query in 2nd query on the basis of merge or common dimension and this rule does not apply to measure from any query, is it true?

If yes, why i am not able to get the cost with respect to each name rather than geting total cost for all names?

vikramvasisht (BOB member since 2008-02-18)

2

Try performing aggregarte operation Sum in the universe rather than report level.

Thanks,
Pragna

Pragna (BOB member since 2007-07-25)

3

Also you can check whether the property " Row Aggregation is checked or not".

Just try with this property and check the difference what you are getting.

Regards
Aniket

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

4

Hi Pragna

Measure is already summed up at Universe level, still the problem exists as it is.

Hi aniketp

I have tried with both checked and unchecked for property “Row Aggregation is checked or not”
But still the problem exists as it is.

vikramvasisht (BOB member since 2008-02-18)

5

Have you defined “name” as a detail variable linked to the ID, referred to, in query one?

Mak 1 :uk: (BOB member since 2005-01-06)

6

No, Name is not detail variable.

One mistake, I thought by row aggregation you are referring to extend merge dimension value property…
I am not able to find the row aggregation? i found in forum that it is edit report --> properties-> display
I am not able to find the option of row aggregation…
I am using Webi XIR2.

vikramvasisht (BOB member since 2008-02-18)

7

We started experiencing the same issue a week ago when we installed Fix Pack 3.7 for BO XIR2.

Our issue only occurs when we merge 2 queries on an ID. We resolved the issue by changing the dimension in the Universe to a “detail”, instead of in the report.

I will open a ticket with Business Objects/SAp today.

hbunicorns :us: (BOB member since 2007-05-31)

8

Well, I think it should be if you want to get this to work. Make Name a detail variable in the report and link it to the ID in Query 1…

Mak 1 :uk: (BOB member since 2005-01-06)