Skip to Content

Certain Webi query panel features are not available when using BICS connection however these features are available  with relational Universe.

These are I have tested in BI 4.1 SP02.

Feature Where Workaround
Query filters on BEx Navigation attributes Query Filters Add filter condition in BEx query or add filter at report level
Webi query filters on Measure Object Query Filter Add filter condition in BEx query or add filter at report level
OR condition between the prompts Query Filter Add filters at report level and add OR condition.
Matches Pattern in Prompt Query Filter Add filters at report level
Object from this query in Prompt Query Filter Create variables at report level.
Result from another query in Prompt Query Filter Create multiple queries and restrict the data at report level
IS Null in Prompt Query Filter Add filter condition in BEx query or add filter at report level
Not Null in Prompt Query Filter Add filter condition in BEx query or add filter at report level
Retrieve duplicates Rows Query Properties
Add a Combined Query Query Panel Create multiple queries and use merged dimension.
Both in Prompt Query Filter
Except in Prompt Query Filter

                                       

Regards,

Amit

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply