Skip to Content
author's profile photo Former Member
Former Member

Make current date as default date for a parameter created in IDT which is mapped to one of the Input Parameters of HANA View

Hi,

Business Scenario - Put together 10 different views into a single Universe (IDT 4.1 SP5)

I have created derived tables for each Hana views as there are different Input Parameters (IPs) (Currency/UOM Conversion,Date(From/To)) which are mapped to the Parameters created in DF Layer.

As am using 4.1 SP5,I have option to set default values for Date Parameter only from the list of values unlike SP6 which has a new feature called Formula Editor which provides the user to set default values like Current Date,Current date-1,Current Fiscal Period, Current fiscal Period -1 etc..

Upgradation of SAP package is out of scope as we are in the middle of the build phase. I came across the Dave's Magic Date Concept but its throwing an error when I tried to apply the condition on the Hana Object.

Please find below for the screenshots,

IP.png - Parameter Key Date in DF Layer is mapped to $$IP_TODATE$$ of HANA View - works fine

Error.png - Magic Date code is applied to Hana Object - Throws Error - Will the Magic Date works only for certain DBs?

Please help me to sort out this issue.

I even tried to supply default value from HANA object in the Derived table script itself but it didn't work. Like

Error.png (48.6 kB)
IP.png (29.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 04, 2015 at 06:01 AM

    Hello Jyothi,

    Alternatively, you can pass current date as constant in Data Foundation(DF) layer.

    eg: if you have DATE in your table then right click on DATE field select "Insert Filter".

    in the pop-up window at the bottom you would see,

    ABC.DATE = ABC.DATE (ABC is table name)

    Change it to :

    ABC.DATE = CURRENT_DATE

    Validate & save it.

    This will put a filter on DATE for current date at DF layer.

    Hope it helps.

    Best Regards,

    Pruthvi R

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Jyothi,

      I guess the issue might be with format of date.

      please check the format of CC_Refresh_Date & the DATE from your DF layer.

      you may have to change the format of one of the date to match other.

      eg:

      CC_Refresh_Date format is dd/mm/yyyy

      &

      DATE field format is mm/dd/yy hi24:mm:ss

      then dates will not match. Make sure both dates are in same format before comparing.

      Best Regards

      Pruthvi R

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.