Tuesday, January 3, 2017

H100 BO Analysis for OLAP/BEX

BO Analysis for OLAP

·         Dedicated Ad-Hoc OLAP  client for Business users to analyze OLAP data
·         Interoperability between designer and ad-hoc client
·         Simultaneous connection to multiple queries from different data providers
·         Report off analytic views/calculation views
·         Web based applications

·         Save/open a workbook to/from the SAP BI platform server
·         Undo/Redo
·         Define style sets for crosstabs
·         Swap axes
·         Analyze data with the design panel
·         Filter members
·         Sort data by members and by measures
·         Insert Charts
·         Insert filter components
·         Convert crosstab cells to formula
·         Create Presentations
·         Pause/Refresh


Access Analytics and Calculation Views from Analysis Edition from OLAP via OLAP Connection defined inside the Central Management Console of BO Enterprise Server

BO Analysis, edition for OLAP = Multidimensional data analysis within a web-based environment


------------------------------------------------------------------------------------------
Org has got a vast amount of data to explore the data and find patterns to which no set report exists
------------------------------------------------------------------------------------------

Explain when to use Bex on top of HANA
Explain how to configure SAP BO to use HANA
Create an Explorer Info SPace to Explore HANA data within Explorer


1)Explain when to use Bex on top of HANA
·         Key word search to find bzn info
·         Answers on the fly and investigates questions

·         Searches directly on pre-indexed data
·         No previous reports or metrics need to exist
·         Fast exploration
·         Searches across all data sources
·         Any universe accessible source
·         Any netWeaver BW Accelerator accessible source


2) Explain how to configure SAP BO to use HANA
Connection defined in IDT
View created from HANA Studio
BO Explorer = Search relevant information and direct exploration of data


3) Create an Explorer Info Space to Explore HANA data within Explorer


1) Start SAP BI LaunchPad
2) When prompted to logon to BI Launchpad, enter the following information
3) In the My Application menu, choose Explorer
4) Choose manage Spaces
5) Expand the folder SAP Hana appliance -> HDB
6) Select the Calculation View 
7) to create a new info space on this calculation view, choose new
8) in the properties tab, define the following properties
         Measure
        Attribute
9)To index the new Infospace, in the Action column choose index now
10)Back to the home tab, to update the list of info spaces, choose refresh list
11) open the info space:
12) ready to explore the data set

No comments:

Post a Comment