TM1 Forum

Sorry for bumping an old post.

I get this message if I have rebuilt a dimension whilst the cube viewer is open.
Cheers,

When you have a view as a data source TM1 has to construct the whole view in memory before it starts to read it into a new area. If you have a large source view alot of the time can be taken while TM1 constructs this view in memory. What I've done before is to break the view up into smaller bits, as...

Probably the easiest way is to us dimension worksheets 1. Right click on each dimension and select export as ASCII 2. Open the .cma files, you will see that the information is in dimension worksheet format. 3. Create the new dimension (TM1, Dimension worksheet, new) 4. Copy and paste both sets of in...

Hi Vish, Have you tried to set it up as per the documentation yet? It's relatively straight forward to set-up, though in practice it requires a lot of work to look after and get working optimally. It's a pretty big area to expect chapter and verse on in a forum environment, have you got a specific i...

William,
In the scenario you describe I would definitely say this is a bug and I'd raise with IBM.
Cheers

Must've been late when you wrote that Steve. You can never type into a consolidation for a numeric cell. I'm seem to be using this icon alot at the moment :oops: , maybe the beef eating is catching up with me... I know there was something wrong with it when I was writing it, I thought it was just a...

Hi Par3,

I'd raise with IBM or your VAR ASAP, without sitting in front of the box, I've exhausted my suggestions....

Just to double check as it looks wrong, I'm no API expert....

Is the line you highlight in red supposed to have the "=" twice or is that happening when you post the code?
Edit : See Mike's comment below... this is correct

The short answer is yes but without knowing alot more about your system I would not recommend it.

If you put

[]=C: stet;

At the beginning (after skipcheck) of your rule sheet then all C levels will become input, you will probably have a nasty slow running cube though.

HTH

Hmm If you had a file with exactly 1 record in it and no end of file record then I suppose you could use I_Process to read it into a spreadsheet, since I_Process imports 1 line at a time. If you have a column of messages to read in then you could use I_Names. In practice though it's often more strai...

Hi Harry, Sounds like a possible bug to me too, though I would be surprised if security was this broken in 9.4 MR1 that it had not been raised on the forum yet as it has been out quite a while now. If you are just on the server explorer logged in with your test user is the security still broken or d...

Just thought I'd put this out there for people as it's just tripped me up as I have spent a while debugging VBA trying to understand why a division was always producing an integer result. Through force of habit of writing TM1 rules using the "\" to suppress divide by zero I'd written apply...

Hi Faizal, I'm not exactly what you wan to do but if you want to launch something from TM1 that either writes data from Access into TM1 or writes data from TM1 into Access then you need to use ODBC / SQL and TI. If you want to do either of the above but launched from Access then you probably would n...

Sorry all further fix in the TM1 only macro that allows for formula with no opening bracket "(" that was causing the macro to fail. (Like = server &"Management Information")

Small update as I had not changed the tool bar to reference the new macro, so both icons were running the same macro, doh! Thanks to Martin for pointing this out!

I'm pretty sure that you need to use SQL to read from Access since it is a reltaional DB not a OLAP DB.

To do this you need an ODBC conection to the Access DB and then put your access query as the data source on the first page of a TI.

HTH a bit!

Hey does anyone know how to turn all the sound off for Excel or Office so I can listen to tunes without a KERCHANG everytime excel wants me too know that it wants someting?

I've done a bit of googling can't find anything.

Cheers

Hi par3, Sounds pretty scary! Did this happen in your test upgrade? What's the problem? Are the log ins being refused or is the server not visible in the server explorer? If the server is not visible then 1.Check that the server is actually running by looking in the services of the 64 bit box! 2.Dou...

Not sure if this is a duplicate of the above but below is link to a page that gives all the face ids for the icons you can put in tool bars, although they have been taken from outlook I think it's all valid for Excel too.

http://www.outlookexchange.com/articles ... KIcons.asp

Version 0.2a Added a new sub to clear only TM1 formula from all sheets in the workbook. If anyone else wants to add useful TM1 type utilities to the tool bar feel free to add to the code, would be nice to have our own little toolbar. Something that needs doing is to add the script that puts the tool...