Sub Query

building reports webintelligence
1

Hello,

one of my reporting requirement forced me to use sub query in webi R2.
but due to that I’m not able to run the report looks like performance issue due to sub query.
is there any alternative in webi to avoid subquery as i’m not able to execute query, it goes on and on.

Thanks…

lahca_ac (BOB member since 2010-01-18)

2

Hi,

Can you please give some examples.
If you are using BOXI3 sp2 there is an option of using output of one query as an input to other.
You have to use the operator “results from another query” in the filter condition.
This has been newly introduced in webi but was always there in deski.
May be it might help you.

gaurav S (BOB member since 2010-04-22)

3

Thanks gaurav…

was also thinking for query in query but in webi R2 version its not there :frowning:
what we need here is list of companies globally that has some filters based on product and need to identify some id based on particular country out of that, so have used sub query here as: "ID In list ID where products(ORed) "
ANDed with particular country.

any thoughts on this.

lahca_ac (BOB member since 2010-01-18)

4

no luck yet :frowning:

lahca_ac (BOB member since 2010-01-18)

5

Hi,

Did you tried creating a derive table and use the subquery in the derive table.
Create an object from this derive table i.e. id and in report filter compare it with the other object.
Does it helps?

gaurav S (BOB member since 2010-04-22)

6

you mean to say creating a filter variable at universe level, if it is then not in my scope, as can not make changes to universe.
though could you elaborate this.

  • also with the current query, query just keeps on running just saying processing request only and not at all moving to next like decoding and all. does it mean only performance or can be other issue as well?

lahca_ac (BOB member since 2010-01-18)