Error during SQL Execution

building reports desktopintelligence
1

Hi while i tried to run the report in Business Objects 6.5 it shows me a warning
“This query will create a Cartesian product. Do you want to continue?”
while i click yes, it generates an error of
“Error during SQL Execution”

Those warning is shown if i generate one Measure that has a selection of

sum(SALE_MODEL.SALE_QTYMODEL.MODEL_PRICE((100-SALE.SALE_SALE_DISCOUNT)/100))/sum(SALE_MODEL.SALE_QTY)

inside universe.

Is it actually a wrong code inside my universe? Because when i tried to parse that Measure, everything was Ok.

Thanks,
Raccoon

Moderator Note: Edited the subject.

raccoon (BOB member since 2008-06-19)

2

[Moderator Note: Moved to Desk-I - Jansi]

Jansi :india: (BOB member since 2008-05-12)

3

Hi all, i have find out that the problem was in where condition that actually generated from my table.

for reference, please go to :

raccoon (BOB member since 2008-06-19)