IDT Terms

Alias Table

Derived Table
This is created based on the database table. Important reason this is created is that we can manipulate the SQL to suit our needs.
For example , MARA is being in IDT we can add filters on the table in IDT directly but if you create a derived table, we can join it with other tables in the SQL and make if more effective.
However, derived table are slower in performance compared to database tables.
More information can be found below

Creating Derived Table
Right click on the database table and it will give you an option to create Derived table.
[[ However, when you right click on the empty space and create Derived tables, it seems create it but cannot be seen in the screen.. not sure why? ]]

https://dwbicastle.com/2014/06/05/what-is-derived-table-in-bo-universe/

View From Selection

Using Formula in IDT

curdate()
Returns the value in format Jun 13,2017

ToDate

toDate('2003-02-12') = February 12, 2003 

Date in IDT is saved in this format by default. When we need to use date for calculations, we need to use ToDate to convert the date to 'YYYY-MM'DD' format.

Eg : Use concatenation to first convert 06/13/2017 to get it to format 2017-06-13 and then use ToDate which converts to IDT format.