Skip to Content
Author's profile photo Former Member

Analysis of Shift Data of Project using SAP HANA and supported Reporting tools

Hi All,

This is in continuation to blog in which I have explained how we can use SAP Lumira tool for Analysis of data , refer to below link for blog content

Now , I will be sharing few screen shots with steps on how we can bring this data via excel into SAP HANA and then report it within HANA or with help of tools like Crystal reports , WEBI etc.

1. Data of Shift Allowance in Excel

Snap 1 - Allowance Data over excel.JPG

2. Location Data over Excel

Snap 2 - Location Data over excel.JPG

3. Age Data over Excel

Snap 3 - Age Data over excel.JPG

4. Go to Window – Open Perspective – Other in HANA Studio

Snap 4 - HANA Studio opening Perspective.JPG

5. Click on SAP HANA Modeler

Snap 6 - Opening Modeller.JPG

6. Click on Data from Local File

Snap 5 - Importing Flat File into HANA studio.JPG

7. Pass on Scheme Name in which Table will be created. Highlighted item reflect details on Schema and Table Name which will be created

Snap 7 - Passing parameters for flat file upload.JPG

8. Select Store Type as Column Store

Snap 8 - Flat file upload view of fields from excel.JPG

9. Details of File – Location Data

Snap 9 - Flat file upload of Location Data.JPG

10 . Tables are created in Schema. Highlighted items reflect the details

Snap 10 - Tables created with help of File in Schema defined.JPG

11. Creating Package in which Attribute View and Analytical View will be defined

Snap 11 - Creating Package.JPG

12. Package Definition

Snap 12 - Creating Package and passing details.JPG

13. Create Attribute View for Sales and Location Data which is stored in Tables now in Scheme highlighted in previous screen shot

Snap 13 - Creating Attribute View.JPG

14. Attribute View Created for Shift Data

Snap 14 - Attribute View Created for Shift Data.JPG

15. Attribute View Created for Location Data

Snap 15 - Attribute View Created for Location Data.JPG

16. When Analytical View is created with Age Data in Data Foundation and Shift/Location Data in Logical Join then during activation error is coming which says “Not sufficient privilege”

Snap 16 - Analytical View activation with error.JPG

17. Below SQL command need to be executed on Schema and error will be removed

Snap 17 - Grant Command on Schema.JPG

18. Columns from 3 different flat files are available for reporting. Now we can use this as source and report using WEBI , Crystal reports etc. etc.

Snap 18 - Data for preview.JPG

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice, i liked the step wise demonstration of the steps and the topic is also nice. Good !

      Author's profile photo Pooja Goel
      Pooja Goel

      Quite descriptive...Thanks for sharing

      Author's profile photo Former Member
      Former Member

      excellent article