Search found 9 matches

by paulfelce
Tue Jan 18, 2011 1:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMENSIONCOMPONENTADD
Replies: 7
Views: 5106

Re: DIMENSIONCOMPONENTADD

Thanks for all your input. Alan's screenshot shows what I'm trying to achieve. What I don't understand though is why TM1 will sometimes yield that structure, but with the months repeated at the bottom of the dimension. I'll have to look into subsets and see if it's something to do with that. Annoyin...
by paulfelce
Mon Jan 17, 2011 1:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMENSIONCOMPONENTADD
Replies: 7
Views: 5106

DIMENSIONCOMPONENTADD

Arrgh, please help... This should be a nice easy one for experienced TM1ers. In a TI load process if I want to create a dimension of, for example time, that looks like this (it could be any dimension, it’s not a nasty time related one, but the structure is obvious!) 2005 Jan 2005 Feb 2005 Mar 2005...
by paulfelce
Fri Apr 23, 2010 9:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1ChoreExecute
Replies: 18
Views: 19058

Re: TM1ChoreExecute

The TM1sip.dll doesn't seem to be on my installation, either the 32 bit dev, nor the 64 bit production.
by paulfelce
Thu Apr 22, 2010 3:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MS Reporting Services with TM1
Replies: 11
Views: 13204

Re: MS Reporting Services with TM1

We have been able to integrate TM1 with Sharepoint in a real-time Reporting environment - including the use of parameterised dropdowns to drive MDX statements for self-service reporting (no intermediary data-storage/data-hosting point is required). The integration was reasonably tricky to set up wi...
by paulfelce
Wed Apr 21, 2010 12:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MS Reporting Services with TM1
Replies: 11
Views: 13204

Re: MS Reporting Services with TM1

Paul, if you are working in a Microsoft environment, why are you using TM1 for pure reporting? For Reporting you can use Analysis Services alone. Politics I suppose IBM will not invest much effort in the Reporting Services connection because there is Cognos Connection , Report Studio, Analysis Stud...
by paulfelce
Wed Apr 21, 2010 8:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MS Reporting Services with TM1
Replies: 11
Views: 13204

Re: MS Reporting Services with TM1

This is something I am really keen to do to. George, are you having success in exporting data from a TM1 cube into analysis services and then reporting from AS? Does this method involve an etl process and a lag between the data in AS and and TM1? In this case would you be tempted to not use TM1 and ...
by paulfelce
Sat Apr 17, 2010 8:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: consolidation multiplication
Replies: 23
Views: 18378

Re: consolidation multiplication

There are a few ideas for averages here and here . You can use the search feature to find some more posts as this is not an uncommon problem. HTH, Martin Thanks Martin, I've got it working. Scott W's post was really helpful, especially the side comment about why we need the ghost to prevent a circu...
by paulfelce
Fri Apr 16, 2010 10:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating TM1 Objects in C# and ASP.NET
Replies: 20
Views: 153835

Re: Creating TM1 Objects in C# and ASP.NET

TM1 heavy lifting, with silverlight front end sexiness. A match made in heaven.
by paulfelce
Fri Apr 16, 2010 10:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: consolidation multiplication
Replies: 23
Views: 18378

Re: consolidation multiplication

I am trying to achieve something similar, except instead of multiplying the elements, I want to calculate an average. The problem seems so simple that I'm sure I must be missing something. I've been staring at it for a few hours now and my head hurts. My position is more along the lines of..... I've...