How would one define this logic in the source data module?

A dashboard developer notices that Age is available in the sourced data module. A request has been made to 'bucket' those age values into 5 groups, Ages 0-6, 7-12, 13-21, 22-55, and 55 and over . How would one define this logic in the source data module?A . set range...

June 15, 2021 No Comments READ MORE +

Which of the following can result in poor report performance?

Which of the following can result in poor report performance?A . reports with filtersB . models with outer joins and cross joinsC . queries with database only processingD . an optimized metadata modelView AnswerAnswer: B

June 14, 2021 No Comments READ MORE +

What property needs to be set to ensure that any JavaScript and Prompt APIs are executed when a report is run as HTML?

What property needs to be set to ensure that any JavaScript and Prompt APIs are executed when a report is run as HTML?A . Ensure Enable bidirectional support is checkedB . Run with full interactivity is set to NoC . Enable drill up and drill down in the report outputD...

June 13, 2021 No Comments READ MORE +

To change the text item in a list column title or the data in the column body of a list object in a report, what first needs to happen?

To change the text item in a list column title or the data in the column body of a list object in a report, what first needs to happen?A . Select the cell and change the data format.B . Click on the Lock Page Objects icon to unlock the report.C...

June 12, 2021 No Comments READ MORE +

When should a dimensional function be used in a report's Query calculation?

When should a dimensional function be used in a report's Query calculation?A . when the data source is a dimensional or dimensionally-modeled data sourceB . to allow relative date functions to be performed against a non-dimensional data sourceC . to convert a non-dimensional data source into a dimensionally-modeled data sourceD...

June 12, 2021 No Comments READ MORE +

What does the developer need to do to accomplish this?

A user complains that the table they're using within a data module has too much historical data in it. The user would like to keep the old data available, but when using the table for any new reports would like to see only newer entries based on an 'Order Date'...

June 11, 2021 No Comments READ MORE +

Which of the following is true about integration with collaboration platforms?

Which of the following is true about integration with collaboration platforms?A . Integration with any collaboration platform can be used with report objects but not dashboard objects.B . Integration with IBM Connections is siC . A link to a report in "my content" can be shared to a team Slack...

June 11, 2021 No Comments READ MORE +

Which two statements are true when creating navigation paths?

Which two statements are true when creating navigation paths?A . A data module can have multiple navigation paths.B . A modeler must delete the navigation path and re-create it to change the path.C . Columns from different tables cannot be added to a navigation path.D . A navigation path is...

June 10, 2021 No Comments READ MORE +

A developer can make a Cognos PowerCube available to end users by creating a package and publishing it. From which three components is this possible?

A developer can make a Cognos PowerCube available to end users by creating a package and publishing it. From which three components is this possible?A . Administration consoleB . PowerPlay ClientC . PowerPlay StudioD . Framework ManagerE . TransformerF . Microsoft StudioView AnswerAnswer: A,D,E Explanation: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cra.doc/c_powercubes_ds.html

June 10, 2021 No Comments READ MORE +

Which of the following statements is valid when designing DMR structures in Framework Manager?

A Framework Manager model may be designed to incorporate Dimensionally Modeled Relational (DMR) objects, designed to offer the end user OLAP behavior when navigating data . Which of the following statements is valid when designing DMR structures in Framework Manager?A . Measures and Dimensions can reside in the same query...

June 10, 2021 No Comments READ MORE +