Today's date in universe

[former_member647411]

I want to create an object in the universe based on Today's date.
 
Date = Today's date.
 
The database is Teradata.
 
What is the correct SQL for this ? I have created like this:
 
Today's Date as Object Name and Date as object type. Under Select,
 
Current_Date
 
why is it throwing error while parsing ?
 
 
I searched. I can see a lot for Oracle / SQL Server / DB2.....but not for Teradata.

[CdnConnection]

Asad,

     You need to refer the SQL to a table.  Click on the tables button and select the tables that best works with the context.

Regards,

Ajay

[former_member647411]

Ajay,

I don't want any context in my universe. How can I refer to a table as this is not available in any of the tables ? Can you please give an example writing a SQL statement ?

Thanks

[CdnConnection]

Asad,

    This is the only way to validate the SQL.  The table you select will show up in FROM clause. It is require to validate the SQL.  Another way is to create a Derived table and then select the column in the select statement.

Regards,

Ajay

[former_member647411]

So, you are saying, I should create the object like:

Today's date = Table A. Current_Date

Should it be passed to the report level like this ? Then what is the need of context ? Don't want to do derived table.

Am I getting you correctly ?

[CdnConnection]

Asad,

     NO.  You can use the same select statement but you just need to associate a tables in the table button so the object can parse.  Even when you write the SQL in the Derived table you will still need to refer to some table, even system table.

Ajay