Online Access Free COG-645 Practice Test

When the report consumer drills through from a dimensional member to a relational data item, what data type is passed?

• A.Business key
• B.Member unique name
• C.Caption value
• D.Category code

When must a report author use the caption function?

• A.To see the string display name for the specified element.
• B.To pass the returned value to a drill-through target report,this expects a matching string as a parameter value.
• C.To return the display name for the specified business key.
• D.As the first parameter of the roleValue function.

Assuming that Star products and Husky products are sets,

which statement below is correct about the sets in the graphic?

• A.The report creates a query for each member of the set.
• B.The query displays each set as all the members of the level.
• C.Each set can be sorted and aggregated.
• D.Each set is a grouping of members from different hierarchies.

What is the default behavior when drilling down on an edge in a crosstab report?

• A.The edge expression is replaced with the children of the item drilled on.
• B.The level drilled on is replaced with the entire level below it.
• C.All edge expressions of the crosstab are replaced with their children.
• D.The edge expression is changed to another item in the query.

A report author creates a report with a drill-through definition. In the target report the parameter expression is "<Level expression> ->?P?". What type of data must be passed to the parameter?

• A.A value
• B.Any member from the hierarchy
• C.A business key from the level
• D.A member from the level