How to Create multiple pages from one in Cafe.

Post Reply
tshaw202
Posts: 1
Joined: Mon Mar 10, 2014 9:19 pm
OLAP Product: TM1
Version: 10.2
Excel Version: Office 2010

How to Create multiple pages from one in Cafe.

Post by tshaw202 »

I have recently converted from Cognos Planning to TM1 10.2. One feature that I used extensively with Planning was the excel add-in feature whereby I could link to a cube and then create a formatted report tab in excel and from there make multiple pages from the original with the batch function.

I have begun to use Café and can link to the TM1 cubes however I cannot find any documentation on how to create multiple pages from an element listing. Is there a process or procedure or technique that I can do same in Café?

Thanks
tom
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

Re: How to Create multiple pages from one in Cafe.

Post by stephen waters »

I dont know about CAFÉ ( it is pretty new to TM1) but, if I understand you correctly, you can do this via the traditional Perspectives add-in and the "Print Report" Option. This will cycle round a dimension list , eg cost centre, producing a report for each, which can be either separate workbooks or tabs in the same workbook. You can snapshot or pdf the output.

You will also find that Perspectives and TM1 web will give you much better control over formatting than CAFÉ for both reporting and input. CAFÉ will perform better over the web than Perspectives, not sure how it compares with the latest TM1 Web.
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: How to Create multiple pages from one in Cafe.

Post by mvaspal »

Hi
Has anyone found a solution for this in CAFE?

Thanks
Post Reply