Home  >  Blog  >   IBM Cognos  > 

How to SetUp Data Formats: Numbers, strings, dates in Cognos

Rating: 5
  
 
6783

Data Formats:

You can format data so that it matches any pattern of text and numbers when default formats are not appropriate. For example, you can format dates to use full text, including the era, or you can format them to only use numbers and show the last two digits of years to save space.
Using symbols and patterns can provide similar results as basic data formatting tasks. Patterns allow flexibility for more complex requirements.

Each supported content language code requires a specific set of symbols to be used in patterns. For each language code, there are two tables you will need; one for date and time symbols, and one for decimal symbols.

Formatting data in a report improves readability.

 MindMajix YouTube Channel

Data Formatting Properties

In the reports we can format numbers, strings, dates, currency and percentage (Different objects)

The following is a list of properties available in the data formatting dialog.

  • Maximum No. of Digits
  • Minimum No. of Digits
  • No. of Decimal Places
  • Date Ordering
  • Date Separator
  • Date Style
  • Currency
  • Currency Display
  • Currency Symbol
  • Currency Symbol Position
  • Percentage Symbol
  • Percent Scale
Learn how to use Cognos, from beginner basics to advanced techniques. Enroll for Free Cognos Training Demo!

Procedure:

  • Create a list report using the following query items
  • Order number
  • Order date
  • Product name
  • Quantity
  • Revenue
  • Select order date data cell
  • In the properties window
  • Under data
  • Select data format
  • Click on eclipse
  • Select the format type – select date
  • Set following properties – select – Date style – Medium
  • From Date separator select – Date ordering – Day, Month, Year
  • Click on OK–  Save & Run the report

HTTP://IBM.CO/1Q8CTOJ

Frequently Asked Cognos Interview Questions & Answers

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
IBM Cognos TrainingSep 27 to Oct 12
IBM Cognos TrainingOct 01 to Oct 16
IBM Cognos TrainingOct 04 to Oct 19
IBM Cognos TrainingOct 08 to Oct 23
Last updated: 25 September 2022
About Author
Ravindra Savaram

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

Recommended Courses

1 /15