You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Report - Advanced Query - presentation variable is null, how to handle?

Summary:

In OTBI Report, I have used Advanced Query to combine multiple subject areas. As a parameter I'm using presentation variable.

If the presentation variable is passed as null we need fetch the full data. How can we handle this?

Content (please ensure you mask any confidential information):

Below is the logic I'm trying in the Criteria

CheckList_Name LIKE CASE WHEN @{P_JOURNEY_NAME} IS NULL THEN '%' ELSE @{P_JOURNEY_NAME} END

CheckList_Name, name is the column name from the query.

P_JOURNEY_NAME, is the presentation variable from prompts.

Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!