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

Member cannot be null


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


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


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