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:
0