Reporting on a TM1 Cube with Report Studio

Post Reply
Toto
Posts: 71
Joined: Mon Jul 20, 2009 8:52 am
OLAP Product: TM1
Version: 9.5 Build 9.5.00100.2380
Excel Version: 2003

Reporting on a TM1 Cube with Report Studio

Post by Toto »

Hello,

I am trying to open a TM1-cube in Report Studio after publishing the cube in Framework Manager. When I open the cube I can not see the levels, although I have defined them in }HierarchyProperties and set up a TI-process where I execute the command: RefreshMDXHierarchy('Dimennsion'). Any idea what I may forgot?
Is there something I could have done wrong in }HierarchyProperties? Attached please see my definitions.

Thanks a lot,

Toto
Attachments
temp.doc
(223 KiB) Downloaded 598 times
MarioRubbo
Posts: 44
Joined: Wed Nov 04, 2009 3:50 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Reporting on a TM1 Cube with Report Studio

Post by MarioRubbo »

Did you publish the TM1 cube to C8 after specifying the levels?
User avatar
rollo19
Posts: 80
Joined: Wed May 28, 2008 2:42 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Perth, Australia

Re: Reporting on a TM1 Cube with Report Studio

Post by rollo19 »

Been having the same issue in Express 9.0

DMR example of what we are expecting (members & levels):
DMR_showing_levels.png
DMR_showing_levels.png (18.74 KiB) Viewed 10680 times
TM1 demo data source (members only):
TM1_showing_members_only.png
TM1_showing_members_only.png (18.66 KiB) Viewed 10681 times
Tried editing }HierarchyProperties cube

Used TI to RefreshMDXHierarchy('Products');
Saved & restarted server
Re-published FM package
Same result - no levels.
Attachments
Product_levels.png
Product_levels.png (8.39 KiB) Viewed 10683 times
User avatar
rollo19
Posts: 80
Joined: Wed May 28, 2008 2:42 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Perth, Australia

Re: Reporting on a TM1 Cube with Report Studio

Post by rollo19 »

hang on a mo - it does work!
I don't think you need to re-start the server either. Just be wary of the C8 refresh lag. I remember there is a parameter somewhere to change that.
Attachments
Levels_ex_TM1.png
Levels_ex_TM1.png (17.38 KiB) Viewed 10673 times
ParisHilton
Posts: 73
Joined: Fri Apr 23, 2010 11:35 am
OLAP Product: Tm1
Version: 9.5
Excel Version: 2007 2010

Re: Reporting on a TM1 Cube with Report Studio

Post by ParisHilton »

rollo19 wrote:hang on a mo - it does work!
I don't think you need to re-start the server either. Just be wary of the C8 refresh lag. I remember there is a parameter somewhere to change that.

I've been suspecting a lag existed , consolidations can take forever to show up in BI. Does anyone know where to find docs on this magic parameter?
“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.
RasMA
Posts: 1
Joined: Wed Sep 08, 2010 9:22 am
OLAP Product: TM1 and PowerPlay
Version: 9x and all
Excel Version: various

Re: Reporting on a TM1 Cube with Report Studio

Post by RasMA »

C8 caches the metadata when a package is accessed in the C8 Studios. Sometimes this can introduce a 'lag' in changes to cubes being visible. Try refreshing the rtm package cache.

Cheers,
-MA
babernat
Posts: 4
Joined: Wed Jan 05, 2011 4:14 pm
OLAP Product: TM1
Version: 9.4 9.5
Excel Version: 2003 2007
Location: Minneapolis, MN
Contact:

Re: Reporting on a TM1 Cube with Report Studio

Post by babernat »

I have experienced issues when I specify a specific dimension in the following code:

RefreshMDXHierarchy('Dim Name');

So.... I write is as follows and it works perfectly.

RefreshMDXHierarchy('');

Note: It will refresh for all dimensions.
merdal
Posts: 6
Joined: Sat Jun 26, 2010 2:07 pm
OLAP Product: Cognos Planning, TM1, BI
Version: 9.5.1 8.4.1
Excel Version: 2003 2007
Location: London, UK
Contact:

Re: Reporting on a TM1 Cube with Report Studio

Post by merdal »

When making any changes in TM1 model or data, to make sure to see the change in BI front end, and to make sure not to use cache, restart your browser and make sure your browser does not use cached objects from previous browsing sessions.
Post Reply