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
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
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