COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: megatrack67 on 20 Feb 2012 09:08:29 AM

Title: Problem getting report in exce 2007
Post by: megatrack67 on 20 Feb 2012 09:08:29 AM
we just upgraded from cognos 8.4.1 64 bit to cognos 10.1.1 64 bit

When running A report on C8 we have no issue getting the report in excel 2007 format
when doing the same thing in C10,
1. it takes longer
2. the report name is cognosisapi.dll
3. it is in read only

If you save the report it works fine
If you click on open it does not work

After a lot of testing we discovered that the source of the problem is the dns alias of our server (Which we are also using in C8)

If I configure our system with the server name or its IP address, everything is fine
As soon as we are using the alias excel 2007 does not work

Does anybody ran into that situation on dns alias and c10

Thank you for your help

Regards

Pc
Title: Re: Problem getting report in exce 2007
Post by: Grim on 21 Feb 2012 08:51:15 AM
Are you sure this is a DNS issue and not an Internet Exploder issue?
Does it do the same in Firefox?
Title: Re: Problem getting report in exce 2007
Post by: megatrack67 on 23 Feb 2012 01:32:51 PM
I found the problem
The cause was not microsoft nor IIS nor the DNS
The problem comes from the parameter temporary objects location
By default C8 uses content store but c10 uses server file system
as soon as I changed it everything worked properly
Title: Re: Problem getting report in exce 2007
Post by: Grim on 23 Feb 2012 02:16:15 PM
Quote from: megatrack67 on 23 Feb 2012 01:32:51 PM
I found the problem
The cause was not microsoft nor IIS nor the DNS
The problem comes from the parameter temporary objects location
By default C8 uses content store but c10 uses server file system
as soon as I changed it everything worked properly

Thanks for the follow up!

For the uninitiated, this is what mega is referring too.
http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cra.10.1.0.doc%2Fug_cra_id8029CMCacheLoad.html
Title: Re: Problem getting report in exce 2007
Post by: PRIT AMRIT on 24 Feb 2012 03:38:10 AM
Good piece of info Grim. Thanks for sharing this with us.