Correct Answer: C

Note: This source should be combined with other sources at this level (check box) Description: Check this box when data sources at the same level of aggregation do not contain overlapping information. In this situation, all sources must be combined to get a complete picture of information at this level of aggregation.

Note 2: To use a source correctly, the Analytics Server has to know what each source contains in terms of the business model. Therefore, you need to define aggregation content for each logical table source of a fact table. The aggregation content rule defines at what level of granularity the data is stored in this fact table. Use the Content tab of the Logical Table Source dialog box to define any aggregate table content definitions, fragmented table definitions for the source, and Where clauses (if you want to limit the number of rows returned).

Reference: Siebel Business Analytics Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in a Repository > Creating and Administering Logical Table Sources (Mappings) > Defining Content of Logical Table Sources

Correct Answer: B

Explanation: Steps to Create a Dimension Hierarchy - >Create a dimension object.Add a parent-level object.Add child-level objects.Determine number of elements.Specify level columns.Create level keys.Create a level-based measure.Create additional level-based measures.Create share measures.Create rank measures.Add measures to Presentation layer.Test share and rank measures.

Correct Answer: AC

Note: A level-based measure is a column whose values are always calculated to a specific level of aggregation.

The calculation of this measure is independent of the query grain and used always the aggregation grain of the logical column.

Level-based measures allow :

*

to return data at multiple levels of aggregation (the query grain and the level-based column grain) with one single query

*

to create share measures (percentage), that are calculated by taking some measure and dividing it by a level-based measure. For example, you can divide salesperson revenue by regional revenue to calculate the share of the regional revenue each salesperson generates.

Correct Answer: A

Explanation: You can nest presentation folders in two ways.

1) You can enter a hyphen and a greater than sign in the description field of the table to achieve the result.

2) Or, prefix the name of the presentation folder to be nested with a hyphen and a space and place it after the folder in which it nests to achieve the same result as shown below.

Result

Correct Answer: ACD