How to find difference between two dates in IDT?

[Former Member]

Dear Team,

(1)How to find the difference between two dates at Universe level and at report Level in IDT?

(2) How to change format of dates from YYYY/MM/DD to DD/MM/YYYY in IDT at prompt level ?

(3)What is VIEWS in IDT of data foundation layer when we right click? could u plz give one example where exactly we use VIEWS?

(4) How to represent & report my IDT data in dashboards? could u plz explain the steps?

Thanks in Advance

Regards,

Kittu

[former_member4998 · Accepted solution]

(1)How to find the difference between two dates at Universe level and at report Level in IDT?

DaysBetween ([Sale Date];[Invoice Date]) returns 2 if [Sale Date] is 15 December 2001 and [Invoice Date] is 17 December 2001.

(2) How to change format of dates from YYYY/MM/DD to DD/MM/YYYY in IDT at prompt level ?

=FormatDate(ToDate(YOUR DARE OBJECT);"YYYY/MM/DD");"dd'/'MM'/'yyyy")

=To_Char (object name, required format)

Find the below link for more info.

http://scn.sap.com/community/semantic-layer/blog/2014/04/18/bi41-business-layer-enhancements--create...

(3)What is VIEWS in IDT of data foundation layer when we right click? could u plz give one example where exactly we use VIEWS?

A custom data foundation view is a subset of the data foundation Master view. You can use views when editing a large data foundation, and interested in working with a subset of tables. You can define multiple custom views for the data foundation due to the complexity of the data warehouse.

Essentially, need created views for each individual star scheme (like Sales, Production, Finance, Accounting, etc.) plus a view for eachcomplex dimension structure (like Business Partner, Material, Customer, Plant etc.),

Find the below link for more info.

http://scn.sap.com/docs/DOC-54422

(4) How to represent & report my IDT data in dashboards? could u plz explain the steps?

Please find the below link: http://scn.sap.com/docs/DOC-27559

[Former Member · Accepted solution]

Hi,

Thanks for ur reply.

Regards,

Kittu

[former_member190895]

Q1 & 2)  Let me know you database.

Q3)Please refer below link:

Q4) For creating a dashboard with different connection type. Please refer below tutorial