Search found 4 matches

by babernat
Thu Jan 06, 2011 3:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Incorrect Display of Hierarchies in BI from TM1
Replies: 6
Views: 5788

Re: Incorrect Display of Hierarchies in BI from TM1

I have attempted rerunning RefreshMDXHierarchy and this hasn't resolved the issue.

Thanks for the response.
by babernat
Wed Jan 05, 2011 5:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Incorrect Display of Hierarchies in BI from TM1
Replies: 6
Views: 5788

Incorrect Display of Hierarchies in BI from TM1

Any help would be greatly appreciated on the following problem: Please see attached to see the problem I am experiencing. As a summary, I have established hierarchy properties for a time dimension as follows: All Periods = Level000 Years = Level001 Quarters = Level002 Month = Level003 In Report Stud...
by babernat
Wed Jan 05, 2011 4:51 pm
Forum: Cognos Planning and BI
Topic: Reporting on a TM1 Cube with Report Studio
Replies: 7
Views: 14188

Re: Reporting on a TM1 Cube with Report Studio

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.
by babernat
Wed Jan 05, 2011 4:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express and multiple hierarchies
Replies: 8
Views: 8987

Re: Cognos Express and multiple hierarchies

Have you considered naming your hierarchies as such: For dim Report Period, Hierarchy0: level000 = Total Year level001 = Current Month level002 = Actual Again not sure if it will solve your problem, but that is how I currently use }HierarchyProperties cube. I have also leveraged the technique sugges...