Generate Time Data in SAP HANA – PART 2 ( Gregorian)
Generate time data option helps to generate time date either by gregorian or fiscal calendar type. The generated time data can be used for Creating Time based Attribute views.

1) Go to the Modeler quick view, then select Generate Time Data
3-13-2016 4-46-25 PM
2) Select the System. Press next.
3-13-2016 4-46-46 PM
In generate time data screen two calendar type option will be available.
Calendar type :  Gregorian, Fiscal
Gregorian Calendar type Time Generation
  • Select Gregorian from the calendar type
  • Specify the From year and To year.  For ex: 2009 to 2010 ( which will generate every single date from 2009 to 2010 )
  • Available Granularity options : YEAR, MONTH,WEEK, DAY, HOUR, MINUTE, SECOND
  • Choose day from the Granularity and Specify the first day of the week.
  • Press Finish to generate.
  3-14-2016 10-20-16 AM
  • The generated time data can be verified in  Schema : _SYS _BI 
              Table: M_ TIME_DIMESION – Day Granularity
                             M_TIME_DIMENSION_MONTH – Month Granularity
                             M_TIME_ DIMENSION_WEEK – Week Granularity
                             M_TIME_DIMENSION_YEAR – Year Granularity
    3-14-2016 10-28-30 AM

Post a Comment

  1. Be that as it may, on the off chance that you are a built up Data Scientist or one who is alluring the measure to transform into one don't simply underestimate the data given previously. in its place, do some examination by physically and check the figures. Data Analytics Course

  2. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!

    Simple Linear Regression

    Correlation vs Covariance

  3. You re in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject! data science training in guwahati

  4. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.

    Simple Linear Regression

    Correlation vs covariance

    KNN Algorithm

    Logistic Regression explained