Search found 2824 matches

by tomok
Tue May 10, 2011 4:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Formatting Error
Replies: 10
Views: 5791

Re: Formatting Error

You should never have elements in a dimension where spaces are important to the system design. This is because as far as TM1 is concerned, spaces do no exist. What I mean by this is the elements: No Specific I_2016_P01 NoSpecificI_2016_P01 both resolve to the same thing. These may look like two diff...
by tomok
Tue May 10, 2011 1:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: how to load file dynamically with dynamic column order
Replies: 3
Views: 2905

Re: how to load file dynamically with dynamic column order

The only way I know of would be to have each column named generically in the TI and then in the file have a first record for each column that indicates what is in the column. Create a variable in the Prolog tab for each column. Then in the DATA tab you could keep a record count and if this is the fi...
by tomok
Tue May 10, 2011 12:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Occured While Adding Group
Replies: 4
Views: 3338

Re: Error Occured While Adding Group

There is also a maximum number of groups that can be added between server refreshes. The default is 20. You may need to change this (the parameter is GroupsCreationLimit) in the TM1S.CFG file and restart.
by tomok
Thu May 05, 2011 12:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web picklist
Replies: 4
Views: 3651

Re: TM1 Web picklist

Do you have any hidden columns in the Excel sheet? Hidden columns often throw off the column alignment when opened in TM1Web. Unhide them and/or move them out just to the right of your report range.
by tomok
Wed May 04, 2011 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculation Hierarchy on the fly ?
Replies: 15
Views: 9242

Re: Calculation Hierarchy on the fly ?

Hello, I would like to know if there is a way to activate calculation on the fly with hierarchical dimension. For example I would like the consolidated element be calculated according to the filtered element from a subset. The short answer is no. A subset is merely a collection of elements from a d...
by tomok
Tue May 03, 2011 1:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Number of users
Replies: 22
Views: 16211

Re: Number of users

In a highly dense cube you are better off leaving out the SKIPCHECK statement. This way you don't have to worry about missing a feeder and no memory will be consumed by feeders. Granted a feeder only takes a single bit of RAM but it can add up. It's rather easy to test. Fire up your server with SKIP...
by tomok
Tue May 03, 2011 1:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Map excel data to dimension attribute
Replies: 7
Views: 3888

Re: Map excel data to dimension attribute

I would question why you feel the need to "map" the annual salary data to a cube that has a time dimension including all the months in the first place. If the annual salary does not change then why include the months in the time dimension? You only need months if the salary may change duri...
by tomok
Sun May 01, 2011 8:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can't access TM1 server via Internet !
Replies: 2
Views: 2244

Re: Can't access TM1 server via Internet !

Why would you expect that you could use the machine_name reference to find a server over the internet? To locate a machine over the internet you have to use a name that resolves to an actual internet IP address. Inside your network that reference may very well resolve to an internal IP address but i...
by tomok
Thu Apr 28, 2011 4:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Number of users
Replies: 22
Views: 16211

Re: Number of users

The official IBM answer is 100 users for a quad core machine but I have found that to be a little unrealistic unless those are all READ users pulling minimal reports and views. If you have performance issues then IBM will recommend you get rid of all your rules and do things with TI processes, in ef...
by tomok
Thu Apr 28, 2011 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Internal Rules Using DB
Replies: 10
Views: 6682

Re: Internal Rules Using DB

I may be wrong but I seem to remember an Applix person telling me years ago that the DB() and [] syntax was treated the same by the compiler, once the syntax of the rule was verified. Made perfect sense to me.
by tomok
Thu Apr 28, 2011 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Number of users
Replies: 22
Views: 16211

Re: Number of users

I know that you can set the threading to be multiple threads but only of you don't have conditional feeders. That's only for server startup. I'm sure the OP is talking about the user experience AFTER the system is available. As previously mentioned, the number of users that can effectively function...
by tomok
Thu Apr 28, 2011 2:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to refresh subsets
Replies: 5
Views: 3646

Re: Unable to refresh subsets

pradeep.k.jagadeesan wrote:SubsetDestroy(bookOfBusDimName, subsetName)
You can't destroy a subset if it is actively used in a view. if you want to destory the subset you will have to destroy all views that use it first. Of course this means you'll have to rebuild all the views after you are done rebuilding the subset.
by tomok
Tue Apr 26, 2011 11:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic List of Dimension Elements in Spreadsheet
Replies: 18
Views: 11320

Re: Dynamic List of Dimension Elements in Spreadsheet

The other is to generate just the lists that you need via VBA. Whenever I use these "data validation lists" I always use a subset (no coincidence that the formula used is SUBNM) so I do my best to cull the list down inside TM1 so I am not attempting to create a drop-down of the entire dim...
by tomok
Tue Apr 26, 2011 7:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic List of Dimension Elements in Spreadsheet
Replies: 18
Views: 11320

Re: Dynamic List of Dimension Elements in Spreadsheet

My goal is to populate a ComboBox and then use the spreadsheet over the TM1Web . A combo-box object from the VBA toolkit will not work. The only drop-down type object that works in TM1Web for 9.4, at least that I am aware of, is going to be data validation where you specify a range that holds a lis...
by tomok
Tue Apr 26, 2011 6:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Possessed TM1 Service!
Replies: 5
Views: 3680

Re: Possessed TM1 Service!

It should be easy enough to tell if the service is still running on the box you claim it is running on. Go to Task Mananger on that box and go to the Services tab. Make sure it is set to look at all the services running, not just those running under the ID you are logged in as. Look for TM1S.exe. If...
by tomok
Tue Apr 26, 2011 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 API Access to Log Files
Replies: 2
Views: 2220

Re: TM1 API Access to Log Files

Have some TM1 API experience and more yrs coding than I'd like to admit. Trying to use the API to create a custom logging utility. No problem listing servers, cubes, and dims. Having issues trying to get TM1ServerLogOpen and TM1ServerLogNext working. Specifically, which function(s) do you use to pu...
by tomok
Tue Apr 26, 2011 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic List of Dimension Elements in Spreadsheet
Replies: 18
Views: 11320

Re: Dynamic List of Dimension Elements in Spreadsheet

I know others on this site like VBA but my advice to you is don't use it. If you do then you can forget about ever using the report in TM1Web. Why overly complicate something that is quite easy using lotsaram's suggestion. All you do is create a hidden tab for all your lists and have a series of thr...
by tomok
Wed Apr 20, 2011 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Automated Report Generation Tools/Processes
Replies: 8
Views: 8726

Re: TM1 Automated Report Generation Tools/Processes

If your different reports are essentially different views, why do you have a separate Excel sheet for each user. Why not put logic in the Excel sheet that dynamically picks the correct subsets for each dimensjon, based on user, so that you can have just one template? You can build a two-dmensional l...
by tomok
Wed Apr 20, 2011 11:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Budget Variance - Two formulas ?
Replies: 5
Views: 7375

Re: Budget Variance - Two formulas ?

If the chart of accounts has numbering logic, which most seem to do (like assets starting with "1". etc., then I like to use an attribute called "Account_Type" and then use a rule on the attribute cube like: ['Account_Type'] = S: IF(SUBST(Account!,1)='1','A', IF(SUBST(Account!,1)...
by tomok
Tue Apr 19, 2011 5:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form Losing named Ranges
Replies: 5
Views: 6047

Re: Active Form Losing named Ranges

Time to sleep on it I think.David There's nothing to sleep on. Whenever you "rebuild" an active form report, the rows inside the report area are deleted and re-added. If you were to reference some of those cells somewhere else in the report you'll end up with a bunch of #REF formulas afte...