BI0-132 試験問題を無料オンラインアクセス

An author creates a Report Studio report that contains Month, Product Line and Revenue. Revenue has a footer to show the overall total. What will the author see in the generated Cognos SQL for the Revenue footer column?

• A.XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue
• B.XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) at Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1
• C.XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue2
• D.XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) in Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue

In order to create complex joins in Framework Manager, a modeler can use which of the following techniques?

• A.Open the Relationship Expression dialog, and then change both cardinality settings to 0..n or 0..1.
• B.Right-click a relationship in the Object diagram or Context Explorer, and then select "Create Compound Join".
• C.Open the Relationship Definition dialog, and then edit the join expression as required.
• D.Select the relationship, and then from the Actions menu, select "Merge in New Query Subject".

In a transitive relationship scenario, what problems exist when reporting from the tables below?

• A.Outer joins are generated when querying from Customer.
• B.The Order Detail table has conflicting cardinalities.
• C.The Order table must be included in each query.
• D.There is more than one possible path between the tables.

Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?

• A.Resolve conflicting keys and indexes and generate minimized SQL.
• B.Resolve reporting traps and simplify snowflake tables through consolidation.
• C.Combine facts and dimensions for intuitive ad hoc business views.
• D.Provide dimensional information through the use of determinants.

With respect to Cognos 8 security, which of the following is true of the Cognos namespace?

• A.Only contains predefined groups and roles.
• B.Can be deleted if a different namespace is used to secure the environment.
• C.Can be used to create custom groups, roles and users.
• D.Can be used to createCognos 8 specific groups and roles.