SYSDATE for Oracle or YTD Function

[former_member274397]

Hello,

as newbiee, trying to get monthly measures and also Meausures of the Year (a kind of Year to Date).

first tried to define sysdate in deimension Err: Invalid Table name

trunc(sysdate) same Error

Thanx

[Former Member · Accepted solution]

Hi,

It does this as your object is not in a table. If you where to use this on its own in a Web Intelligence report it would not create a valid peice of SQL. You can create a derived table (right click on the database panel, right hand side and select derived table ) in the universe with the syntax

SELECT sysdate as MyDate FROM DUAL;

You should then be able to use the MyDate column as you would any other table

Regards

Alan