Hi All,
I'm trying to get IBM Cognos Analysis for Microsoft Excel installed and noted in the install guide that one of the components required is "IBM Cognos Business Intelligence server components"
Anyone know what these components are? If we only have licence for TM1, does that mean CAFE can't be installed on our Client machines?
Installation of CAFE
-
RJ!
- Community Contributor
- Posts: 219
- Joined: Mon Jul 23, 2012 8:31 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Installation of CAFE
Nevermind, resolved 
-
Alan Kirk
- Site Admin
- Posts: 6647
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Installation of CAFE
Don't keep us in suspense, what was the resolution? (The fact that you didn't get an answer suggests that it's not something that anyone encountered before.)RJ! wrote:Nevermind, resolved
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
declanr
- MVP
- Posts: 1828
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Installation of CAFE
What version are you using? I'm not a fan of café as such haven't done much more than basic playing about but I'm sure I got it running just by installing next to a basic TM1 install... memory may be clouded though.
Declan Rodger
-
RJ!
- Community Contributor
- Posts: 219
- Joined: Mon Jul 23, 2012 8:31 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Installation of CAFE
As far as I know we only installed the components that came with CAFE & were able to get it up & running. No need for additional Cognos BI related files at all.
Interesting thing that I did find that wasn't aware of before is that CAFE can still be used to refresh Perpectives formulas such as DBR, DBRW, DBRA, SUBNM and VIEW.
(From here: http://www-01.ibm.com/support/knowledge ... tions.html
http://www-01.ibm.com/support/knowledge ... tions.html
Out of interest, has anyone got this to work?
From our point of view, CAFE is going to be really useful as we have support teams offshore that are currently connecting via Citrix & Remote Access to local desktops to get any chance of decent performance.
Note that we use TM1 as a Financials Database & have not really mandated any real "standardisation" in Users templates & reports. This has created it's own set of headaches but I think that using CAFE will get the Accountants to start using "Explorations" to extract their data in a more logical way & then use vlookup, Index/Match or Sumif the data back into their reports. hopefully leading to easier reports to audit. No matter how much we "educate" users, we still get the odd 1 or 2 that like to deleted the VIEW formula from their huge sheets & then moan about performance all the while locking up the server while it calculates!
Interesting thing that I did find that wasn't aware of before is that CAFE can still be used to refresh Perpectives formulas such as DBR, DBRW, DBRA, SUBNM and VIEW.
(From here: http://www-01.ibm.com/support/knowledge ... tions.html
From what I've read you need this file updated to point to your Server:Support for a Subset of TM1 Excel functions
If you only use DBR, DBRW, DBRA, SUBNM and VIEW TM1 functions in your Excel reports and do not use Active Forms, then CAFÉ will be able to refresh existing TM1 Excel reports for you. You can’t use CAFÉ in this way while TM1 Perspectives is loaded; instead, you must load a separate CAFÉ XLL add-in before it can refresh these functions for you. Once loaded, even double-clicking on SUBNM cells will bring up CAFÉ’s subset editor. This presents a great opportunity to reach TM1 users with your existing TM1 Excel reports who, due to poor network connections with the TM1 Server, cannot otherwise work efficiently with TM1.
http://www-01.ibm.com/support/knowledge ... tions.html
Out of interest, has anyone got this to work?
From our point of view, CAFE is going to be really useful as we have support teams offshore that are currently connecting via Citrix & Remote Access to local desktops to get any chance of decent performance.
Note that we use TM1 as a Financials Database & have not really mandated any real "standardisation" in Users templates & reports. This has created it's own set of headaches but I think that using CAFE will get the Accountants to start using "Explorations" to extract their data in a more logical way & then use vlookup, Index/Match or Sumif the data back into their reports. hopefully leading to easier reports to audit. No matter how much we "educate" users, we still get the odd 1 or 2 that like to deleted the VIEW formula from their huge sheets & then moan about performance all the while locking up the server while it calculates!