WebIntelligence Report SQL modification

system · March 4, 2004, 12:40pm

Hello Friends,
This question is specific to WebIntelligence reports.
We are displaying LOVs for specific field and our requirement is as follows:

We want additional custom value “All”.
If user opts of this value, report should consider all field values for reports. (Should not search for value = "All).

Hope, I’m clear to u.

Please advise how this can be implemented. (WebI SDK solution would be accepted). If possible, provide sample application .

Thanks in advance
Gajendra

WeCanDoIt (BOB member since 2004-03-03)

system · March 4, 2004, 1:23pm

One solution would be making changes on the universe side: see FAQ Designer.

Andreas (BOB member since 2002-06-20)

system · March 5, 2004, 6:22am

Thanks for quick response.

But I’m designing reports through WebIntelligence. With my little understanding, WebI does not allow editing of SQL, then how this will be modified. Is there any way to write equivalent SQL in WebIntelligence reporter?

Thanks in advance…

Regards,
Gajendra

WeCanDoIt (BOB member since 2004-03-03)

system · March 5, 2004, 10:29am

WebI uses universes as does Business Objects Full Client or ZABO.
If you modfiy the universe via Business Objects Designer as suggested in the link I provided you should be ready to go.

Andreas (BOB member since 2002-06-20)