Hi @BalagurunathanBagavathy-Oracle, I have substituted VALUEOF(NQ_SESSION.USER) with an appropriate value - it's coming all those list of values. Hi @Federico Venturin, I tried with replacing the 'VALUEOF(NQ_SESSION.USER)' with ':USER' - still the same issue is coming: session variable has no value definition.

Hi @Federico Venturin , I have used row-wise initialization. Please check snapshot - I have used the variable in one of LTS to filter data - Now i am getting the below issue - session variable has no value defination. Could you please let me know what could be the issue.

Thanks @Benjamin Arnulf-Oracle for putting it in one place.

Thanks all for your input. I put the logic in ETL area and try to do less formulae in RPD layer. Now its working. Thanks!!

Thank you all for help.. Yes from OCI Console we resumed the Oracle Analytics Services!!

We have not touched to pause the analytics service in OCI Console. Why it automatically showing this issue. Any thoughts on it. @Sumanth V -Oracle

Last week, I have checked in - Instance already been updated to Sep - 2024.

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…

It's resolved now. Please ignore.

Hi, Thanks for all responses. There are joins missing actually in multiple LTS available in BMM layer. Now i have properly done joins. So that nQSError: 14023 not coming. But we are facing "No Results" coming in OAC Report. Attached snapshot . Snapshot 1,2,3 working fine as per RPD design. But when we add column from…