Can Perspectives and CAFE co-exist?

Post Reply
User avatar
Hippogriff
Posts: 48
Joined: Thu Nov 19, 2015 4:02 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2012

Can Perspectives and CAFE co-exist?

Post by Hippogriff »

Mornin' all,

I've done a bit of tinkering with Perspectives. I wanted to look at CAFE too. They're both plug-ins / add-ons for Excel... can they co-exist on the same machine, i.e. my laptop, which is also where my TM1 is.
--
Cheers, Hippo
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Can Perspectives and CAFE co-exist?

Post by mvaspal »

they can exist parallel indeed but if you want to use worksheet functions in CAFE you should not run Perspectives at the same time
If you only use crosstabs and flex views in CAFE then you can use both parallel

there is a separate xll in cafe for the worksheet functions, disable that if you want to run Perspectives parallel (sorry, do not remember the name, it should be documented somewhere in the CAFE doc)
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Can Perspectives and CAFE co-exist?

Post by mvaspal »

CognosOfficeTM1.xll
User avatar
Hippogriff
Posts: 48
Joined: Thu Nov 19, 2015 4:02 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2012

Re: Can Perspectives and CAFE co-exist?

Post by Hippogriff »

Thank you for that confirmation.
--
Cheers, Hippo
hittony
Posts: 71
Joined: Mon Apr 27, 2015 8:54 am
OLAP Product: TM1
Version: 10.2.2 FP6
Excel Version: 2010

Re: Can Perspectives and CAFE co-exist?

Post by hittony »

mvaspal wrote:they can exist parallel indeed but if you want to use worksheet functions in CAFE you should not run Perspectives at the same time
If you only use crosstabs and flex views in CAFE then you can use both parallel

there is a separate xll in cafe for the worksheet functions, disable that if you want to run Perspectives parallel (sorry, do not remember the name, it should be documented somewhere in the CAFE doc)
You can use Perspectives and CAFE in parallel, AND use worksheet functions, that's what my project is doing right now for almost 2 years.
But my understanding is if you configure CAFE by installing the xll file for using worksheets functions, then Perspectives is in conflict with CAFE as Excel add-ins.
I was just thinking about sparing some time to reproduce this conflict situation on pc ;)
dsproffitt
Posts: 66
Joined: Wed Jul 16, 2014 9:20 am
OLAP Product: All of them
Version: All of them
Excel Version: 2003 -2013

Re: Can Perspectives and CAFE co-exist?

Post by dsproffitt »

The way I run them is to have the Tm1 perspectives start menu item as a shortcut on my desktop and then the MS Excel short cut on there too.
So if I want CAfE, its the MS Excel shortcut (doesnt load Persp) and if I want Persp, then its the Persp shortcut which automatically loads the Persp add in, has the CAFE tab available, but not loaded until you click it and then the Cognos button in CAFE.

Does that answer the question?
Post Reply