TM1 Forum

Yes, that is how they are determined: self-selected interested parties. I was a respondent in the OLAP survey for three years running, but since I retired I am not among the 39 this year. Nigel seems to have been very favorably impressed by TM1, and talked it up quite a bit. He more or less threw in...

The BI Survey is the re-branded successor to The OLAP Report , which you may remember from days of yore. It was quoted several times in the old Applix Forum that was the progenitor of this one. I don't think anyone here shelled out for a full copy when it cost "only" $3-3.5k(USD) either, b...

Unless they screw up the early releases, shared data and write-through will follow on later. I would be very surprised to see it get stuck in the well-understood "spreadsheet hell" trap. While the idea of running a substantial BPM/planning application on the Microsoft stack makes my skin c...

I agree about typical Excel users. Sometimes I think they would need help tying their shoes were it not for the invention of Velcro. I am thinking of "power users" who are only a fraction of all users but are still legion. When I show TM1 to Excel power users the majority take to it like f...

Surprise: having panicked the whole industry into precipitous consolidation, it turns out that PerformancePoint was just a boogeyman. The consolidation has accelerated certain industry trends and virtually cemented an important outcome. Just as Microsoft has ceded large financial analytical applicat...

One of my New Year's resolutions for 2009 is to reduce my internet watchlist by 75%. Olapedia did not make the cut, for obvious reasons: (1) it is no longer active, having no new articles since July, and (2) since none of the administrators are policing it, spammers are turning it into a link farm. ...

One way to consistently produce this error in Excel 2000 (and earlier) is to mix Excel "forms" objects and Excel ActiveX "controls" objects in the same application. It can also cause multiple instances of the TM1 menu item to appear (with or without label). Stick with one or the ...

If the remote user and the host are not running the same windows version then shared resources like the clipboard can be a little dodgy, but otherwise I have found TS completely satisfactory for TM1 versions 6.0 through 9.0.

The picture is of the version 2 box, which was used for releases 2.0 through 2.5.F.

"To run TM/1 Perspectives, your computer must be equipped with a hard drive!"

jim wood wrote:What was the orginal point of this post again!!!???!!!???!!!

Social networking. Really.

For Eric, Mike L, Mike C and others, that would be 01/03/09. <shakes head> Why can't thing be standard across the pond? I mean come on; dates, spanners, football! Seriously! On this side of the pond we take pride in being cranks. So great is our dedication the principle that if everybody agreed on ...

Since you ask, yes, I do have thoughts on this. I have had several conversations on the underlying issue, ranging from dry academic discussion to pounding-on-the-table argument with IT folk. Bottom line: There is no substitute for a job control process that takes job status into account. Relying on ...

Nothing like a little beta testing to reveal issues with unanticipated usages.

If the rules are working but the results fail to consolidate then you may need
['Total income'] = ConsolidateChildren('gl account');

Another possible source of confusion is that in some OLAP products, particularly ROLAP, a "cube" is not so much a tangible data object as it is a logical view of the data, much like a stored view in MS SQL. My advice to Damien is this: What you are trying to do is a common, even elementary...

Curiously, the ancients know better. In olden days of v6.0 queries and views were two different things. lumping them together was a poor idea. Browser views and process queries may work the same way, but they are so not the same thing.

To elaborate on data mining a little, note that the term is sometimes used with a more specific meaning these days. TM1 is well suited to the kind of user-directed data mining that Alan describes, and this has long been one of its main attractions. The term (particularly "data mining algorithm&...

anote, If, as in your sample data, each Name has at most one Item per Company (i.e. Company+Name is a normalized key in the source) then the Item dimension serves no real purpose. It would just be a report line number in a particular view. If, on the other hand, one Name might appear multiple times ...

I have used both Sage (a.k.a. Best) MAS90 and MAS500. With MAS90 we did exactly what you describe: manually kick off reports with output to text file. Even though we had a lot of customization done in MAS90 by someone who knew the internals, we never had a workaround for this. (This was back in the ...

What if the consolidatechildren had to work such that it consolidates different children or range of children depending on the SKU? So for SKU1 it consolidates children 1..3, SKU2 it consolidates children 1..20. Can this be achieved with this function? No. In the target area on the left you can spe...