I have Report Date' type whole number and 'Report Month' type whole number.
How can I create a date out of it so that I can use the benefits of date drill down and drop down capabilities
Tab 10.0 and back end is SAP HANA
please try the below once, hope this works.
please find attached workbook for reference.
I have SAP HANA db and getting this error
I created a cal field
DATE(STR([Report Year])+'/'+ STR([Report Month])+'/'+'01')
Then custom date in 'Columns Pane'
This is how it shows on axis which works, let me know if you have a better idea?
Retrieving data ...