9
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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  5. very well explained .I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Simple Linear Regression
    Correlation vs covariance
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

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

    data science interview questions

    ReplyDelete
  7. very well explained. I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Logistic Regression explained
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm

    ReplyDelete
  8. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete

 
Top