BW/4 HANA - Overview

BW/4 HANA  -Next generation

BW/4 HANA

* Introduced in 2016
* Deeper integration with Big Data
* it requires BW 7.5 SP4
* Logical continuation
* not a part of NetWeaver
* Run on only SAP HANA
* Certain netWeaver is part(like transport..etc)

* Simplicity

* reducing modelling objects
* will have only 4 objects (earlier it was 10 objects)
* 2 objects for persistence (i.e ADSO & Infocube)
       * 2 objects persistence (ODS & Composite provider)
* leverage with 4 objects only

* Architecture
* less persistent layers
       * Reduced development efforts because less layers
       * every layer can be used for query
* combined layers from various layers

* Operations
* integration is tighter
* cloud deployments
   -->HEC
   -->AMAZON Webservices
   -->Microsoft

* Exposing data for SQL Consumption
* Automated generated views
* calculated views
* Automatic push down from BW to HANA

* Sources
*ECC,ASSE,SAP HANA
* Hive
* Face BOOK
* Excell
* Twitter
* SOAP
* Files
* 3rd RDBMS
* HADOOP
* TEXT
* Structured
* Social Media
* Email  to EIM--> (Smart Data Integration)-->SAP HANA Source system
        * SAP Source system
   SAP Sources -->ODQ (Extractor logic) --> oDP Source system

BusinessObjets for Business Users
* SAP BO Cloud (newly released)
* SAP BO Design studio
* SAP BO Analysis

Modern UI For modelling and Administration

Performance
push down in hana db
OLAP functionalities are push down
leveraging performance inside BW
Bring libraries and Algorithm

Advantages
* newly released
* not legal successor for existing BW
* focus on hana only
* enable flexible data warehouse Architecture (less layer,persistence, more virtualization,          combination..etc)
* Simplifies Data warehouse modelling and Administration

Functional overview
Data flow modelling
* Graphical data flow which looks like whiteboard
* BW objects with drag and drop (like
* Central modelling point for modelling point
* modell new and existing data flow, transformations,executed DTP...etc
* extend node for scale out architecture

SAP BW/4 HANA comes with new data flow modelling environment
simplifies management of large data volumes with flexible dynamic tiering concepts

Migration to SAP BW/4HANA

SAPBW on XDB--> SAP BW Powered by hana--> SAP BW 7.5 Powered by SAP HANA +SAP BW/4HANA start addon --> SAP BW/4HANA

Prerequisites for moving to SAP BW/4HANA 
* only use HANA -Optimized objects
* Only use ODP, HANA, and File source system
* NO 3.X dataflows
* No Bex front end tools/Bex query
* Planning not supported till further notice

Dataflow Transfer tool
* copy complete dataflows
* Automatic generations of SAP HANA-Optimized SAP BW Objects

Old flow --> Datasource ->DSO(STD)-->CUBE--> MP
New(after copy--> Datasource --> ADSO-->ADSP-->Composite provider
captures only dataflow metadata(no data)


Development Roadmap for SAP BW/4HANA
Q3-2016
Cloud deployment (Microsoft,amazon,SAP hec)
Dataflow modeler is easy and intuitive, replacement of DW Workbench modelling perspective
        pushdown all olap to hana (e.g loading master data)


Q1-2017
BW/4HANA Optimized BI Content


Q2-FP 2017
Automated Data life cycle management
based on partition and temperature definition
automatic data placement to extension nodes or NLS(SAP IQ,HADOOP)
parallel loads for master data (based on ADSO like data structures)

2017
Automation of complex Big Dataflows with SAP BW/4 HANA
Tight Coupling between Hadoop & BW/4 HANA Processes
further OLAP Push down


(T code for migration : RSB4HTRF)

Read More

SAP HANA STUDIO INSTALLATIONS

SAP HANA STUDIO INSTALLATIONS

About HANA Studio

• The SAP HANA studio is a collection of applications for SAP HANA database.
• It is a Client Tool
• Enables technical users to manage the SAP HANA database,
• to create and manage user authorizations, 
• and to create new or modify existing models of data in the SAP HANA database.
• used to access local or remote SAP HANA databases.
• runs on the Eclipse platform 3.6.

Platform supports

• The SAP HANA studio runs almost all platforms. 
• Below are the SAP HANA studio supported platforms:
• Microsoft Windows x32 and x64 versions of
• Windows XP 
• Windows Vista
• Windows 7
• Windows 8 
• SUSE Linux Enterprise Server SLES 11: x86 64-bit version
• Red Hat Enterprise Linux (RHEL) 6.5
• Mac OS 10.9 or higher

Software Download 

• Can be installed with Authorized 'S' user from service market place website

System Requirements

•  See the Product Availability Matrix (PAM) in SAP Service Market place website

HANA Studio

can be installed in below environment

• Linux
• MS Windows &
• Mac OS

Hana studio Installation steps in Windows Environment

Follow below steps:

Double click on the highlighted software

 Assign the path where we need to keep the installation log

This has completed the installation of HANA STUDIO for front client usage

...Next articles entails about adding HANA DATABASE in HANA STUDIO

Read More

Webi Report development navigations

CREATING QUERY ,SAVING AND EDITING QUERY	For creating query  you need to select Datasource as Universe or whatever available as per your requirement from LEFT HAND SIDE of webi screen and drag and drop Dimensions, Detailed objects and measures from LEFT HAND SIDE of query panel in to result panel. Now click on run query (Top of the RIGHT HAND SIDE), click on save list  BI PLATFORM.
	For editing query select Data access tab ---->edit  select required objects drag and drop from LEFT HAND SIDE of query panel into RIGHT HAND SIDE of query panel and run query and notice your new objects in Available object panel .Now drag and drop new objects  from LEFT HAND SIDE to RIGHT HAND SIDE.
Properties for a query	such as limiting the number or rows of data retrieved, setting security to allow or prevent other users from editing the query, and changing the order of prompts. open query----> Data access tab......>Edit......>query properties......> then you can see limits the number or rows of data retrieved and types of data to retrieve i.e retrieve duplicate records and retrieve non empty rows and prompt processing order , For security purpose allow other users to edit all queries ,For refresh reset context on refresh Now run query to refresh data
View the SQL or MDX query	When you run a query, Web Intelligence retrieves the data by running a script consisting of a series of SQL or MDX statements. SQL statements are used by relational databases, while MDX statements are used by OLAP databases. Web Intelligence allows you to view and edit the SQL generated by a query, and even copy and paste it to another application. You can view MDX queries but you cannot edit them open query----> Data access tab......>Edit......>view script here you can edit the SQL query by using Custom query script or copy and paste it to another application. Note: You can't edit  SQL script when query includes optional prompts.
you can view and modify Web Intelligence Rich Client application properties from BI launch pad	For this Preferences menu : Viewing ....>change the measurement unit from centimeters  to inches Locale: It determines how webi displays data such as date and number formatting Drill: It refers to the ability to interactively filter a report for example clicking on a particular year value to see only the data for that year.
In Web Intelligence you can display and modify properties that are assigned by default to the Web Intelligence document	open query ....>properties......>Document ; Now you can see number of options : Enhanced viewing :It optimize the report for onscreen viewing. Refresh on open: It is ensure that the latest data is displayed each time the reports open .  Permanent regional formatting :It is permanently applies the current date, time and currency locale to report. Use query drill down: It enables drilling in the data.  Enable query stripping :It removes unused objects from the query when the query is refreshed.  Auto merge dimensions: This option synchronizes dimensions that have the same name but are derived from separate queries.  Extend merge dimension values :This option  effects the way dimensions are joined when they are merged.
Usage of copy and turn into charts	Once you have created a table or chart in your report with the appropriate dimensions and measures, you can copy that report object and then make changes to the duplicate. you will copy the table in a report and then convert the duplicate table into a chart. Report element tab .....>turn into.....>Vertical table, cross tab, column, line, pie, crosstab
Add a report to a document	A Web Intelligence document can contain multiple reports on separate tabs. you will add another report to a document. Page setup tab...>add report...>Rename tab.
How to publish the Webi documents to the CENTRAL MANAGEMENT SERVER:	NOTE: When you work in Web Intelligence from BI launch pad, you can only save Web Intelligence documents to the CENTRAL MANAGEMENT SERVER. Open Query....>click on save list....>publish to.....>expand public folder,,,>Webi document folder...>click on advanced...>click on description...>enter description...>enter report name at NAME and then save expand public folder: when you publish to the Central Management Server, by default webi publish to your my favorites folder. only you can access documents published to your my favorites  folder .To allow other users to access the document, you must publish it to the public folders click on advanced: To help other users understand its purpose. Here some other options also u have 1)refresh on open 2)Permanent regional formatting 3) save for all users: i.e. other users also have authorized to open it. 4)Remove document security: to allow the documents to be viewed when disconnected from the Central Management Server
Save a document as other formats	You can save your Web Intelligence documents locally or in the SAP Business Objects Business Intelligence platform in the standard WID format, as a PDF document, or as an Excel spreadsheet click on save...>save as....>in filename box give any name like sales.wid...>in files of type choose excel or pdf what ever you want
Add another query to a document	A single Web Intelligence document can contain multiple queries open any webi document which is already having a report and click on data access tab...>click new...>select from universe...>select ur universe...>select...>drag and drop required objects into result panel....>run query....> now u can notice that a new table added to the report. now click on available objects(LEFT HAND SIDE) you can notice all the objects from both queries. Connecting to Data Sources:----
Change the data source on which a query is based	Web Intelligence allows you to change the data source used to create a document. This can be useful in instances where you are switching from test to production environments, changing between universes the cover different functional areas but are based on the same data source, or converting documents built on the old UNV format to the new UNX format. Here you will change the data source from the old eFashion universe to the new UNX format. Open query...> data access tab...>tools...>change source list...> select query...>select specify new data source. Or u can choose existing one depends up on requirement..>select a data source ..>select required universe...>click on select ...>next ...> finish. Observe here list of objects mapping correctly if it’s not you can browse..
In Web Intelligence, you can create reports based on Microsoft Excel spreadsheets.	Open webi....>select excel from choose data source to create a new document...> efashion.xlsx...>open...>next here you can restrict columns or rows if you want....>run query observe report.
Combine multiple queries	Combined queries are queries that work together to create a single result. There are three different operators that you can use to combine queries. The union operator returns all the data from both queries. The intersect operator returns only the rows that match both queries. The minus operator returns all the data from the first query minus any data that matches the second query. In this tutorial, you will create a combined query.
Merge dimensions from different universes	You can create queries based on multiple universes in Web Intelligence. In situations where those universes share similar data, you can merge the dimensions so that data from both sources can be displayed in the same table open query.....>data access...>data provider....>edit...>add query...>select required universe...>drag and drop objects...>run query...>select any option like 3rd...>drag and drop object in to Right Hand Side of report(table)...>observe report...> ...>click on merge...>select  at least 2 Objects...>o.k..>observe report
Connect to an Analysis view	You can use the results from an Analysis work space, exported as an Analysis view, as a data source for a Web Intelligence document. Note: Here u can’t choose the dimensions and measure to use in your query. as these are predefined by what was already available in the analysis work space when it was exported as a view. Note: that all items are automatically added to the table. but u can remove the unwanted columns or delete the entire table and create a new from scratch, using only those report objects u want.
Turn vertical table to horizontal to cross tab table :	Click the boarder of the table to select it...>tools....>turn into...>Horizontal table....>or cross tab.... If u want modify any table then turn in to.....>more transformations...>select & delete.
Deleting column in table	select header of the column ...>c.m...>delete. Or select header of the column...>click on cut.(top).
Adding charts to Web Intelligence reports	Create a chart: Insert a pie chart a pie chart showing sales revenue by state: Click on charts...>select pie...> click in the report panel...>c.m chart outer boarder...>edit...>select desire ones...>click on o.k.
Format chart to indicates the data value for each slice	c.m on chart inner boarder...>format boarders...>data values...>show data labels ...>o.k. now u can see the chart values outside. If u want chart values inside...>c.m chart inner boarder...>format boarders...>data values...>data type..>select value....>data position..>inside..>o.k. Now u can see the values inside of the pie chart
Turn a table into column chart	select table(top level): select tools: turn into column...>observe column chart if u feel difficult to find values then click on undo..> turn into more transformations...>select columns under table....>under category axis delete some columns & leave state, year. under value axis...>select sales revenue(measures)..>under regional color...>select year..>o.k. now observe column chart
Create a chart for hierarchical data	In order to create a chart that displays hierarchical data for a Bex query, you must first display the levels of the hierarchy that you want to show, as you cannot drill down into the hierarchy within the chart. Open report select table column..>c.m..>expand descendant..>click the boarder of the table..>turn into..>column observe the column chart
Create charts with hierarchical dimensions	22)Web Intelligence enables you to create charts based on hierarchical dimensions, and to drill to navigate the levels of the hierarchy within the chart. Create a column chart to display open orders by country: chart..>insert column chart drag and drop required objects. Now the chart currently displays the top level of hierarchy Now if u want to display hierarchy..>c.m on column bar..>hierarchical navigation...>all....>expand all hierarchy
Format a data series in a chart: i.e u can edit any part or specific part in pie chart or any chart:	Select one part of the pie chart....>c.m...>format data series...>select custom radio button..>click the color list..>select any color...>show data label..>o.k. Now you can see the changed color.
You can create links(hyper link) to external web sites from within your Web Intelligence documents	Click on report element tab...>click on linking tab...>click on cell in report plot area...>click hyper link tab.....>add hyper link...>click on text box...>type url and then click on parse...>click the target window list...>select new window..>o.k..>click hyper link in report plot area.
In the D HTML client for Web Intelligence, you can create hyperlinks in your document that open another document.	Select store name column without header...>click on linking tab...>document....>add document link...>browse...>select required report...>select and open...>select refresh on open...>o.k..>now click on any store name then u can see the details of particular store.
Drill down table	You can set up your Web Intelligence documents so that you have the ability to drill down into the data based on navigation paths that are set up in the universe to create hierarchies between dimensions, such as country, state, and city. Open webi report or drag and drop required objects in to result objects....>click on scope of analysis panel.(left top)...> click on master perspective(now u can see scope of analysis in Right Hand Side)...>display by navigation paths......>click on scope level list(Right Hand Side downside in scope of analysis) ...>select the desired level like 3 or 2.(now u can observe scope of analysis panel with fields)..>run query now u have to drill down
Drill down the query	Analysis tab...> drill...>start drill...>select any state(now observe on top), select any year(observe on top)...>now u can see quarters Q1,Q2...instead of years and city names instead of states...>on top u can check  the state lists and years and u can  select however u want ...>if u want u can drill up(in header of column u can see the option)
To copy the report	You can use snapshot option :drill...>snapshot...>now u can observe the copy report. To Disable drill down  functionality ...>drill..>end drill.

Read More