Online Access Free C_HANAIMP_1 Exam Questions

You have created an analytic view and an analytic privilege that filters on 3 attributes:
-Sales region = "West"
-Sales channel = "Online", "Retail"
-Product category = "Electronics".
After granting the analytic privilege to a user, what data can the user see?
A)

B)

C)

D)

• A.Exhibit A
• B.Exhibit C
• C.Exhibit D
• D.Exhibit B

Which of the following are required to build a SQLScript calculation view? (Choose two)

• A.Add columns to the var_out output parameter.
• B.Define a measure.
• C.Set the MultiDimensional Reporting property to false.
• D.Define a data foundation.

You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this? (Choose three)

• A.Assign values to be restricted. Choose at least one information model to assign restrictions.
• B.Choose an attribute to define restricted values for it.
• C.Assign the analytic privilege to a user or role.
• D.Assign restricted values to the attribute view.
• E.Assign values to be restricted to a content table.

You are building a calculation view and want to select data from an analytic view. How can you achieve better performance for this requirement?

• A.Use CE functions
• B.Use L programming
• C.Use SQL statements
• D.Use table indexing

Where is the physical data stored, on which a calculation view is based?

• A.In a schema
• B.In the _SYS_BI schema
• C.In a package
• D.In the _SYS_BIC schema