Author Topic: downloading report output using Excel issue  (Read 517 times)

Offline priya@90

  • Full Member
  • ***
  • Join Date: Jan 2016
  • Posts: 35
  • Forum Citizenship: +0/-0
downloading report output using Excel issue
« on: 08 Aug 2017 08:06:31 am »
Hello Friends,

While downloading report output in excel 2007 it's taking lot of time to get download(5 to 6mins) and when i run in HTML it's just taking less than a minute. what could be reasons? Any idea's

i am using crosstab which is having 30 Rows and 11columns including nested columns, no filters(filters had done in ETl section), no prompts, no complex calculations. I have used reportoutput function also but not giving any difference. Please share any idea's.

Thanks,
Priya

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 9,866
  • Forum Citizenship: +597/-9
  • Cognos Software Muppet
Re: downloading report output using Excel issue
« Reply #1 on: 08 Aug 2017 10:34:32 am »
Hello Friends,

While downloading report output in excel 2007 it's taking lot of time to get download(5 to 6mins) and when i run in HTML it's just taking less than a minute. what could be reasons? Any idea's

i am using crosstab which is having 30 Rows and 11columns including nested columns, no filters(filters had done in ETl section), no prompts, no complex calculations. I have used reportoutput function also but not giving any difference. Please share any idea's.

Thanks,
Priya

Are you sure you're not just seeing the first page when rendering as HTML? What happens if you render as PDF - is it slow like Excel?

MF.
Meep!

Offline priya@90

  • Full Member
  • ***
  • Join Date: Jan 2016
  • Posts: 35
  • Forum Citizenship: +0/-0
Re: downloading report output using Excel issue
« Reply #2 on: 09 Aug 2017 02:16:59 am »
I can see fast output when go to 2nd page in HTML, with the HTML no performance issues and even though PDF is also like Excel, it's taking lot of time to download in PDF, iam trying to download the data using Development server only(limited data)

Thanks,

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 9,866
  • Forum Citizenship: +597/-9
  • Cognos Software Muppet
Re: downloading report output using Excel issue
« Reply #3 on: 09 Aug 2017 02:39:27 am »
I can see fast output when go to 2nd page in HTML, with the HTML no performance issues and even though PDF is also like Excel, it's taking lot of time to download in PDF, iam trying to download the data using Development server only(limited data)

Thanks,

Hi,

So what you're saying is HTML interactive rendering is fast, and Excel / PDF interactive rendering is slow? This is as you'd expect. For a description of why, please see FAQ #2 in the FAQs post:

http://www.cognoise.com/index.php/topic,27563.0.html

Cheers!

MF.
Meep!

Offline priya@90

  • Full Member
  • ***
  • Join Date: Jan 2016
  • Posts: 35
  • Forum Citizenship: +0/-0
Re: downloading report output using Excel issue
« Reply #4 on: 09 Aug 2017 05:24:32 am »
Hello MF,

Thanks for your help and time.
When you set run option as 0 it will retrieve all the rows in one page and this is also not giving any problem to me, it's giving very fast data, no more pages HTML output looks like in single page. It's not about rendering page's, something is wrong while importing into Excel. I am trying to re-develop the report let's see whether i can able to find the solution or not.

Thanks,

Offline priya@90

  • Full Member
  • ***
  • Join Date: Jan 2016
  • Posts: 35
  • Forum Citizenship: +0/-0
Re: downloading report output using Excel issue
« Reply #5 on: 10 Aug 2017 01:16:06 am »
Hi,

i got the issue crosstab space is giving me the problem, i have used in rows to add text for each data item so when i removed that crosstab space it's extracting very fast into excel. if i try to add it's taking time to extract. What i should i do to add text for my crosstab rows.

Offline New_Guy

  • Statesman
  • ******
  • Join Date: Mar 2016
  • Posts: 287
  • Forum Citizenship: +15/-0
Re: downloading report output using Excel issue
« Reply #6 on: 10 Aug 2017 05:44:46 am »
Hi,
You can use a table in the crosstab row node by unlocking it, with 2 rows and 1 column and place a text above or below the node member text as per the requirement.
Good luck
New guy

Offline priya@90

  • Full Member
  • ***
  • Join Date: Jan 2016
  • Posts: 35
  • Forum Citizenship: +0/-0
Re: downloading report output using Excel issue
« Reply #7 on: 11 Aug 2017 01:40:04 am »
Hi,
Thanks for your response. Whatever you said might not get the correct result, i already tried and it's giving the output like EMP 10 in first row and 2nd row EMP 20, 3rd row EMP 30 etc... this is not good Header should be EMP no only once should show and also i tried in crosstab corner to add table and it's also a same problem like crosstab space. Any idea's pls

Thanks,
Priya

Offline New_Guy

  • Statesman
  • ******
  • Join Date: Mar 2016
  • Posts: 287
  • Forum Citizenship: +15/-0
Re: downloading report output using Excel issue
« Reply #8 on: 11 Aug 2017 06:57:25 am »
Hi,
You can render the table based on the row node's memberCaption or you can try conditional style and box out the table cell. Try it and it should work.
Good luck
New guy

Offline priya@90

  • Full Member
  • ***
  • Join Date: Jan 2016
  • Posts: 35
  • Forum Citizenship: +0/-0
Re: downloading report output using Excel issue
« Reply #9 on: 11 Aug 2017 07:24:18 am »
Hi New_guy,

Thanks for your suggestions and time. i got it using the below link i tried and it's working as expected.

http://www-01.ibm.com/support/docview.wss?uid=swg21613574

Thanks,
Priya

 


       
Twittear