TM1 Subsets in Report Studio

Post Reply
ParisHilton
Posts: 73
Joined: Fri Apr 23, 2010 11:35 am
OLAP Product: Tm1
Version: 9.5
Excel Version: 2007 2010

TM1 Subsets in Report Studio

Post by ParisHilton »

Adding to the increasingly popular topic of TM1 with report studio, is there any way to expose a subset defined in TM1 to a report?
(ie can we make a subset 'draggable' from the hierarchy viewer into a report).
“The way I see it, you should live everyday like its your birthday”


TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
MarioRubbo
Posts: 44
Joined: Wed Nov 04, 2009 3:50 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: TM1 Subsets in Report Studio

Post by MarioRubbo »

C8 BI does not currently see any TM1 Subsets or Views. The next release is supposedly going to be friendlier to TM1. You have to recreate those subsets in C8
ParisHilton
Posts: 73
Joined: Fri Apr 23, 2010 11:35 am
OLAP Product: Tm1
Version: 9.5
Excel Version: 2007 2010

Re: TM1 Subsets in Report Studio

Post by ParisHilton »

MarioRubbo wrote:C8 BI does not currently see any TM1 Subsets or Views. The next release is supposedly going to be friendlier to TM1. You have to recreate those subsets in C8

Does anyone know if Cognos 10 can see TM1 subsets?
“The way I see it, you should live everyday like its your birthday”


TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
User avatar
Mike Cowie
Site Admin
Posts: 482
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: IBM TM1/PA, SSAS, and more
Version: Anything thru 11.x
Excel Version: 2003 - Office 365
Location: Alabama, USA
Contact:

Re: TM1 Subsets in Report Studio

Post by Mike Cowie »

It doesn't look like any of the 10.1 studios can yet see TM1-created Views and Subsets. You do have the option of TM1 Web and Executive Viewer portlets, though, which obviously do support your existing TM1 Views and Subsets. But, I realize that's not quite the same thing as being able to select an existing TM1 View or Subset in Analysis Studio, Business Insight, etc.
Mike Cowie
QueBIT Consulting, LLC

Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
dfrench77
Posts: 52
Joined: Thu Feb 17, 2011 2:52 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: TM1 Subsets in Report Studio

Post by dfrench77 »

MarioRubbo wrote: You have to recreate those subsets in C8
Has anyone posted how to recreate the TM1 subsets and views in the Cognos 8 or 10 Studios?
MarioRubbo
Posts: 44
Joined: Wed Nov 04, 2009 3:50 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: TM1 Subsets in Report Studio

Post by MarioRubbo »

You have to use one of the Studio tools in BI to create the sets. There is no simple set of steps to list out because there are many different kinds of sets that can be created using various methods in TM1 and BI. As far as Views go, you would create reports in BI that mimic the rows/columns/and filters that you have defined in TM1. Again, that is a big topic and not simply summarized in forum post.
Post Reply