TM1 Forum

I would approach this as follows: Workings cube dimensioned by Budget Detail Categorie Frais Lignes and the 'unit' dimension you have on the page In this cube, a rule on the lines of [''Montant Detail'] = n: if( DB('<source cube>,'Categorie',!Unit,!Lignes) @= !Categorie Frais, DB('<source cube>,'Mon...

Should work - I can think of many times I have used it in the past.
You could try making the formula DBSW - this is meant to be more efficient when you are sending lots of data.

Paul, I can't offer serious expertise on this (I'd probably be asking you :) ) but yes, the TM1 Excel addin does seem to do Wans very poorly. Of the options you have been offered Terminal Services sounds the best. Citrix is better, but WTS is really Citrix Lite. Get the ITers to say how many Excel u...

I'm working with a client who is redeveloping a TM1 system, moving from 8.4.5 to 90SP3U9. They have started experiencing some odd situations where the attributes have shifted around internally - the oddest one was where the formats started appearing in a text attribute. I've seen the results of this...

I'd have thought that playing around with the techniques in this link would help, however, sadly, the NUMBERTOSTRINGEX which allows you to get at weekdays etc is a TI-only command, so a pure rules approach is probably not on. (Waits patiently for 'Oh yes it is' from the stalls :) ) http://forums.ola...

Interesting question. I am working with a client at the moment where we built some cubes with dimension names which on reflection the client team weren't happy with. I asked for a document setting out the changes, and then did the following: a In the file system, copied the xx cub file to xx_old.cub...

Martin, I agree. But Joe Puztai, giving a Best Practices session, left me a pretty firm impression that you could do this. One of his BP mantras was 'always have an extra measure dimension, put it last, you can put text in but you can still resequence'. I've been applying that (and most other BP ide...

Just tried it out on 9.0SP3U9 and yes, if there are string elements in the last dimension you can't resequence it. Time to drop Joe P a line, methinks, or to raise an SR.

I don't believe there is any difference since (as you say) attributes are held in a (string) cube anyway. My own approach is to have a cube if the lookup is multidimensional, and an attribute otherwise.

They would be (excluded). Unfed numbers fall out of zero suppression.
par3, you might try sending the result from a view directly to the destination rather than via a file. Don't think it'll work round the issue (probably) but would be neater.

Hmmmm....
I was in one of Joe Puztai's Best Practices sessions a few years ago and I do believe he made a flat statement appropos of having an extra measure dim in all cubes, where text could go, that it was fine because you could reorder later.
What version/bitness were you using? May need an SR.

To avoid DLL complexities, I recommend copying TM1TOP.EXE _to_ the bin directory, then it'll pick up what it needs.

First, some assumptions/inferences from what you write: a You have separate year and month dimensions b The value against (eg) BS Mar is the _movement_ for the month Based on that, I suggest the following: a Create a 'sawtooth' hierarchy for YTD as Feb YTD = Jan YTD + BS Feb Mar YTD = Feb YTD + BS M...

First of all - what a very impressive set of documentation and explanation for a problem. You have a future role training my customers in how to do this! On your query - my initial suspicion focused on the fact that the attribute you use is the same in the rule as in the feeder. Normally if you have...

Depends on your version. For 9.1, there was dynamic slices, which did that, but wasn't amazingly stable. For 9.4, there is (now) Active Forms, which does that. It's quite new though and we don't (yet) recommend it for production use.

That's a very old version. I'm not sure it's even supported on W2K.

Why don't you upgrade to Version 9? That would be (I would suggest) 9.0SP3U9. This is normally pretty smooth. Of course there may be other reasons you are having stability issues - are you running out of memory, for instance?

Also Performance Monitor, to see how many users are on and who has performance issues hitting which cubes.

It'll be the current month to YTD feeders in the SAP interface - they are pretty hard to manage down.
Your memory pressure will be text data going to Unicode.
See you (and Shami) at the Dickens for Martin F's birthday drinkies.

Ken.... Your numbers for startup size make me think you _might_ be comparing 32 and 64 bit. Is that possible? 9.4 MR1 is out very soon. We have a client which has to go 9.4 as they have moved to XL2007. MR1 fixes a couple of issues they hit. But.... Unless you _have_ to have 9.4, I would say 9.0SP3U...

I've heard rumours about the charge for extra servers going away - only rumours though. My concern with that is how very poor the server to server communication is - and don't mention replication, it's very much 'all or nothing' (and has not always been that stable). What we need is the ability to p...