1Z0-531 試験問題を無料オンラインアクセス

You have the following analysis requirement. Products roll up to Product Family which rolls up to Product Category. You also need to group Products by Product Manager. Product Managers may manage one or more Products across product families. You do not need to create reports with Product Manager by Product Family. You need to secure products by Product Manager for planning submissions.
You consider Shared members as a solution because of which two options?

• A.Shared members provide additional categorization but results in a smaller database then if you were to add Product Manager as a separate dimension
• B.Shared members provide cross tab reporting (Product Manager in the rows and Product Family across the column)
• C.You can assign security to shared members
• D.Shared members can be assigned to sparse members only

What does DTS (Dynamic Time Series) do?

• A.Calculates to date values for Essbase aggregate storage databases
• B.Dynamically calculates the Time dimension
• C.Enable Time Balance functionality for accounts
• D.Calculates to date values for Essbase block storage databases

Which two options would provide a better design for the following accounts and metrics?

• A.If there are a large number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions
• B.If reporting dictates FTE and dollars in the columns and accounts in the rows, split Accounts and Metrics into 2 dimensions
• C.If block size is large, then keep Accounts and Metrics as one dimension with a dense dimension
• D.If there are a small number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions

Identify four disadvantages / considerations when using a transparent partition.

• A.Slow retrievals
• B.Old data
• C.Increased network load
• D.Outline sync complexities
• E.Downtime required to sync data
• F.Slow calculations if referencing dynamic calc members in the source

You need to calculate average units sold by the customer dimension within an ASO database. The member formula should calculate correctly regardless of level within the customer dimension. Identify the correct syntax for the member formula.

• A.@AVG (SKIPBOTH, "Units_Sold");
• B.Avg([Customer].Children, [Units_Sold]);
• C.Avg(Customer.Children, [Units.Sold]);
• D.Avg(Customer.CurrentMember.Children, [Units_Sold])
• E.Avg(Customer.CurrentMember.Children, [Units_Sold]);