Stack Overflow
Stack Overflow

Questions tagged [cognos-8]

Cognos Version 8 is a reporting tool from IBM used widely for Business Intelligence.

Any question related to Report Studio, Query Studio, Analysis Studio, Metric Studio, Metric Designer, Event Studio, Framework Manager, PowerPlay Studio and Analytic Applications in Cognos 8 and above. Cognos is IBM's business intelligence (BI) and performance management software suite. The software is designed to enable business users without technical knowledge to extract corporate data, analyze it and assemble reports.

About Cognos Cognos is composed of nearly three dozen software products. Because Cognos is built on open standards, the software products can be used with relational and multidimensional data sources from multiple vendors, including Microsoft, NCR Teradata, SAP and Oracle.

The Cognos 8 BI suite, which was first introduced in 2005, is IBM’s leading performance management software. Cognos 8 BI’s capabilities include reporting, analysis, dashboarding and scorecards, delivered through a web-based service-oriented architecture (SOA).

In October 2010, IBM released Cognos 10, which integrates Cogos with other IBM products, including SPSS Predictive Analytics and Lotus Connect. Cognos 10 comes with mobile capability, allowing users to access a complete version of Cognos from mobile devices such as tablets and smartphones.

IBM also offers Cognos Express, which is designed for small to mid-sized companies. The Express edition allows companies to utilize the functions of Cognos 8 BI, while also adding planning, budgeting, and forecasting functions.

IBM’s Cognos products are used by over 23,000 companies around the world, and are consistently ranked in the “leaders” category of Gartner Magic Quadrants for Business Intelligence.

149 questions
5
votes
5 answers

differences between "Cognos TM1 and "Cognos 10 BI

What the differences between "Cognos TM1" and "Cognos 10 BI"? Which one is consider as BI Tools by IBM?
user975828
  • 147
  • 1
  • 2
  • 10
4
votes
1 answer

read into R data frame from cognos 8 file (utf 16) with readr

I am attempting to read csv files generated by cognos 8 into r using readr. Example file attached for reproducibility: Example csv file The following python code works: df = pd.read_table('csv_test.csv', encoding = 'utf-16') I've tried the…
d.ellis
  • 61
  • 6
4
votes
1 answer

Cognos equivalent of excel's sumif() function

I'm familiar with Excel and SQL, but new to Cognos. I'm doing a conditional sum on [Total Margin] for each [Item Code]. This result should show on each row for the each item. I've tried 2 approaches in Cognos and a proof of concept in Excel. See…
Fractional
  • 153
  • 1
  • 2
  • 10
3
votes
2 answers

Cognos 8 Query to find all Report and Column Names

I want to query the meta data in Cognos 8 to find all report and column names. If possible, I'd like to include the column definitions. Can I do this using a Cognos report or do I need to query some repository? Thanks.
jabs
  • 1,694
  • 4
  • 19
  • 36
3
votes
2 answers

Multi-select in the prompt is not working properly in Cognos 8.1

Changing a value prompt to a multi-select value prompt in Report studio, provide single select functionality. How can i get multi-select functionality?
Hanane
2
votes
1 answer

Cognos 8.4.1 / TFS Integration

My team uses TFS 2010 for source control, build, etc. for all of our .NET and Java projects, and we would like to do the same for our Cognos reports. Today we have to export the Cognos reports from the development environment into an XML file,…
Scott Ewers
  • 664
  • 3
  • 5
2
votes
1 answer

Need help building a Data Item in Cognos Report Studio

So I have a table with employee name, job and shift. Each employee (Row) has a unique name, a non unique job and one of 4 shifts (A, B, ,C or D). I want to create a Data Item called "Shift A Employees" that that for each job it spits out one…
Isaiah Beets
  • 23
  • 2
2
votes
1 answer

Dynamically adding pages in cognos reports

I have a requirement to fulfill where i have to fetch data from the data source.. In that the number of pages in a report might vary due to the number of times the customer has purchased. Basically Customer Number is the primary Key and based on the…
Raghu
  • 817
  • 1
  • 7
  • 21
2
votes
2 answers

Dynamic SQL versus using the model

We started using COGNOS about 3 years ago. We have used COGNOS 8 and are now on COGNOS 10. We are constantly being told that using dynamic SQL queries instead of using the COGNOS model is extremely bad in that it causes performance issues and that…
Mark
  • 135
  • 2
  • 14
2
votes
3 answers

Automatic filter for current month and year in Cognos Report Studio ver 10

I have a query item which filters records by a date column which is in format 'YYYYMM'. As of now I have hard coded the value [DateCol] = '201406' in Detail filters to get the current month and year records. But I want to dynamically have this value…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
2
votes
1 answer

SDK to extract the contents of the Cognos Web Page

Currently I'm working in Cognos v10.1.2 . Is there any SDK to extract the contents of the Cognos Web Page? We are developing a monitoring window for the end users where they can view the status of their report instead of mails and calls. The…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
2
votes
2 answers

Is it Possible to Change the Report Page Name Dynamically based on the Prompt Value in Cognos?

Currently I'm working in Cognos v10.1.2 . I do have a requirement that the report page name (The worksheet name of the report's excel output) should dynamically change based on the prompt value selected. How could we achieve this in Cognos. Thanks…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
2
votes
2 answers

Can Bursting the Cognos 8 Report Studio Report reduce the server load instead running them manually 200 times a day?

My Cognos 8 Server is already slow as it is handling a number of Jobs which is used to Burst thousands of Report Studio Reports a day. Moreover, In the same server users are manually generating a particular report around 200 times a day. My Question…
Robin Agrahari
  • 807
  • 3
  • 11
  • 24
2
votes
2 answers

Can I add empty lines to Cognos list report?

The customer wants to show empty line between each two lines with data in a list report,just like the following image.I want to know how can I achieve this in report studio? I know I can add empty data in the back, but it is not a good idea, because…
Tom
  • 2,857
  • 9
  • 46
  • 59
2
votes
3 answers

Report Studio template

I am trying to schedule 10 reports that go to the same table and ask for the same columns, except that they differ in a key value (i.e. the report selects column a, b, c from table A but differ in the where clause = 'CLIENT1', = 'CLIENT2', etc). I…
TheMadCapLaughs27
  • 346
  • 3
  • 18
1
2 3
…
9 10