Reporting on a TM1 Cube with Report Studio

Reporting on a TM1 Cube with Report Studio

Postby Toto » Thu Jan 28, 2010 4:26 pm

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 28 times
Toto
 
Posts: 43
Joined: Mon Jul 20, 2009 8:52 am
OLAP Product: TM1
Version: 9.5 Build 9.5.00100.2380
Excel Version: 2003

Re: Reporting on a TM1 Cube with Report Studio

Postby MarioRubbo » Wed Feb 03, 2010 3:48 am

Did you publish the TM1 cube to C8 after specifying the levels?
MarioRubbo
 
Posts: 38
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

Postby rollo19 » Mon Feb 08, 2010 2:32 am

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 420 times


TM1 demo data source (members only):
TM1_showing_members_only.png
TM1_showing_members_only.png (18.66 KiB) Viewed 421 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 423 times
User avatar
rollo19
 
Posts: 52
Joined: Wed May 28, 2008 2:42 am
Location: Wellington, New Zealand
Version: 9.4.1
Excel Version: 2003

Re: Reporting on a TM1 Cube with Report Studio

Postby rollo19 » Mon Feb 08, 2010 3:24 am

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 413 times
User avatar
rollo19
 
Posts: 52
Joined: Wed May 28, 2008 2:42 am
Location: Wellington, New Zealand
Version: 9.4.1
Excel Version: 2003

Re: Reporting on a TM1 Cube with Report Studio

Postby ParisHilton » Wed Jul 14, 2010 8:49 am

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?
One Rule to Ring them all.


TM1 9.5 Cognos BI 8.4 Excel 2007. 63,9GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
ParisHilton
 
Posts: 28
Joined: Fri Apr 23, 2010 11:35 am
OLAP Product: Tm1
Version: 9.5
Excel Version: 2007


Return to Cognos Planning and BI

Who is online

Users browsing this forum: No registered users and 1 guest

Loading