Sorry for bumping an old post.
I get this message if I have rebuilt a dimension whilst the cube viewer is open.
Cheers,
Search found 1850 matches
- Mon May 11, 2009 8:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error Message
- Replies: 2
- Views: 2343
- Thu Apr 30, 2009 2:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advice on Copying Large Identical Data?
- Replies: 3
- Views: 2769
Re: Advice on Copying Large Identical Data?
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...
- Wed Apr 29, 2009 7:03 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Combining dimensions
- Replies: 3
- Views: 2706
Re: Combining dimensions
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...
- Thu Apr 23, 2009 4:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Replication ?
- Replies: 11
- Views: 6692
Re: TM1 Replication ?
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...
- Thu Apr 23, 2009 3:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Securtity Rights not working in Excel tables
- Replies: 17
- Views: 15928
Re: Securtity Rights not working in Excel tables
William,
In the scenario you describe I would definitely say this is a bug and I'd raise with IBM.
Cheers
In the scenario you describe I would definitely say this is a bug and I'd raise with IBM.
Cheers
- Thu Apr 23, 2009 12:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: put value in consolidated cells
- Replies: 9
- Views: 6024
Re: put value in consolidated cells
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...
- Thu Apr 23, 2009 11:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 9.1 SP4 Not connecting to Server
- Replies: 12
- Views: 7757
Re: 9.1 SP4 Not connecting to Server
Hi Par3,
I'd raise with IBM or your VAR ASAP, without sitting in front of the box, I've exhausted my suggestions....
I'd raise with IBM or your VAR ASAP, without sitting in front of the box, I've exhausted my suggestions....
- Wed Apr 22, 2009 2:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need help with the error message "SystemParameterTypeInvalid
- Replies: 7
- Views: 6359
Re: Need help with the error message "SystemParameterTypeInvalid
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
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
- Wed Apr 22, 2009 1:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: put value in consolidated cells
- Replies: 9
- Views: 6024
Re: put value in consolidated cells
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
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
- Tue Apr 21, 2009 10:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: I_PROCESS
- Replies: 2
- Views: 2344
Re: I_PROCESS
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...
- Tue Apr 21, 2009 10:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Securtity Rights not working in Excel tables
- Replies: 17
- Views: 15928
Re: Securtity Rights not working in Excel tables
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...
- Tue Apr 21, 2009 10:49 am
- Forum: Useful code, tips and tricks
- Topic: VBA Operators \ and /
- Replies: 0
- Views: 3887
VBA Operators \ and /
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...
- Tue Apr 21, 2009 6:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 mdx to MS Access
- Replies: 4
- Views: 3468
Re: TM1 mdx to MS Access
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...
- Mon Apr 20, 2009 2:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Tools Issues And Discussions (Was *KEY_ERR Tracer)
- Replies: 63
- Views: 43181
Re: *KEY_ERR Tracer
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")
- Mon Apr 20, 2009 11:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Tools Issues And Discussions (Was *KEY_ERR Tracer)
- Replies: 63
- Views: 43181
Re: *KEY_ERR Tracer
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!
- Mon Apr 20, 2009 8:12 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 mdx to MS Access
- Replies: 4
- Views: 3468
Re: TM1 mdx to MS Access
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!
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!
- Fri Apr 17, 2009 4:53 pm
- Forum: General
- Topic: Sound in Excel.
- Replies: 1
- Views: 3991
Sound in Excel.
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
I've done a bit of googling can't find anything.
Cheers
- Fri Apr 17, 2009 3:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 9.1 SP4 Not connecting to Server
- Replies: 12
- Views: 7757
Re: 9.1 SP4 Not connecting to Server
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...
- Fri Apr 17, 2009 8:36 am
- Forum: Useful code, tips and tricks
- Topic: Useful Excel links
- Replies: 9
- Views: 12598
Re: Useful Excel links
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
http://www.outlookexchange.com/articles ... KIcons.asp
- Fri Apr 17, 2009 8:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Tools Issues And Discussions (Was *KEY_ERR Tracer)
- Replies: 63
- Views: 43181
Re: *KEY_ERR Tracer
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...