BusinessObjects Board

measure object from two different tables issue

building semantic layer
#1

Hi Experts,

I am building a Universe in IDT and backed database is Oracle 11g. I have two tables in my universe 1. Order headers and 2. Order Lines. They have relationship(Cardinality) one to many from Order headers to Order lines. Both tables have few measure objects e.g in horder headers I have “Total Ship Amount” and in order lines I have “quantity”.

The strange thing is when I add measure objects from both the tables webi fires two sql queries one for each measure object which brings wrong numbers. By checking sql in webi it shows two different queries for both the measures and then Union them. Please also see the attachement.

Can someone please through some light on this. Weather its normal behavior and why webi fires two sqls or how can i solve this as i am getting wrong numbers?

Thanks,
Roopa
SQL.doc (78.0 KB)

Roopa Devi (BOB member since 2012-08-27)

#2

Hi,

The attachment can’t be opened.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#3

This may give you some ideas:-

https://bobj-board.org/t/166900

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

#4

Thanks Mak. I will look into this.

Marek,

I am attaching the doc again please look at this and let me know your inputs as i am still having this issue.

Thanks,
Roopa
Webi Issue.doc (178.0 KB)

Roopa Devi (BOB member since 2012-08-27)

#5

Check in universe SQL parameter and un-check the option Generate separate SQL for Each measure used.

niks5687 (BOB member since 2011-01-03)