Search found 46 matches

by Christian
Thu Dec 29, 2011 8:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Issue...}tp_everyone
Replies: 1
Views: 1708

Security Issue...}tp_everyone

Hi All, and Happy Holidays. I am on 9.5.2 and created a TI Process to load security to the }ElementSecurity control cubes for about 3 different large account dimensions. The access was simply "write" or none at all. This is so each department/group has access to only the accounts that conc...
by Christian
Thu Jul 22, 2010 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove chosen picklist during data entry
Replies: 4
Views: 5297

Re: Remove chosen picklist during data entry

I just ran into this one too. Hopefully, they will have a fix soon.
by Christian
Wed Mar 31, 2010 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on Security please...
Replies: 7
Views: 3762

Re: Help on Security please...

Thanks Guys, This is actually for views in TM1 Contributor v9.5 and is a budget application, not read-only reporting. I think the answer is, what I am used to, and pictured, can be done, but a little knowledge transfer to the users and subset creation in TM1 Contrib is going to be the path of least ...
by Christian
Tue Mar 30, 2010 11:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on Security please...
Replies: 7
Views: 3762

Re: Help on Security please...

What you can see as an admin is not so much relevant as what a user can see who has ONLY access to either dept 101 or 102 ... Right, but if a user has access to 4 departments, they open Dept 101, and there, they see ALL of the employees for their 4 departments, that's not going to fly. I guess I co...
by Christian
Tue Mar 30, 2010 11:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on Security please...
Replies: 7
Views: 3762

Help on Security please...

Hi All, TM1 9.5 and Contributor 9.5 I'm trying to restrict the employees that can be viewed by Department. I have gone to my Element Security control cube for this employee list. So far, in that cube, I have defined the employees in these two departments; those in 101 and those in 102. Since I have ...
by Christian
Tue Mar 16, 2010 8:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with importing Date please
Replies: 2
Views: 2143

Re: Help with importing Date please

Thanks for the information Alan.
by Christian
Tue Mar 16, 2010 7:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with importing Date please
Replies: 2
Views: 2143

Help with importing Date please

Hi All, TM1 9.5 My date field in excel is in format *3/10/2010. My attribute in TM1 is mm/dd/yyyy. The sample in Turbo Integrator shows up as 2009-01-01 00:00:00. When I run my process I get an error that it cannot convert to a real number. I have the variable for date set to numeric and data. I sea...
by Christian
Wed Mar 10, 2010 9:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can I write a feeder...
Replies: 4
Views: 2755

Re: Can I write a feeder...

Peter...I had what should have been two dimensions mixed in one; for example, Rent - Amount to be Allocated. There should have been a dimension with the element 'Rent', and another with the element 'Amount to be Allocated'. I had built this application for this client in Cognos Planning originally, ...
by Christian
Wed Mar 10, 2010 1:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can I write a feeder...
Replies: 4
Views: 2755

Re: Can I write a feeder...

Thank you Peter. I really appreciate your feedback. I'll give them a shot in the morning.

Take care,
Christian
by Christian
Tue Mar 09, 2010 6:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can I write a feeder...
Replies: 4
Views: 2755

Can I write a feeder...

using the DB/ATTRS functionality in this formula/rule? Formula: [{‘Acct 1’, ‘Acct 2’, ‘Acct 3’……’Acct 100’} ] = DB('G&A Expense Calc', !Version, !Department, !Country, !Month, !Portfolio, ATTRS('G&A Expense Calc', !G&A Expense Calc, 'Attrb 1')) * DB('G&A Expense C...
by Christian
Fri Mar 05, 2010 7:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on feeder please...
Replies: 8
Views: 5340

Re: Help on feeder please...

Peter...you did it!!!!

Thank you so much!
by Christian
Fri Mar 05, 2010 7:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on feeder please...
Replies: 8
Views: 5340

Re: Help on feeder please...

Sorry for the confusion. The dimension name is 'G&A Expense Calc', not 'G&A Allocations'. I was trying to stick with my description in the first post. Below are the dimensions and the order they were assigned (I didn't assign the order originally) G&A Input Cube G&A Expense Calc Cube...
by Christian
Fri Mar 05, 2010 7:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on feeder please...
Replies: 8
Views: 5340

Re: Help on feeder please...

Thanks Pat...that was a typo, sorry about that. I'm still getting this invalid string error. I don't get it, I wrote several similar feeders yesterday.
by Christian
Fri Mar 05, 2010 6:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on feeder please...
Replies: 8
Views: 5340

Re: Help on feeder please...

Hmm..I tried that John and it's still not working. I even tried to do a simple one to one feeder and I'm getting the same error message. [{'701000 - Bank Service Charges']=> DB('G&A Allocations', !Version, !Department, !Country, !Month, !Portfolio, ‘Total – 701000 – Bank Service Charges’...
by Christian
Fri Mar 05, 2010 6:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on feeder please...
Replies: 8
Views: 5340

Help on feeder please...

Hi, all, Happy Friday. TM1 9.5 I keep getting an invalid string expression error on a feeder I'm trying to write. I have a G&A Input cube, and a G&A Allocation cube. I have a rule that brings in the values from the G&A Input cube into the G&A Allocation cube where the expenses are......
by Christian
Wed Mar 03, 2010 4:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with rule please...
Replies: 8
Views: 4719

Re: Help with rule please...

Thanks Michel...I got it to work!
by Christian
Tue Mar 02, 2010 9:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with rule please...
Replies: 8
Views: 4719

Re: Help with rule please...

Michel, The Total Office Equipment is a leaf level element in the Depreciation Allocation (target cube), so you are correct. There is a minor difference in the dimensionality, but should not have any impact. I'll explain in more detail, but you don't have to read unless you want. Portfolio! is a dim...
by Christian
Tue Mar 02, 2010 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with rule please...
Replies: 8
Views: 4719

Re: Help with rule please...

I need to write a rule like this for about 10 asset types...the logic seems to make sense to me, I just can't get TM1 to agree.
by Christian
Tue Mar 02, 2010 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with rule please...
Replies: 8
Views: 4719

Re: Help with rule please...

Hmm...it says invalid string expression. The rule now reads... ['Total Office Equipment' ] =N: IF (DB('Capex', !Version, !Department, !Country, !Month, !Portfolio TBD, !Capital Exp, 'Asset Type Cumul') @= 'Office Equipment', DB('Capex', !Version, !Department, !Country, !Month, !Portfolio TBD, !Capit...
by Christian
Tue Mar 02, 2010 8:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with rule please...
Replies: 8
Views: 4719

Re: Help with rule please...

Correct...I'll give that a shot Michel. Thanks mon ami.