Null Values not passing into Presentation Variable When using DDR

Saroj Kumar Behera

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!!

Saroj Kumar Behera

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!!

Saroj Kumar Behera

It's resolved now. Please ignore.

Gianni Ceresa

@Saroj Kumar Behera ,

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