How do I use conditional formatting in cognos report Studio?

Posted on by Muna Meyer

How do I use conditional formatting in cognos report Studio?

How to apply simple conditional formatting in Cognos Analytics using Conditional Styles

  1. Open or create a report that you want to add conditional styles to.
  2. Select the object you wish to use.
  3. From the Properties pane on the right, go to Conditional Style.
  4. Click the green ‘+’ icon and select New conditional style.

How do you use expression in cognos?

Procedure

  1. From the left pane, locate and select the component you want.
  2. Click the arrow button to add the component to the expression.
  3. Continue adding components until your expression is complete.
  4. Click OK.

What is Cognos Express?

IBM Cognos Express is a business intelligence and planning platform with integrated Reporting, Analysis, Planning and Budgeting modules, offered by IBM for mid-sized companies. It is a pre-configured out-of-the-box BI platform, easy to deploy, manage and requires a minimum IT involvement.

What is conditional formatting in Cognos?

Conditional formatting allows you to highlight exceptional data in a report. You can format parts of your report based on one or more string values, a report condition, or data values. For more report formatting information, see the IBM® Cognos® Analytics – Reporting User Guide .

How do you apply a style variable in Cognos 11?

Procedure

  1. Create a variable and define the condition that determines if the data will be highlighted.
  2. In the work area, click the column to highlight based on the condition.
  3. In the Properties pane, double-click the Style variable property.
  4. Click Variable, click the variable to assign to the object, and click OK.

What are Cognos parameters?

Parameters in Cognos are based on prompts whereby a prompt is created that has an associated parameter value. This parameter value can be used in the filter in a query or it can be displayed on a report page. Parameter values provide the answers to the questions.

How do I edit parameters in Cognos Report Studio?

Procedure

  1. Right-click a query in the model and click Edit Prompts.
  2. For each prompt that you want to specify values for, in the Query Prompts dialog box, click the Value box for the prompt that you want to define.
  3. Define the variable or value for the prompt:

How to use nested IF statements in Cognos Report studio?

The Cognos Report Studio nested IF statement is as follows: IF (A > B) THEN (Total (A)) ELSE IF (C>D) THEN (Average (C)) ELSE (Count (A)) Remember that every IF must have an ELSE match in order for the syntax to be correct in Cognos Report Studio. I always think of the ELSE as an period at the end of a sentence.

Is there a full qualifier for [original_prod] in report studio?

Make sure use the full qualifier for [Original_Prod] and take out the single code. try it. Thank you both for giving your valuable suggestions on implementing the expression Format in Report Studio/Framework Manager.

Where can I find additional tips for learning IBM Cognos BI?

For more tips join the Lodestar Solutions community on our website at www.lodestarsolutions.com. If you need additional consulting or training on IBM Cognos BI please contact us at [email protected].