Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Runtime Data Filter

Dear All,   I have to develop a Power BI report based on SAP HANA data. There are 5 tables being used to fetch the data i.e. MATDOC, MAKT, LFA1, USER_ADD and 1 ZTable.   The data count is roughly...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous,

    You can directly put the above statement into advanced options during the import process.


    If the Mat_Doc_Post_Date field is date type, your condition should be as follows.

    WHERE "BUDAT" > Current_Date - 90 or WHERE "BUDAT" > ADD_DAYS(Current_Date,-90)

    There is a blog about date time functions in SAP hana for your reference.

    https://sapstudent.com/hana/sql-datetime-functions-in-sap-hana



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

You can directly put the above statement into advanced options during the import process.


If the Mat_Doc_Post_Date field is date type, your condition should be as follows.

WHERE "BUDAT" > Current_Date - 90 or WHERE "BUDAT" > ADD_DAYS(Current_Date,-90)

There is a blog about date time functions in SAP hana for your reference.

https://sapstudent.com/hana/sql-datetime-functions-in-sap-hana



Regards,
Lydia