Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Null Values not passing into Presentation Variable When using DDR
Hi Team,
I am not getting correct data in report when passing null values in presentation variable via Direct Database request.
I have used below expression -
(TRIM(t38735.ASSIGNMENTNAME) in (@{V_ASSIGN_NAME}['@']{''})
I am getting all the records from ASSIGNMENTNAME, but the issue is this particular attribute has NULL records as well. That record values needs to be shown in report. But not sure it's not coming in the report.
Can you please provide your thoughts on it.
Thanks!!
Best Answer
-
Sure @Gianni Ceresa
As it's related to NULL values inclusion in report - we have used NVL function in DDR to handle this presentation variable with null records populations in report as well.
Please find below expression -
NVL(TRIM(t38735.ASSIGNMENTNAME),'NULL') in (@{V_ASSIGN_NAME}['@']{t38735.ASSIGNMENTNAME})
Sure definitely - I will share in this community to have better ecosystem in Oracle Analytics!!
Thank you!!
2
Answers
-
It's resolved now. Please ignore.
0 -
This is meant to be a community: people come asking questions, others invest their time in answering.
It's good that you found the solution yourself, but by not sharing it, if somebody else had the same/similar case and find this post, they will not get anything helpful out of it.
Can you please post the solution to help other users having the same/similar situation? That's how we will build an active and alive community.
Thank you :)
1
