Migrating Perspectives Reports to CAFÉ - experience?

Post Reply
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Migrating Perspectives Reports to CAFÉ - experience?

Post by stephen waters »

We are talking to a customer who is interested in migrating their onpremise TM1 to TM1 SaaS. (btw nothing to do with TM1 just their strategy is to close existing outsourced data centre and move everything to cloud!)

Under the SaaS model, the majority of users will access TM1 using either CAFÉ or TM1 web and their preference is to maintain an Excel interface ( ie CAFÉ) rather than web. They have existing Perspectives reports which we think are based on standard slices and are not very complex (subject to review).
I believe the only TM1\Excel functions supported under CAFÉ are DBR, DBRW, DBRA, SUBNM, VIEW and DBSW ( subject to checking)

We have done some limited internal testing opening existing Perspectives reports with CAFÉ (TM1 10.2.2 FP3) and this seems to work OK. I just wondered if anyone else has experience of doing this in a production scenario and, if so, can you share your experiences?
alimurat
Posts: 18
Joined: Mon Sep 14, 2009 4:04 pm
OLAP Product: TM1
Version: 10 2 2 FP3
Excel Version: 2010

Re: Migrating Perspectives Reports to CAFÉ - experience?

Post by alimurat »

Pretty straight forward, if you're only migrating slices.
Supported functions with FP3
DBS
DBSA
DBSS
DBSW
DBR
DBRA
DBRW
DFRST
DIMIX
DIMNM
DIMSIZ
DNEXT
DNLEV
DTYPE
ELCOMP
ELCOMPN
ELISCOMP
ELISPAR
ELLEV
ELPAR
ELPARN
ELSLEN
ELWEIGHT
SUBNM
SUBSIZ
TABDIM
TM1USER
RJ!
Community Contributor
Posts: 219
Joined: Mon Jul 23, 2012 8:31 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Migrating Perspectives Reports to CAFÉ - experience?

Post by RJ! »

Just be careful with DBRA, it can be a bit flakey, we've noticed that it doesn't always work, though a DBRW on the Attribute Cube works fine.
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Migrating Perspectives Reports to CAFÉ - experience?

Post by gtonkin »

Off on a slight tangent Stephen, but please could you consider posting some of your experiences with deploying TM1 on the Cloud.
I posted some notes but am still looking for some answers, especially around timelines and costs and how "overage" is measured and billed. Thank you.
RJ!
Community Contributor
Posts: 219
Joined: Mon Jul 23, 2012 8:31 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Migrating Perspectives Reports to CAFÉ - experience?

Post by RJ! »

FYI - If you are using DBRA in CAFE, it seems it only likes the native (?) element, if you use any alias it returns blank.
(This is using 10.2.2 FP6)
Post Reply