Number of questions: 57
Time allowed in minutes: 60
Required passing score: 75%
Languages: English, Japanese
IBM Certified Designer – Cognos 10 BI Multidimensional Reports
IBM Certified Solution Expert – Cognos BI
The Cognos 10 BI Multidimensional Author Exam covers key concepts, technologies, and functionality of the Cognos products. In preparation for an exam, we recommend a combination of training and hands-on experience, and a detailed review of product documentation.
Dimensional Data Components (28%)
Distinguish between relational, DMR, and dimensional data sources
Identify dimensional data items and expressions
Define multidimensional data structure components
Describe the importance of report context
Identify the default measure of a report
Describe default members and their purpose
Describe what a MUN is and identify the impact of using the wrong MUN
Describe what a set is
Describe what a tuple is
Focus Reports (14%)
Distinguish between dimensional and relational filtering styles
Identify techniques to focus data using the dimensional style
Interpret data that is focused based on members
Interpret data that is filtered based on measure values
Describe the purpose of a slicer
Drilling in Reports (14%)
Describe default drill-down behavior
Describe default drill-up behavior
Describe cases for advanced drilling configuration
Appraise reports generated with calculations that are preserved during drilling
Describe how member sets work
Drill-through Access (8%)
Identify supported drill-through data item combinations
Set-up drill-through access
Describe a conformed dimension
Calculations and Dimensional Functions (36%)
Describe the use of arithmetic operations in queries
Analyze the use of dimensional functions in queries
Apply prompts to focus reports
Compose complex expressions that combine and reuse existing expressions
To display all individual campaigns in a crosstab report, a report author could use the expression set([TrailChef Campaign],[EverGlow Campaign],[Course Pro Campaign]). Instead, the report author decides to use the parent member of the campaigns in the set expression “children([All Campaigns])”. Which statement is true about the method that was used?
A. In the future, when a campaign is deleted or new ones are added, the report author must modify the expression.
B. In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.
C. The report author should not have used the method chosen, as the first method is best
in this situation.
D. To be accurate, the report author should avoid using a set expression.
Which of the following statements is correct about the order function?
A. The currentMeasure function must be used with the order function as the sort by criterion.
B. It arranges members of all sets in the report by ascending or descending values.
C. Optional parameters allow the author to order the members of a hierarchy without regard of their level.
D. It arranges members of a set alphabetically by ascending or descending captions.
A report author is working with an OLAP data source. The report author creates a query that uses a caption function on a member and applies a string function. What is a possible consequence of this action?
A. Using these dimensional methods will not work with an OLAP data source.
B. The mapped string values will not pass through to the target report.
C. There is nothing wrong with this approach.
D. Mixing dimensional styles and relational styles in a single query can create unexpected results.
When must a report author use the caption function?
A. As the first parameter of the roleValue function.
B. To return the display name for the specified business key.
C. To see the string display name for the specified element.
D. To pass the returned value to a drill-through target report, this expects a matching string as a parameter value.
Instead of prompting the user to select any countries in Europe, the report author wants to constrain the user to select one or more countries from the Northern Europe region. What kind of prompt should be used and how can this be achieved?
A. This is not possible because a prompt must always be populated with all members of a level.
B. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe] member to retrieve its children on the country level.
C. Generate a prompt by creating an expression with a parameter on the crosstab edge: children([Northern Europe]->?Country?
D. Create a tree prompt, and populate it using an expression on the [Northern Europe]
member to retrieve its children at the country level.