If you are unable to create a new account, please email support@bspsoftware.com

 

Cognos report download shows data items that aren't on report page

Started by Salman, 30 Jun 2021 02:39:16 PM

Previous topic - Next topic

Salman

Hi! I've recently run into this weird problem; I have a report based on a query. There are 12 data elements in the query, but I am only selecting/dropping 10 our of those on the report page. So when I download the report, it shows all 12 data elements where it should only shows 10 data items that I selected on report page. It all started happening recently. Anyway to fix this problem? I'm using IBM Cognos Analytics 11.1 R2.

MFGF

Quote from: Salman on 30 Jun 2021 02:39:16 PM
Hi! I've recently run into this weird problem; I have a report based on a query. There are 12 data elements in the query, but I am only selecting/dropping 10 our of those on the report page. So when I download the report, it shows all 12 data elements where it should only shows 10 data items that I selected on report page. It all started happening recently. Anyway to fix this problem? I'm using IBM Cognos Analytics 11.1 R2.

Hi,

What exact rendering option are you using?

Cheers!

MF.
Meep!

dougp

Sounds like you're using the CSV output format.  That tends to ignore what is on the report page and outputs the results of the first query used on the page.  For example, I have a report that queries for basic header information (project number and title) to put in the page header, then runs a more complex query with lots of columns, most of which are used in the list.  When I run the report to CSV, I get the project number and title.

Salman

MF-- I am not using any rendering option specifically. I assume you're referring to Render Variable under Conditional? Pardon my ignorance, I'm new to Cognos.

Salman

Doug--You're partially right. However, even if I try to export the report as Excel/Excel Data, I do see those columns from the Query that I did not select on the Page.

MFGF

Quote from: Salman on 02 Jul 2021 09:09:08 AM
MF-- I am not using any rendering option specifically. I assume you're referring to Render Variable under Conditional? Pardon my ignorance, I'm new to Cognos.

Hi,

Sorry, no. I wasn't being clear - apologies. When you run a report, you have the option to choose different rendering or output options, eg HTML, PDF, Excel, Excel Data, CSV etc. Your original post said "...when I download the report..." but it didn't specify which of the different output formats the report was rendered as. As Doug alluded to above, some output types such as CSV and Excel Data show the contents of the first query in the report rather than the contents of the report page, whereas others such as HTML, PDF and Excel show the contents of the report page(s). I was just trying to get to the bottom of what option you chose.

Cheers!

MF.
Meep!

MFGF

Quote from: Salman on 02 Jul 2021 09:12:12 AM
Doug--You're partially right. However, even if I try to export the report as Excel/Excel Data, I do see those columns from the Query that I did not select on the Page.

Hi,

I would expect this with the Excel Data option, but definitely not with Excel. Can you double-check the Excel output option?

Cheers!

MF.
Meep!

Salman

I exported it out as Excel and that worked as intended; however, Excel out limits the total rows exported to 65,000 on page1, and then moves on to page 2 for the remaining data. That's not a deal breaker but very annoying.

MFGF

Quote from: Salman on 09 Jul 2021 08:30:45 AM
I exported it out as Excel and that worked as intended; however, Excel out limits the total rows exported to 65,000 on page1, and then moves on to page 2 for the remaining data. That's not a deal breaker but very annoying.

Hi,

That doesn't sound to me like a useable report - how many users are going to take the time to read through more than 65000 rows of output? What are you trying to achieve here? Are you trying to use Cognos as an ETL tool?

Cheers!

MF.
Meep!

Salman

Hi,

The report is actually a store level planning for around 1000 stores across the country so it goes well beyond 65,000 rows. We are not using Cognos as an ETL tool, but as a reporting tool for a linear report.

MFGF

Quote from: Salman on 13 Jul 2021 07:54:08 AM
Hi,

The report is actually a store level planning for around 1000 stores across the country so it goes well beyond 65,000 rows. We are not using Cognos as an ETL tool, but as a reporting tool for a linear report.

Understood. Did you see this tech note that details how to increase the Excel output limit in Cognos?

https://www.ibm.com/support/pages/excel-2007-output-exports-65536-rows-worksheet

Cheers!

MF.
Meep!