With the API you can determine if a rule is attached to a cell but not in TI.
Is this a theoretical question or have you come up against this and have an actual need to do this in a process, what are you trying to do?
Search found 3506 matches
- Sat Jul 03, 2010 8:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Distinguish Between Consolidations and Calcs at C: Level
- Replies: 2
- Views: 1895
- Fri Jul 02, 2010 8:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Corrupted dimension?
- Replies: 3
- Views: 3224
Re: Corrupted dimension?
The "$" objects (.cub$, .dim$) represent temporary objects created during a save. During normal server operations and while the server is not running these files should not be there. If the server is down, delete them prior to restarting.
- Wed Jun 30, 2010 1:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web - launch process
- Replies: 3
- Views: 2402
Re: TM1 Web - launch process
Probably because in TM1 Web there is a separate interface for processes which is the only area that processes can be run from in TM1 web.
In the Navigation Tree view pane, under "Administration" you will see "Processes"
In the Navigation Tree view pane, under "Administration" you will see "Processes"
- Wed Jun 30, 2010 12:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Refreshing feeders
- Replies: 7
- Views: 6569
Re: Refreshing feeders
Post your offending feeder so that others can have a chance to look at it to see what is wrong. Don't forget that feeders work only at leaf level. ['Total'] => means feed from each and every N level descendant of 'Total' that contains data => ['Total'] means feed each and every N level descendant of...
- Wed Jun 30, 2010 12:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: No read access to element, cannot view
- Replies: 13
- Views: 9501
Re: No read access to element, cannot view
True.
Why did no one else think of that? Nice tip Peter
Why did no one else think of that? Nice tip Peter
- Wed Jun 30, 2010 11:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: No read access to element, cannot view
- Replies: 13
- Views: 9501
Re: No read access to element, cannot view
If you have enough views to make it worthwhile you could reassign subsets and elements via code in TI or with API code. If you are talking about manually editing the .vue files I don't see how this is any easier than manually recreating views. If you do want to do this then yes it should be possible...
- Wed Jun 30, 2010 11:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA TM1RECALC Problem
- Replies: 6
- Views: 13100
Re: VBA TM1RECALC Problem
What are you actually doing in your application? If you are using TM1 correctly then there should be no need to have worksheets referencing each other as each worksheet can be "independent" in an Excel sense and just reference the cube(s).
Just a thought ...
Just a thought ...
- Tue Jun 29, 2010 8:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA TM1RECALC Problem
- Replies: 6
- Views: 13100
Re: VBA TM1RECALC Problem
Hi Helen, Consider using code tags. For what you want to do I think your code is unnecessarily complex as there is no need to loop through workbooks and worksheets. Application.Run "TM1RECALC1" calculates the active worksheet only (same as user hitting SHIFT + F9, this is the macro that ru...
- Tue Jun 29, 2010 12:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Date calculation in a dimension.
- Replies: 1
- Views: 1556
Re: Date calculation in a dimension.
This is quite a straightforward requirement. Have you read the Date and Time Rules Functions section of the TM1 Reference manual?
- Tue Jun 29, 2010 11:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can TM1 work for 50000 users? 500 concurrent users?
- Replies: 12
- Views: 8693
Re: Can TM1 work for 50000 users? 500 concurrent users?
I have seen that you have posted this question on numerous forums with not a great deal of takers. In terms of data volume TM1 certainly is scalable, certainly more so than any other MOLAP cubing architecture. For number of users it is not the user count that matters but the number of concurrent use...
- Sun Jun 27, 2010 12:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel formatting of TM1 reports.
- Replies: 2
- Views: 2020
Re: Excel formatting of TM1 reports.
Presently we're generating reports in the user-required layout in this mechanism - a) We decide which view of the required cube would give us the data for the report - by rearranging the dimensions according to the report. b) We take a slice of the report which has the raw data - on to an excel she...
- Fri Jun 25, 2010 12:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Upgrading Custom Web Pages
- Replies: 1
- Views: 1602
Re: Upgrading Custom Web Pages
additional manual work when upgrading is always going to be a pitfall of customising ...
Do you really need to do it?
Do you really need to do it?
- Tue Jun 22, 2010 11:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: parallel 2 TI process
- Replies: 17
- Views: 13301
Re: parallel 2 TI process
As of 9.4 chores can be scheduled simultaneously and will run concurrently as opposed to queuing. (Provided of course that the chores contain independent processes updating independent cubes). You can also run multiple processes by calling externally via a 3rd party app such as TM1ProcessExecute.exe...
- Tue Jun 22, 2010 11:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Open ODBC Connections
- Replies: 3
- Views: 2838
Re: Open ODBC Connections
Likewise I have only ever seen ODBC connections stay open if a process aborts. If the process completes successfully or with minor errors then the connection should close. If a process aborting is causing your problem then adding ODBCClose to the Epilog won't do anything since the Epilog code won't ...
- Tue Jun 22, 2010 10:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Display a character '-' instead of a number for the consolat
- Replies: 6
- Views: 3568
Re: Display a character '-' instead of a number for the cons
Depending on your delivery mechanism it is relatively easy with number formatting to make 0 appear as "-"
- Mon Jun 21, 2010 6:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Name of Processes in Turbo
- Replies: 13
- Views: 7363
Re: Name of Processes in Turbo
i undestand that this function exist onli in version 9.5? It appears so. There doesn't seem to be any reference to it in the release notes (what a surprise :roll: ), but doing a search through my document library shows it only in the 9.5 Reference .pdfs, not in those of any earlier version. You cou...
- Thu Jun 17, 2010 11:42 pm
- Forum: Enhancements
- Topic: Multi-threaded data save
- Replies: 5
- Views: 8533
Re: Multi-threaded data save
The bottleneck in saving is the disk subsystem, at least on my system, so adding compute capacity will not improve performance. Duh - Oh, Houston we have a problem. Poor old hard disk head can only do so many things, should have thought of that. Hmm maybe another take on things would be to enable a...
- Wed Jun 16, 2010 11:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Scheduled Chores That Fail
- Replies: 9
- Views: 4430
Re: Scheduled Chores That Fail
I second Alan's interpretation both in that chores do not do "catch ups" if an execution is missed due to server downtime then the next run time is the next scheduled time. Also property 530 is the first scheduled run of a chore, it is never updated (unless the chore is rescheduled in the ...
- Wed Jun 16, 2010 10:51 am
- Forum: Enhancements
- Topic: Multi-threaded data save
- Replies: 5
- Views: 8533
Re: Multi-threaded data save
Yes multi-threaded server loading is for data only. Metadata is single threaded. But no I was also talking about data loading no just server loading. This is getting off topic of the enhancement to enable multi-threaded data saves but in 9.4 and 9.5 at least it is very easy to do multi-threaded data...
- Tue Jun 15, 2010 10:16 pm
- Forum: Enhancements
- Topic: Multi-threaded data save
- Replies: 5
- Views: 8533
Multi-threaded data save
We have had multi-threaded server loading for some time now and can now also multi-thread data loads. Together with 64 bit servers this has facilitated a huge expansion with the volume of data TM1 can handle. However this all comes unstuck when a data save is executed following batch updates. As the...