step-by-step guide to implement modeling scenar
TRANSCRIPT
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
1/18
Getting Started Newsletters Store
Products Services & Support About SCN Downloads
Industries Training & Education Partnership Developer Center
Lines of Business University Alliances Events & Webinars Innovation
Log On Join UsHi, Guest Search the Community
Activity Communications Actions
Browse
2 Tweet
created by Mohammad Safiullah on 07-Mar-2014 07:13, last modified by Mohammad Safiullah on 07-Mar-2014 09:30
About this Document
Business Case
This Document is based on SALES Business use case scenario.
Purpose
This manual aims to help you to understand the modeling of BW
objects in HANA and reporting based on HANA models in SAP BW on
HANA. This kind of processing is done in SAP BW on HANA. This
manual also provides details of the steps involved in importing
and modeling BW objects in HANA and creating a report based on
HANA views. This document is created solely with the intention of
sharing information.
Pre-requisites
Following are the pre-requisites for performing the tasks
presented in this manual:
SAP BW on HANA 7.4 installed on the server with packages sp4
(SAPKW74004).
SAP BW on HANA 7.3.1 installed on the server with packages sp9
(SAPKW73109).
SAP BW on HANA 7.3 installed on the server with packages sp10
(SAPKW73010).
HANA database upgraded to version 1.00.48.372847 and above.
BW authorization and Analytic privileges.
Knowledge of BO Objects.
Knowledge of Lumira
Contents
1 Overview of HANA-Optimized DSO and InfoCube in BW 7.4.
2 Source Data Extraction (LO Extraction).
3 Modeling BW Objects in BW 7.4.
Step-by-step guide to implement ModelingScenarios in SAP BW 7.4 on HANA
Share 1Like
Version 1
http://scn.sap.com/people/mohammad.safiullahhttp://scn.sap.com/people/mohammad.safiullahhttp://scn.sap.com/contenthttp://scn.sap.com/community/developer-centerhttp://scn.sap.com/activityhttp://scn.sap.com/communicationshttp://scn.sap.com/actionshttps://twitter.com/intent/tweet?hashtags=scn&original_referer=http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-53083&ref_src=twsrc%5Etfw&text=Step-by-step%20guide%20to%20implement%20Modeling%20Scenarios%20in%20SAP%20BW%207.4%20on...&tw_p=tweetbutton&url=http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-53083&via=SAPCommNethttp://scn.sap.com/community/developer-centerhttp://scn.sap.com/actionshttp://scn.sap.com/welcomehttp://scn.sap.com/people/mohammad.safiullahhttps://www.sapstore.com/?url_id=banner-US-2015-SCN-HeadLinkhttp://scn.sap.com/communicationshttp://scn.sap.com/activityhttp://scn.sap.com/docs/login.jspahttp://scn.sap.com/community/uachttp://scn.sap.com/community/getting-startedhttps://twitter.com/intent/tweet?hashtags=scn&original_referer=http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-53083&ref_src=twsrc%5Etfw&text=Step-by-step%20guide%20to%20implement%20Modeling%20Scenarios%20in%20SAP%20BW%207.4%20on...&tw_p=tweetbutton&url=http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-53083&via=SAPCommNethttp://scn.sap.com/community/downloadshttp://scn.sap.com/community/newslettershttp://scn.sap.com/contenthttp://scn.sap.com/people/mohammad.safiullahhttp://scn.sap.com/login.jspa
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
2/18
3.1 Releasing BEx Query as InfoProvider.
4 HANA-Optimized InfoCube and DSO
5 Importing and Modeling in HANA .
5.1 Modeling in HANA of DSOs.
5.2 Modeling in HANA of InfoCube.
6 Visualization in Lumira.
1
Overview of HANA-Optimized DSO and InfoCube in
BW 7.4
DSO and InfoCube in BW 7.4 are HANA-Optimized by default. This
reduces the activation time and has a huge impact on the
performance .Modeling BW objects in BW on HANA into Analytic
/calculation views is only possible if the underlying database is
HANA .This is because tables are physically stored in HANA and
views are created with respect to the tables .
Key features
SAP HANA-optimized objects help you to achieve significantly
better performance in load and activation processes. Up to 80%
faster for loading in HANA Optimized Cubes.
With its high compression rate, the column-based HANA datastore
requires less data be materialized.
Data modeling is simplified. Using in-memory-optimized objects
you do not need to load a BWA index, for example. In addition,
the architecture of the HANA database allows you to delete
characteristics from an InfoCube that still contains data.
With BW in-memory-optimized objects, complex analysis and
planning scenarios with unpredictable query types, high data
volume, high query frequency, and complex calculations can be
processed with a high degree of efficiency.
Loading SAP HANA-optimized BW objects can also be done more
efficiently.
The SAP HANA database replaces both any previous database and
SAP NetWeaver BWA, reducing infrastructure costs. Instead of
both database administration tools and additional SAP NetWeaver
BWA administration tools, the SAP HANA database requires just a
single set of administration tools for monitoring, backup and
restore, and other administrative tasks.
2 Source Data Extraction (LO Extraction) We will now see the basic feature of Extraction from EC6 system.
Login to EC6 with proper username and password
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
3/18
We activate the data sources using a transaction code RSA5.
Next we have to fill up the set up tables for the data sources. For doing this first we need to delete the contents
that are already present in that setup tables.
Go to the transaction code LBWG and select the application component whose content has to be
deleted.
To check whether the setup table is deleted or not go to the transaction code RSA3 and give the data source
name and it will show Record 0 found which means data has been deleted from the setup table.
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405158/ecc+1.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405168/scn2.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405106/scn1.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
4/18
Now using the transaction code LBWQ delete the extraction queue of the data source.
Also d elete the del ta queu e for the data sources u sing the transaction code RSA7.
Next is to fill the setup table using the transaction code SBIW or OLI*BW where * denotes the application
component
Click on Logistics under Settings for Application-Specific Data Sources--> Managing Extract Structures ---
>Application-Specific Setup of Statistical Data.
Now click on the execute button of Perform setup – Sales and do it for delivery.
We will now see the set up table contents using transaction code RSA3.
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405169/scn3_new.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405181/scn5.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405180/scn4.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
5/18
3 Modeling BW Objects in BW 7.4
We will locate the application component and replicate both the data sources.
Next we will create the info package for the data sources 2LIS_11_VAHDR and 2LIS_11_VAITM and activate it
so that we can see all the data that are selected in the extract structure will be in the PSA table.
Next we will create the DSO for each data sources and load all the data into it using the data transfer processand activate both the DSOs.
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405192/scn7.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405189/scn6.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
6/18
3.1 Releasing BEx Query as InfoProvider
We create the BEx Query in Query Designer for the InfoCube and di splay it using transaction code RSRT.
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405195/scn8.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405209/scn9.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
7/18
Next we will set the Query as InfoProvider in the properties tab or using t-code RSDB in order to use it in HANA.
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405214/scn11.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405211/scn10_new.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
8/18
4 HANA-Optimized InfoCube and DSO
In order to find out whether InfoCube is HANA-Optimized or not. In BW 7.4, by default it is HANA-optimized.
In order to find out whether DSO is HANA-Optimized or not, this can be find out after activation
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405224/scn14.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405218/scn12_new.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405225/scn13.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
9/18
5
Importing and Modeling in HANA We will now see the basic steps of importing and modeling from BW into HANA.
Login to HANA Database via HANA Studio by clicking add system.
Go to File->import->import SAP Netweaver BW models.
Next we enter the credentials of BW on HANA choose the target system.
Note: target system has to be the underlying database.
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405249/scn16.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405231/scn15.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
10/18
Next we see that it imports, generates, transforms, saves and activate BW objects into views.
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405250/scn17.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
11/18
Next select the package for the views.
DSOs are imported as analytic views.
InfoCubes are imported as internal analytic views and graphical calculation view.
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405260/scn18.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405272/scn19.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
12/18
BEx query released as infoprovider is imported as analytic view
5.1 Modeling in HANA of DSOs
Next we created calculation view on top two analytic views.
We selected the fields which we need for analysis in projection
We used union since the metadata structure is same in projection and it increases the performance and
aggregated it.
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405274/scn21.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405273/scn20.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
13/18
Next we check the value of calculation view.
5.2 Modeling in HANA of InfoCube
Next we also check the data of calculation view of infoCube imported.
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405279/scn23.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405276/scn22.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
14/18
6 Visualization in LumiraLogin to Lumira using HANA credentials.
Next select the calculation view to prepare the visualization.
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405281/scn24.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405282/scn25.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
15/18
Next, select the measures and dimensions to prepare visualization
Next, we can add filter or restrict in order to visualize the data
http://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405293/scn27.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405283/scn26.png
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
16/18
Average User Rating
(3 ratings)
2 Tweet
Finally we visualize and save the dataset either in local folder or in Excel or in HANA or in Lumira cloud.
6897 Views
Products: sap_hana, sap_netweaver_business_warehouse_7.3_powered_by_hana Topics: business_intelligence Tags: hana,
bw, sap_netweaver_bw, bw7.3, bw_on_hana, sap_netweaver_bw_on_sap_hana, bwonhana, sap_bw_hana, bw_migration,
bw_on_sap_hana
Share 1Like
12 Comments
Antony Jerald J 13-Mar-2014 07:42
Hi,
Thanks for sharing, nicely explained.
I've a query here:
http://scn.sap.com/community/bw-hana/tags#/?tags=bw_on_hanahttp://scn.sap.com/community/bw-hana/tags#/?tags=bwhttp://scn.sap.com/community/bw-hana/tags#/?tags=sap_netweaver_business_warehouse_7.3_powered_by_hanahttp://scn.sap.com/community/bw-hana/tags#/?tags=sap_hanahttp://scn.sap.com/community/bw-hana/tags#/?tags=bw_on_sap_hanahttp://scn.sap.com/community/bw-hana/tags#/?tags=hanahttp://scn.sap.com/community/bw-hana/tags#/?tags=sap_bw_hanahttp://scn.sap.com/people/antonyjerald.jhttp://scn.sap.com/community/bw-hana/tags#/?tags=bw7.3http://scn.sap.com/community/bw-hana/tags#/?tags=bwonhanahttp://scn.sap.com/community/bw-hana/tags#/?tags=bw_migrationhttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405300/scn29.pnghttp://scn.sap.com/people/antonyjerald.jhttp://scn.sap.com/servlet/JiveServlet/showImage/102-53083-1-405295/scn28.pnghttp://scn.sap.com/community/bw-hana/tags#/?tags=sap_netweaver_bw_on_sap_hanahttp://scn.sap.com/community/bw-hana/tags#/?tags=sap_netweaver_bwhttp://scn.sap.com/community/bw-hana/tags#/?tags=business_intelligence
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
17/18
Like (1)
Since BW is running on Hana, what is the necessity in bringing the model again to Hana DB for
modeling ? It's again dupl icating model/data right? We can directly build BO Reports from BEx query
which is from BW on Hana right?
(One correction: The view you've created is analytical view and it's not the calculation View)
Kindly suggest.
Regards,
Antony Jeral d.
Like (1)
Mohammad Safiullah 13-Mar-2014 08:43 (in response to Antony Jerald J)
Hii Antony ,
Yeah you are completely right .We can build BO reports from Bex Query directly .
It also depends on requirements .If you need to create analytic view/calcula tion view
on top of HANA-Optimised dso (imported as analytic view) and analytic view/attribute view
created on tables present in HANA schema or on flatfile data or on tables imported from
other sources, then you have build BO reports on HANA views .
If there is a complex calculatio n needs to be done in BEX , then it would be better if you do
it in HANA side rather than on BEx using HANA engine s because performance is much
faster .
I have created calculation view on top of two analytical view (i.e on top of two HANA-
Optimised DSO) .You can see that in 5.1 and calculation view is created as infocube is
imported which is described in 5.2.
Like (0)
Ramakrishnan Azhagappan 01-Apr-2014 08:59
Hello Mohammad,
This is useful for the entry level HANA Developers. Thanks for the awesome blog.
Like (0)
kamalakar madineni 30-Apr-2014 08:55
HI Mohammad,
thanks for sharing ...
thanks,
kamal
Like (0)
Chandra Sekhar 30-Apr-2014 08:42
Very good information.
Thanks & Regards,
Chandra Sekhar.
Like (1)
Mallikarjuna Gande 24-May-2014 19:08 (in response to Chandra Sekhar)
Hi,
When we have HANA as DB for BW 7.4, no manual import of DSO or Cube to HANA studio.
If you enable following option for DSO/Cube, system will create views in HANA studio. its
like auto importing.
And the only disadvantage with thi s, after transporting to Production /next system we n eed
re-active all views manually .
if anybody know, how to activate all views @time After transport, please do share. thanks.
http://scn.sap.com/people/ramakrishnan.azhagappanhttp://scn.sap.com/people/mallikarjuna.gandehttp://scn.sap.com/servlet/JiveServlet/showImage/105-492944-459598/DSO+settings.JPGhttp://scn.sap.com/people/kamalakhttp://scn.sap.com/people/ramakrishnan.azhagappanhttp://scn.sap.com/people/kamalakhttp://scn.sap.com/people/chandubihttp://scn.sap.com/people/mohammad.safiullahhttp://scn.sap.com/people/mohammad.safiullahhttp://scn.sap.com/people/mohammad.safiullahhttp://scn.sap.com/people/mallikarjuna.gandehttp://scn.sap.com/people/chandubi
-
8/17/2019 Step-By-step Guide to Implement Modeling Scenar..
18/18
Follow SCNSite Index Contact Us SAP Help PortalPrivacy T erms of Use Legal Disclosur e Copyr ight
Like (0)
Mohammad Safiullah 03-Jun-2014 15:10 (in response to Mallikarjuna Gande)
Thank you Mr Mallikarjuna Gande.
This option is available in BW 7.4 SP 6 and above .I didn't see this option in BW 7.4
SP 4.
Indeed I have checked this option and activated the DSO/Infocube and the
followin g view is au tomatically imported and created. Then I manually activated
the view to analyse the data further .
Thank you once again for this information.
Like (0)
Sanjay gupta 28-Sep-2014 13:41
Hi Mohammad,
Thanks for the nice information.
I have a small doubt here, for importing the BW models into SAP HANA, you are going into option file
---> import... etc...
But i heard that we have a T Code for importing the models into SAP HANA.
Do you have any idea about the Tcode for importing the models into SAP HANA?
Thanks & Regards,
D. Sanjay Gupta.
Like (0)
Vikrant Soni 29-Sep-2014 07:48
Nice Document, explaining the complete Use Case..
Regards,
Vikrant
Like (0)
Chandra Sekhar 29-Sep-2014 12:03
Hi,
Very useful document.
Thanks & Regards,
Chandra Sekhar.
Like (0)
kamalakar madineni 01-Oct-2014 07:55
nice one..
Like (0)
Manna Das 01-Oct-2014 09:11
useful doc. thanks a ton for sharing.
http://bit.ly/SCNFBhttp://scn.sap.com/people/kamalakhttp://scn.sap.com/people/vikrant.sonihttp://scn.sap.com/people/chandubihttps://accounts.sap.com/ui/public/viewTextResource?scenario=SCN&spId=504efd8ee4b0555c3c17b94e&resourceType=RESOURCE_TERMS_OF_USE&version=1&spDisplayName=SAP%20Community%20Network&locale=enhttp://bit.ly/SCNTwRhttp://scn.sap.com/people/sanjay_d37http://bit.ly/SCNyouThttp://scn.sap.com/people/mohammad.safiullahhttp://scn.sap.com/people/manna.dashttp://scn.sap.com/people/sanjay_d37http://www.sap.com/corporate-en/our-company/legal/copyright/index.epxhttp://scn.sap.com/docs/DOC-19361http://scn.sap.com/docs/DOC-18476http://scn.sap.com/people/chandubihttp://scn.sap.com/people/mohammad.safiullahhttps://accounts.sap.com/ui/public/viewTextResource?scenario=SCN&spId=504efd8ee4b0555c3c17b94e&resourceType=RESOURCE_PRIVACYPOLICY&version=1&spDisplayName=SAP%20Community%20Networkhttp://www.sap.com/corporate-en/our-company/legal/impressum.epxhttp://scn.sap.com/people/manna.dashttp://scn.sap.com/people/kamalakhttp://help.sap.com/http://spr.ly/SCNgoogleplushttp://scn.sap.com/people/vikrant.soni