Friday, December 30, 2016

Attribute View HA100

Attribute Views:

Attribute views:  
  • add context to data
  • regarded as master data tables
  • linked to fact tables in Analytical views
  • Attributes add context to data
  • Attributes are modeled using attributes views
  • Can be regarded as Master Data Tables
  • Can be linked to fact tables in Analytical Views
  • A measure e.g. weight can be defined as an attributes
  • Table Joins and properties
    • Left outer, right outer, full outer or text table
    • Cardinality 1:1, N:1, 1:N
    • Language Column





Step 1) Set Attribute View Parameters

  • Attribute View Parameters

Step 2) Select Tables

  • Tables folder within schema
  • Enter a filter pattern
  • Expand the Tables folder to display the filtered list of tables

Step 3) Define Join conditions

  • Referential Join
  • Inner join
  • Left and right join
  • Text Join
  • Star Join

Step 4) Select Key Attributes, Attributes, and set filters as needed

  • Output structure of the view must be explicitly defined
    • at least one key attribute is required
  • Define Static filter values
    • can be based on any table column
    • Column does not need to be selected for output
Step 5) Define Description Mappings
·         Add columns as an attribute form the table
·         You can change the property as hidden
·         Add the column label in the Semantics view
Step 6) Create Hierarchies (level Hierarchies)
·         Hierarchies are only accessible via MDX
·         Define a level hierarchy
·         Select column from output structure
·         Fixed number of levels
·         Need one attribute per Hierarchy level
Step 7) Create hierarchies( Parent child hierarchies)
·         Define a parent-child hierarchy
·         Variable number of levels for sub-tree within the hierarchy
Step 8) Create Calculated Attributes
·         Create an attribute based on a static value or dynamic calculation
·         Built in functions (Conversion, String, Math, Date …)
Step 9) Save and Activate the Attribute View
·         Save
·         Activate the view: creates a DB view in schema ‘_SYS_BIC’
·         Name of the column view: ‘_SYS_BIC<PACKAGE>/<VIEW_NAME>’
·         Activation turns the MODEL(design-time object) into a database object(run-time; column view)
Step 10) Preview the Data
·         3 Views
·         Raw data -table format of data
·         Distinct Values – Graphical and text format id unique values

·         Analysis – Select fields to display in graphical format of in a table


Qs:19 Which of the following automatically aggregates data? (Choose two)

A. Analytic view 
B. Calculation view 
C. Column table 
D. Attribute view


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:33 Which of the following are required elements when you create any type of hierarchy in SAP HANA? (Choose two

A. A child node 
B. An analytic view 
C. A data foundation 

D. An attribute view

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


20.  Type of cardinality between attribute view and text tables?

Ans  1:1 for text joins


 Hierarchies with hierarchy levels are supported in Attribute view?  True


 For Time Attribute views, which calendar types can be created?

·         Gregorian Calendar
·         Fiscal Calendar


72.Which of the following cardinalities are supported in Attribute view:

·         1:N
·         N:1
·         1:1






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


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


Column views(Attribute Views) are located in Schema_SYS_BIC,

Metadata is located in Schema_SYS_BI .

Private attributes from the Attribute views are used to join to the Key attributes ?   False

35.  Following types of joins are possible in Attribute view?
·         Referential Join
·         Inner Join
·         Outer Join

20.  Analytic privilege can be assigned to Attribute View?   True


32.  Without Analytic Privilege, no data can be viewed from

a.     Attribute Views
b.    Analytic Views
c.     Calculation Views

11.  Calculation View can contain the following:
a.     Database Tables
b.    Attribute Views
c.     Analytic Views
d.    Calculation Views

No comments:

Post a Comment