Select database use has two types of databases SAP & NON SAP Based on databases and loading performances we need to select replication methods We have three types of replication methods in Hana
Or we can bring the data from different data sources. Using data provisioning
NOTE: we can use data provisioning for less amount of data & initial load, not for delta Loads. And after finishing loading data from different sources into tables we need to model the views. Here we have two types of views
Based on the reporting requirement we will create the above views to increase the performance Creating relational views Right-click on the table and create a new view If you want we can add multiple tables & join multiple tables ( with inner/outer (left, Right, full)) Select required columns And activate Create column view (OLAP)
Right-click on the package to create a new analytic view Select the required tables and attribute views If you take multiple tables to join multiple tables (with inner/outer (left, Right, full)) Select the required column from the table and classified as attribute & measures And create customs calculated Attributes, calculated measures, Restricted measures & custom variables & activate
Right-click on the package Create new calculated view We can create two types of calculated views.
In the script pane provide script and right side create the output structure and provide column Names & types In the output pane classify objects that have attributes measures & calculated measures & variables and activate Graphical Select required tables & views (attribute, analytic and calculated views) Connect they by using projection, union, join (inner/outer(lefty, righty, full)) In output pane classify objects as an attribute, measures and create custom Measures based on report requirements &k activate
Steps in business object advanced analysis: Logon to business objects Start programs SAP Business objects à analysis for Microsoft Excel. We will get Excel with analysis (tab) Click on the insert data source and select log on to Business Object BI platform. So you will get a dialog box. Provide URL Like “http//<application server>; <port>/dswsbobje/services/session. So that you will get the dialog box for data sources Select our system (HANA system) Provide username password and port number and click on connect Select catalogs, select the required catalog & select tables/views and Ok So you will get a separate screen for advanced analysis as bellow.
Activates for Designing analysis reporting for Excel
Inserting a cross tab
Select the Insert data source
Select source system & drag object hurt Rows columns & filters
If you want to refresh the value in the cross tab we should select display on advanced analysis options and we can pass the refresh
Formatting Data: We can format data in two ways for attributes
By right-clicking the value of characteristics and selecting member display ------- text/key
Inertly click on member display ---- and select text /key
For numbers right-click on measure value select number format and we will get a dialog box for member format select scaling factor and decimals
Sorting & Filtering: Right-click on any column and select ascending/deceiving and we can sort culture reports based on attribute values or measure values We can filter data by members or measures. For members select operators like b/u outside, greater than, less than, greater than or equal to, less than or equal to, equal to and not equal to and not equal to W can comb me multiple lilting by using and /or
Charting: For charting, we must have at least ova measure and select our cons tab Click on chart select chart type and ok
Right-click on the measure column and select filter by member menu we will get a dialog box for conditional formatting so provide the name
Publishing reports: After design reports, we can publish reports into business object entries.
For in-depth knowledge of SAP HANA, click on below
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Get stories of change makers and innovators from the startup ecosystem in your inbox