BusinessObjects Board

QaaWS - Incompitable Objects Issue

other Xcelsius - Crystal Dashboard Design
#1

Hi,

I am working on BI 4.1 SP2 and using QaaWS. I am trying to build a query in that but it is giving an error-

The Query you built has incompatible objects. Make sure the objects are compatible.

And the same query is working fine in WEBI and I am able to create a report without any issues. Can someone please guide me how I can solve this problem… this is bit critical for me? :crazy_face: :crazy_face:

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

#2

QaaWS is pathetic and really wiered… yesterday I broke my head to resolve the issue and I couldn’t and today when I restarted working on this, it worked fine … don’t know what is the problem…

Also I am not getting aggregated data like I was getting in WEBI with the same query… either it is normal behaviour of QaaWS or I am doing somerthing wrong… :hb: :hb: :hb:

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

#3

Ok, Finally It is working fine and I am able to identify the root cause.

So we have a measure and the code is something like -

amount1*amount2

There is no aggregation function is put in the select in universe due to which we are facing 2 issues -

  1. I have 2 dimensions and 5 measures, when I run it - it gives me 10 rows but when I include the above calculated measure in my query, aggregation gets remove it displays many rows instead of only 10 rows.

  2. The above action I performed without taking measures from different places, now when I mix the measures from different tables with the above calculated field, it gives incompatible objects issue.

Also I am positive here that we cannot use Universe prompts in QaaWS, but still thought to confirm the same… :slight_smile:

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