How to insert a constant date dimension in IDT

[Former Member]

Hi, I want to insert a hard coded date value e.g a reporting date, which will be a base date to my report.

I can do this in webi but my requirement is to achieve this in IDT itself.

When using the function sysdate(), or to_date(.......) I am receiving this error "The query does not reference any table when attempting to build the WHERE clause. (IES 00022)"

Kindly help..date-issue.jpg

[amitrathi239 · Accepted solution]

Right click on the table in data Foundation->add new column and place sysdate() there.After that use this newly added column in the business layer.

[Former Member]

Thanks !!

But I created a dimension in the business layer and then used todate() fn. and used a table for reference