- What is Lean?| Everything You Need to Know
- What is SAP Workflow? : A Complete Guide
- Difference between Tableau and Power BI | Benefits and Special Features
- Data Warehouse in Tableau | Everything You Need to Know
- What is Tableau Server?| Everything You Need to Know | A Definitive Guide
- What is Dax in Power BI? | A Comprehensive Guide
- Upgrade in Tableau Desktop and Web Authoring | A Complete Guide with Best Practices
- What is SAP HANA | SAP HANA Database Connection | All you need to know [ OverView ]
- SAP BPC – What is Business Planning and Consolidation? : All you need to know [ OverView ]
- Root Cause Analysis: Definition, Examples & Methods | All you need to know [ OverView ]
- Seven Basic Quality Improvement Ishikawa Tools | Important asset to control quality in your project [OverView]
- What is Power BI | Its Use Cases and Applications | All you need to know [ OverView ]
- How and why to measure and analyze employee productivity | Everything You Need to Know
- Top 10 Employee Retention Strategies | Everything You Need to Know
- What are LookML Projects and the Developer Mode | How to Create LookML Projects?
- What are Slowly Changing Dimension | SCD Types and Implementations | Step-By-Step Process
- What is Pareto Chart and How to Create Pareto Chart | A Complete Guide For Beginners
- What does an Agile Business Analyst do | Required Skills, Roles and Responsibilities [ Job & Future ]
- What is Lean Management? | Role and Concepts of Lean Management | Expert’s Top Picks
- A Definitive Guide of Working Capital Management with Best Practices & REAL-TIME Examples
- Business Analytics with Excel Fundamentals | A Complete Guide For Beginners
- Business Analyst : Job Description | All you need to know [ Job & Future ]
- How to create a Splunk Dashboard | A Complete Guide For Beginners [ OverView ]
- What is Splunk Logging ? | The Ultimate Guide with Expert’s Top Picks
- Alteryx vs Tableau | Know Their Differences and Which Should You Learn?
- What is Predictive Analytics? : Step-By-Step Process with REAL-TIME Examples
- An Overview of SAS Stored Processes | The Ultimate Guide with Expert’s Top Picks
- How to Create Conditional Formatting in Cognos Report Studio | A Complete Guide
- Difference between OLTP vs OLAP | Know Their Differences and Which Should You Learn?
- ECBA vs CCBA vs CBAP | A Complete Guide For Beginners | Know Their Differences and Which Should You Learn?
- Import Custom Geocode Data in Tableau | Everything You Need to Know [ OverView ]
- Data Warehouse Tools : Features , Concepts and Architecture
- PGDM vs MBA | Know Their Differences and Which Should You Learn?
- Most Popular Data Visualization Tools | A Complete Beginners Guide | REAL-TIME Examples
- Tableau vs Looker : Comparision and Differences | Which Should You Learn?
- Benefits of Employee Satisfaction for the Organization [ Explained ]
- DAX In Power BI – Learn Power BI DAX Basics [ For Freshers and Experience ]
- Power Bi vs Tableau : Comparision and Differences | Which Should You Learn?
- What is Alteryx Tools | Alteryx ETL Tools | Comprehensive Guide
- What is Tableau Prep? : Comprehensive Guide | Free Guide Tutorial & REAL-TIME Examples
- What are Business Intelligence Tools ? : All you need to know [ OverView ]
- Tableau Aggregate Functions | A Complete Guide with REAL-TIME Examples
- Intervalmatch Function in Qlikview | Everything You Need to Know [ OverView ]
- QlikView Circular Reference | Free Guide Tutorial & REAL-TIME Examples
- Data Blending in Tableau | A Complete Guide with Best Practices | Free Guide Tutorial [ OverView ]
- Splunk vs ELK | Differences and Which Should You Learn? [ OverView ]
- QlikSense vs QlikView | Differences and What to learn and Why?
- What Is Measurement System Analysis | Required Skills | Everything You Need to Know
- Splunk Timechart | Free Guide Tutorial & REAL-TIME Examples
- What Is Image Processing ? A Complete Guide with Best Practices
- What is a Business Analysis ? A Complete Guide with Best Practices
- Top Business Analytics Tools | Comprehensive Guide
- Business Analyst Career Path [ Job & Future ]
- Time Series Analysis Tactics | A Complete Guide with Best Practices
- What is Splunk ? Free Guide Tutorial & REAL-TIME Examples
- Which Certification is Right for You: Six Sigma or Lean Six Sigma?
- SAS Vs R
- Top Technology Trends for 2020
- Data Analyst vs. Data Scientist
- What are the Essential Skills That You Need to Master in Data Analyst?
- What is Six Sigma?
- Common Cause Variation Vs Special Cause Variation
- Reasons to Get a Six Sigma Certification
- What Is Strategic Enterprise Management and its Components?
- What Are The Benefits Measurement Constrained Optimization Methods?
- What Is the Benefit of Modern Data Warehousing?
- What Is Corporate Social Responsibility (CSR)?
- What Is The Purpose and Importance Of Financial Analysis?
- What is Insights-as-a-Service (IaaS)?
- Business Analytics With R Programming Languages
- Where Are The 8 Hidden Wastes?
- What Are Market Structures?
- What is Cost of Quality (COQ)?
- What is Build Verification Testing?
- Quality Improvement in Six Sigma
- What is Process Capability Analysis?
- How To Measure The Effectiveness Of Corporate Training
- SAP Financials And SAP Accounting Modules
- Tips to Learn Tableau
- Why Should I Become a CBAP?
- History And Evolution of Six Sigma
- How to use Control Chart Constants?
- Data Analytics Course For Beginners
- How to Build a Successful Data Analyst Career?
- Data Analytics Vs Business Analytics
- What is SAP Certification?
- Books To Read For a Six Sigma Certification
- Six Sigma Green Belt Salary
- What is the ASAP Methodology?
- Complete list of SAP modules
- What is Lean?| Everything You Need to Know
- What is SAP Workflow? : A Complete Guide
- Difference between Tableau and Power BI | Benefits and Special Features
- Data Warehouse in Tableau | Everything You Need to Know
- What is Tableau Server?| Everything You Need to Know | A Definitive Guide
- What is Dax in Power BI? | A Comprehensive Guide
- Upgrade in Tableau Desktop and Web Authoring | A Complete Guide with Best Practices
- What is SAP HANA | SAP HANA Database Connection | All you need to know [ OverView ]
- SAP BPC – What is Business Planning and Consolidation? : All you need to know [ OverView ]
- Root Cause Analysis: Definition, Examples & Methods | All you need to know [ OverView ]
- Seven Basic Quality Improvement Ishikawa Tools | Important asset to control quality in your project [OverView]
- What is Power BI | Its Use Cases and Applications | All you need to know [ OverView ]
- How and why to measure and analyze employee productivity | Everything You Need to Know
- Top 10 Employee Retention Strategies | Everything You Need to Know
- What are LookML Projects and the Developer Mode | How to Create LookML Projects?
- What are Slowly Changing Dimension | SCD Types and Implementations | Step-By-Step Process
- What is Pareto Chart and How to Create Pareto Chart | A Complete Guide For Beginners
- What does an Agile Business Analyst do | Required Skills, Roles and Responsibilities [ Job & Future ]
- What is Lean Management? | Role and Concepts of Lean Management | Expert’s Top Picks
- A Definitive Guide of Working Capital Management with Best Practices & REAL-TIME Examples
- Business Analytics with Excel Fundamentals | A Complete Guide For Beginners
- Business Analyst : Job Description | All you need to know [ Job & Future ]
- How to create a Splunk Dashboard | A Complete Guide For Beginners [ OverView ]
- What is Splunk Logging ? | The Ultimate Guide with Expert’s Top Picks
- Alteryx vs Tableau | Know Their Differences and Which Should You Learn?
- What is Predictive Analytics? : Step-By-Step Process with REAL-TIME Examples
- An Overview of SAS Stored Processes | The Ultimate Guide with Expert’s Top Picks
- How to Create Conditional Formatting in Cognos Report Studio | A Complete Guide
- Difference between OLTP vs OLAP | Know Their Differences and Which Should You Learn?
- ECBA vs CCBA vs CBAP | A Complete Guide For Beginners | Know Their Differences and Which Should You Learn?
- Import Custom Geocode Data in Tableau | Everything You Need to Know [ OverView ]
- Data Warehouse Tools : Features , Concepts and Architecture
- PGDM vs MBA | Know Their Differences and Which Should You Learn?
- Most Popular Data Visualization Tools | A Complete Beginners Guide | REAL-TIME Examples
- Tableau vs Looker : Comparision and Differences | Which Should You Learn?
- Benefits of Employee Satisfaction for the Organization [ Explained ]
- DAX In Power BI – Learn Power BI DAX Basics [ For Freshers and Experience ]
- Power Bi vs Tableau : Comparision and Differences | Which Should You Learn?
- What is Alteryx Tools | Alteryx ETL Tools | Comprehensive Guide
- What is Tableau Prep? : Comprehensive Guide | Free Guide Tutorial & REAL-TIME Examples
- What are Business Intelligence Tools ? : All you need to know [ OverView ]
- Tableau Aggregate Functions | A Complete Guide with REAL-TIME Examples
- Intervalmatch Function in Qlikview | Everything You Need to Know [ OverView ]
- QlikView Circular Reference | Free Guide Tutorial & REAL-TIME Examples
- Data Blending in Tableau | A Complete Guide with Best Practices | Free Guide Tutorial [ OverView ]
- Splunk vs ELK | Differences and Which Should You Learn? [ OverView ]
- QlikSense vs QlikView | Differences and What to learn and Why?
- What Is Measurement System Analysis | Required Skills | Everything You Need to Know
- Splunk Timechart | Free Guide Tutorial & REAL-TIME Examples
- What Is Image Processing ? A Complete Guide with Best Practices
- What is a Business Analysis ? A Complete Guide with Best Practices
- Top Business Analytics Tools | Comprehensive Guide
- Business Analyst Career Path [ Job & Future ]
- Time Series Analysis Tactics | A Complete Guide with Best Practices
- What is Splunk ? Free Guide Tutorial & REAL-TIME Examples
- Which Certification is Right for You: Six Sigma or Lean Six Sigma?
- SAS Vs R
- Top Technology Trends for 2020
- Data Analyst vs. Data Scientist
- What are the Essential Skills That You Need to Master in Data Analyst?
- What is Six Sigma?
- Common Cause Variation Vs Special Cause Variation
- Reasons to Get a Six Sigma Certification
- What Is Strategic Enterprise Management and its Components?
- What Are The Benefits Measurement Constrained Optimization Methods?
- What Is the Benefit of Modern Data Warehousing?
- What Is Corporate Social Responsibility (CSR)?
- What Is The Purpose and Importance Of Financial Analysis?
- What is Insights-as-a-Service (IaaS)?
- Business Analytics With R Programming Languages
- Where Are The 8 Hidden Wastes?
- What Are Market Structures?
- What is Cost of Quality (COQ)?
- What is Build Verification Testing?
- Quality Improvement in Six Sigma
- What is Process Capability Analysis?
- How To Measure The Effectiveness Of Corporate Training
- SAP Financials And SAP Accounting Modules
- Tips to Learn Tableau
- Why Should I Become a CBAP?
- History And Evolution of Six Sigma
- How to use Control Chart Constants?
- Data Analytics Course For Beginners
- How to Build a Successful Data Analyst Career?
- Data Analytics Vs Business Analytics
- What is SAP Certification?
- Books To Read For a Six Sigma Certification
- Six Sigma Green Belt Salary
- What is the ASAP Methodology?
- Complete list of SAP modules

How to Create Conditional Formatting in Cognos Report Studio | A Complete Guide
Last updated on 03rd Nov 2022, Artciles, Blog, Business Analytics
- In this article you will get
- 1.Why use Conditional formatting?
- 2.Conditional formatting
- 3.Conditional formatting – String variables
- 4.Conditional formatting – Boolean variables
- 5.Conclusion
Why use Conditional formatting?
Almost each object that can be used in report can have Conditional Formatting applied to it… the exceptions are some , with Singletons, Custom Controls not having feature. The most typical use for the Conditional Formatting is probably are Red/Yellow/Green formatting of values to an indicate bad/fair/good performance, but usefulness of a Conditional Formatting extends beyond this example.
Used Conditional Formatting most recently to hide a rows/columns of a Crosstab if a specific condition is met/not met, or similarly, to hide a prompt controls. Another good use is a styling within multi-dimensional authoring (such as TM1 cube) where multiple levels of hierarchy are being rendered.

Conditional formatting
Conditional Formatting is the process of formatting a business data based on given condition.Users can quickly analyse the business data by using a conditional formatting.Conditional formatting can be done with a help of the variables.There are three types of a variables – STRING, BOOLEAN, REPORT LANGUAGE VARIABLES.Variables are used to hold results of the expression.
Conditional formatting – String variables
- Create the list report with following query items
- An Order year, Order method, Quantity
- Group on a order year
- Total on a quantity
- Go to the conditional explorer- Click on variables
- From an insertable objects, pane drag a string variable and drop it on a variable window
- Explain the following expression in an expression definition window
- if ([Query1].[order year]=2004) then (1)
- else if ([Query1].[order year]=2005) then (2)
- else if([Query1].[order year]=2006) then (3)
- Click on a validate- click on OK
- Add variables 1,2,3 to a values list
- Click on a add – give a values
- Click on OK
- From a page explorer,
- Open a report page page1
- Select a order year data item
- From an ancestor, properties click on a list columns body style
- From a conditional explorer,
- Select a string variable 1
- From a properties pane, select a style variable
- Click on the eclipses { … }
- Set a variable as string1
- Select a string variable1
- Select a font property- click on eclipses
- Set a font size and also color
- From a condition explorer
- Select a string variable 2
- Set a font size and also color
- From a condition explorer,
- Select a string variable 3
- Set a font size and color
- Turn off an explorer bar (By double-clicking) and run a report
Conditional formatting – Boolean variables
- Create the list report with following items
- A product line, Product type, Product name, Margin
- From a conditional explorer click on the variables
- From an insertable objects
- Drag a Boolean variable and drop it on a variable window
- Explain the following expression in an expression definition window
- Drag a margin from available components and drop in an expression window
- [Query1].[Margin]>0.3
- Validate – à OK
- From a page explorer – à Select page1
- Select any data item in a report
- From an ancestor select a list column body style
- From the properties pane
- Select a style variable property
- Click on the eclipses
- From a drop-down list box
- Select a Boolean1 variable- à Click on OK
- From the conditional explorer
- Select a Boolean variable – Yes
- From properties
- Set a font property—>Click on eclipses
- Set a font size and color
- From a condition explorer
- Select a Boolean variable as No
- From properties pane—>Select a font properties
- Set properties—> Turn off an explorer bar
- Save & Run a report

Conclusion
The user knows how to log in to the Cognos Analytics.The user has capabilities assignments necessary in a Cognos Analytics to use a report authoring.The user knows a name and location of package or data module that is available for them to the author and has adequate knowledge of this data source.