Analytical View HA100

Analytic View:

·         Regarded as “cube”

·         Multidimensional reporting model

·         Fact Table joined against modeled dimensions(attribute Views)

• Similar to Cube
• Analytic Views does not store any data. The data is stored in column store table or view based on Analytical View structure
• Attributes and Measures – Like key figures
• Data Preview – Similar to list cube functionality

·         Data is read from the joined db tables

·         Joined and calculated measures are evaluated at run time

·         Master data for MDX/BICS are stored in system tables

Step 1) Set Analytic View Parameters

Step 2) Select table

·         Data Foundation View

·         Create a fact table by adding and joining the tables

·         Logical Join view

·         Join attributes to these tables in the logical join node

·         Semantics View

·         Classify the columns and calculated columns as attributes and measures.

·         Create variables/input parameters, and assign variables to the columns in the Semantic node

·         Analytic View Editor

·         Create a fact table by adding the tables in the data foundation node.

·         Join attribute views to tables in the Logical join node

·         Output Pane

·         Models view elements:

·         Column

·         Calculated Columns

·         Restricted Columns

·         Input Parameters

·         Semantics node

·         Classify

·         Columns as attributes

·         Calculated columns as measures

Step 3) Select Attribute Views (optional)

·         Attribute Views can be added to the logical join

·         View Creation

·         Data foundation

·         Create the data foundation (‘Fact table’)

Step 4) Join Attribute Views

·         Data foundation view: shows the physical table with all fields that can be incorporated in the final model

·         Logical Join views: displays the fields that you have chosen to include I the output of the data foundation node, as well as the restricted and calculated measures

·         Analytic view (data foundation view)

·         Features

·         Add columns

·         Create column filters

·         Create joins if more than one table

Step 5) ?

Step 6) Calculated Measures

Step 7)  Create Restricted Measures

·         Semantics view you can classify the Columns and Calculated columns as attributes and measures

·         Can create variables/input parameters

·         Assign variables to the columns

Step 8)  Save and activate

·         Creates a column view (DB view) in schema _SYS_BIC

Step 9) Data Preview

·         Raw data-table format of data

·         Can create filters

·         Distinct Values -graphical and text format id unique values

·         Analysis- Select fields to display in graphical format or in a table

·         Table, selection of chart types and templates

Qs:3 Which of the following can be part of an analytic view? (Choose three)

A. Query transformation 
B. Unions 
C. Logical joins 
D. Data foundation 
E. Attributes


Qs:25 You want to restrict access to SAP HANA information models based on user groups. The models are accessed through an SAP BusinessObjects report. In which of the following can you implement these restrictions? (Choose two)

A. The schema mapping 
B. The restricted measures 
C. The analytic privileges 

D. The universe


Qs:37 An analytic view has two columns, SHIP_TO_COUNTRY and SHIP_FROM_COUNTRY, that contain ISO country codes. You must replace these codes with the English country names by joining to the same country attribute view twice. What must you create to achieve this?

A. A derived attribute view 
B. A shared attribute view 
C. Two data foundations 

D. An attribute view using the Copy From method.


Qs:48 How can you create a computed column in an information model? (Choose two)

A. Create a calculated attribute within a calculation view. 
B. Create a counter in an analytic view. 
C. Create a restricted measure in a calculation view. 

D. Create a restricted measure in an analytic view.

Qs:49 You create a graphical calculation view that is based on analytic views. What do you use to combine the data from the analytic views?

A. Referential join 
B. Projection node 
C. Aggregation node 

D. Union


67.  Filter values can assigned at the ‘Data foundation’ in the Analytic view ? True

77.  Attribute view provides the master data information & can be used in any analytic view ? True

What is Private Attribute ?

Private Attributes : Private attributes are used to model analytic views and cannot be used outside the

view. Private attributes are required to link to the subject area or attribute views. Private attributes add  

              more information to the model. Private Attribute selected from a Database table

73.  Is it possible to add tables later after the Analytic view is created ? True

• Analytic Views are like cube model where Transaction Data is connected to attribute view

11.  Calculation View can contain the following:

a.     Database Tables

b.    Attribute Views

c.     Analytic Views

d.    Calculation Views

Without Analytic Privilege, no data can be viewed from

a.     Attribute Views

b.    Analytic Views

c.     Calculation Views

 Validation rules of Analytic View can be selected & de-selected from the ‘Manage Preferences’? True