Skip to Content
0
Former Member
Aug 31, 2017 at 03:40 PM

Member cannot be null

458 Views

When I am scheduling my report it fails and throwback the error.

I am using the prompt "As of date" which populates dates values from the object as of date in universe.

For creating "as of date " I am using @prompt functionality in where clause with decode function

ex:

Fact.as_of_date in decode (@prompt(,,,,,{Latest},)),'Latest',sysdate-1,

@prompt(,,,,,{Latest},)),)

it gives error only for latest parameter which is not in list of value but for other dates it works fine.