Note:while using this option for need to replicate the standard table into SAP HANA It is t005t, t005u, T009, and t009b . If these standard tables is not available then you won't be is able use the "Generate time Data" function. If using when the "Generate Time data" option is generated, the These tables in t005t, t005u, T009, and t009b are copied (with data) into Hana and cannot be used if they do not exist. 1. Open the Quick Launch Page from the Help Menu > Quick Launch (or quick View if the Eclipse plugin) 2. Click on "Generate Time data" under data. 3. Enter the following entries.Select Gregorian as the Calendar Type.Enter to-(you can use a) Select day for the granularity click Generate. 4. Check the Generated data within the table "_sys_bi. M_time_dimension ". There should be a entry for every day between and 2011.
5. Create an Attribute view Generate a Time attribute view to use the day time master data generated aboveright Click on Attribute view > New > Attribute view. 6. Enter "time_01" for the name of the view Select Time->gregorian. (Of course, it is also possible not to select the Time,atrribute view type directly to the default standard, which is to manually drag the corresponding granularity dimension into the attribute view, except when the time attribute view is created here. The Time dimension table is added automatically according to the time granularity you choose, so it is convenient and quick .) for the granularity select "Date" click on Auto create. click Finish.7. As a result you'll see the Dimensions table with the generated Attributes. Optionally can remove any attribute fields, that is not needed. When you select a property view type of time type, the corresponding timesheet (here is _sys_bi) is automatically based on the granularity of the granularity you choose . m_time_dimension) is added to the Properties view, and by default all the fields in this time dimension are the output fields of the view, you can delete some unwanted attribute fields according to the actual need . 8. Save the view first. Right Click on the Attribute View > Activate. 9. Right Click on the Attribute View > Preview. Create the analytical view and use the Attribute view: "Time_01"Use the time attribute view created above in the analysis viewOne. Enter "an_time_00" for the name of the VIEW. click Finish. Click on ADD Link Search forCe1ideaTable (Ce1idea should be a business data sheet) click Ok 13. Add Hzdat as an Attribute. Right click on Hzdat ( Hzdat for days with date format, 10-bit, date format should be related to the currently logged in National locale )> Add as Attribute. Open the Logical View (the new version of studio should be star Join). Click on the tab ' Logical View ' in the bottom of the detail screen. Drag time_01 attribute view in Window.Drag the Date_sql in the time_01 time attribute view to the Hzdat time field on the business table, resulting in an associationCreate a referential (n.. 1) Join between Time_00.date_sql and Data Foundation hzdat field. Activate & Preview.This makes it possible to analyze the business Table Ce1idea Quarterly (QUARTER) (and, of course, to analyze the data by the monthly month Time dimension)
From for notes (Wiz)
Generate Time data (normal date master data)
