Current Date in IDT for Oracle database??

building semantic layer
1

How do I get current date in universe from oracle databse.
Created a dimension using sysdate function but it doesnt parse…
the error says it doesnt reference a table.
Any ideas??

2

it should work even if it does not parse.
see e.g. this thread https://bobj-board.org/t/80495
or this one https://bobj-board.org/t/91514

cheers
MU :mrsbob:

Miss Universe :de: (BOB member since 2010-02-16)

3

yes it does work even when it doesnt parse. THanks.