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
2) Select the System. Press next.
In generate time data screen two calendar type option will be available.
Calendar type : Gregorian, Fiscal
Gregorian Calendar type Time Generation
M_TIME_DIMENSION_MONTH – Month Granularity
M_TIME_ DIMENSION_WEEK – Week Granularity
M_TIME_DIMENSION_YEAR – Year Granularity
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
2) Select the System. Press next.
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.
- The generated time data can be verified in Schema : _SYS _BI
M_TIME_DIMENSION_MONTH – Month Granularity
M_TIME_ DIMENSION_WEEK – Week Granularity
M_TIME_DIMENSION_YEAR – Year Granularity
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
ReplyDeleteVery Informative Article
ReplyDeleteData Science Interview Questions
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!
ReplyDeleteSimple Linear Regression
Correlation vs Covariance
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
ReplyDeleteReally nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
ReplyDeleteSimple Linear Regression
Correlation vs covariance
KNN Algorithm
Logistic Regression explained
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.
ReplyDeleteSimple Linear Regression
Correlation vs covariance
data science interview questions
KNN Algorithm
Logistic Regression explained
Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
ReplyDeletedata science interview questions
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.
ReplyDeleteLogistic Regression explained
Correlation vs Covariance
Simple Linear Regression
data science interview questions
KNN Algorithm
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.
ReplyDeleteSimple Linear Regression
Correlation vs Covariance
I like this post,And I figure that they having a great time to peruse this post,they might take a decent site to make an information,thanks for sharing it to me Pretty good post. ExcelR Data Analytics Course
ReplyDelete