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

Author Topic: Cogons CUBE in EXCEL 2007  (Read 16988 times)

ozzloz

  • Guest
Cogons CUBE in EXCEL 2007
« on: 03 Jul 2009 04:02:47 am »
Hello,
       I am trying to plug an Excel pivot table directly into a Cognos cube (mdc file), I haven't managed to get Excel to recognize the Cube as an OLAP source. Does anybody know if it is possible to do what I am attempting to do and if so which drivers I need to download. I am using Cognos 8.3 and Excel 2007.

Thank You

Offline DustPanMan

  • Community Leader
  • *****
  • Join Date: Aug 2005
  • Posts: 138
  • Forum Citizenship: +8/-0
    • COGNOiSe.com
Re: Cogons CUBE in EXCEL 2007
« Reply #1 on: 06 Jul 2009 10:12:17 am »
You'll need to install Cognos Office (it's an add-in for Cognos, and it is free).  You can then use the Cognos Office tool to access your Cubes directly in any Office tool (PowerPoint, Excel, etc).
Best,

D

ozzloz

  • Guest
Re: Cogons CUBE in EXCEL 2007
« Reply #2 on: 20 Aug 2009 05:15:50 am »
Hi,

Thanks for your help, I've been busy on other projects and I've only just got round to trying your suggestion.
I have installed Cognos Go Office and I can extract data from repots into excel and from reports buit on cubes. However I haven't been able to use the pivot table function of excel directly  on to my OLAP cube (generated with transformer). Do you know if there is a way of doing that?

Thanks,

Offline DustPanMan

  • Community Leader
  • *****
  • Join Date: Aug 2005
  • Posts: 138
  • Forum Citizenship: +8/-0
    • COGNOiSe.com
Re: Cogons CUBE in EXCEL 2007
« Reply #3 on: 21 Sep 2009 12:34:00 pm »
Ozz,

There is a tool called Cognos Analysis for Excel (CAFE).  It allows you to build the equivalent of Pivot Tables on steriods within Excel.  Give me a call if you want to discuss pricing for this solution - Dustin - 423-331-2277 or email me at dadkison@brightstarpartners.com

Best regards,

Dustin
Best,

D

arijitgh

  • Guest
Re: Cogons CUBE in EXCEL 2007
« Reply #4 on: 25 Jul 2012 11:13:38 am »
Hi all,
This is an interesting topic.
« Last Edit: 25 Jul 2012 11:16:10 am by arijitgh »

arijitgh

  • Guest
Re: Cogons CUBE in EXCEL 2007
« Reply #5 on: 25 Jul 2012 11:14:56 am »
Hi,

Thanks for your help, I've been busy on other projects and I've only just got round to trying your suggestion.
I have installed Cognos Go Office and I can extract data from repots into excel and from reports buit on cubes. However I haven't been able to use the pivot table function of excel directly  on to my OLAP cube (generated with transformer). Do you know if there is a way of doing that?

Thanks,



Hi,
Could you please share the download link from where you got the Cognos Office software. Thanks in advance.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,544
  • Forum Citizenship: +673/-10
  • Cognos Software Muppet
Re: Cogons CUBE in EXCEL 2007
« Reply #6 on: 25 Jul 2012 11:28:43 am »
http://www-01.ibm.com/software/howtobuy/passportadvantage/pao_customers.htm

You will need to sign in with your IBM Customer Number (ICN).

Regards,

MF.
Meep!