Search found 12 matches

by dumbomichael
Tue Sep 11, 2012 9:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express and Server 2008 R2
Replies: 6
Views: 5795

Re: Cognos Express and Server 2008 R2

has there been a solution to this? we have the same problem on a brand new server with cognoss express version 10.1.0
by dumbomichael
Thu Sep 06, 2012 11:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: can I make a rule to lock a cell
Replies: 2
Views: 3379

Re: can I make a rule to lock a cell

hi

sorry, it was a silly mistake on my part. i put it in the cell security cube and it's fine. i did the test on it when it was in then data cube. rookie mistake. thanks for your help
by dumbomichael
Thu Sep 06, 2012 11:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automation Error when loading TM1p.xla
Replies: 18
Views: 27047

Re: Automation Error when loading TM1p.xla

this is what we did on our pc's. might be an easier solution. Click Start, Run Type the following in: regsvr32 /u C:\Windows\System32\mscomctl.ocx click ok to run it then click start, run type the following in: regsvr32 C:\Windows\System32\mscomctl.ocx click ok to run it When you open Excel, this er...
by dumbomichael
Thu Sep 06, 2012 11:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: can I make a rule to lock a cell
Replies: 2
Views: 3379

can I make a rule to lock a cell

hi Guys i have a drop down box with a list of options the user can choose on aa active form. i would like the cell to be locked if they choose 'appointment'. ie. they can select any option they want and change it, but if they select appointment, they cannot write back any information to that cell on...
by dumbomichael
Thu Aug 16, 2012 8:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automation Error when loading TM1p.xla
Replies: 18
Views: 27047

Re: Automation Error when loading TM1p.xla

turns out it was an excel update from microsoft that caused the issue. the it department downloaded a fix and have corrected everyone's computer
by dumbomichael
Thu Aug 16, 2012 8:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automation Error when loading TM1p.xla
Replies: 18
Views: 27047

Re: Automation Error when loading TM1p.xla

hi Guys we have this error too. it started on one of our pc's yesterday, and has now spread to four in the office. i have tried all of the above suggestions, as well as deleting and reinstalling tm1, but still the error is present. the only one i havent tried is The Automation error might relate to ...
by dumbomichael
Mon Aug 06, 2012 10:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: changing a dimension in an active form
Replies: 1
Views: 1935

changing a dimension in an active form

Hi guys i have an active form that a user(call her user 1) works on to update contact information of clients. once this is updated she allocated to a salesman. each salesman will then be able to log on and see the clients allocated to them and contact them, and if need be, update contact information...
by dumbomichael
Wed Jun 27, 2012 10:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: combining dimentions into a cube
Replies: 3
Views: 2476

Re: combining dimentions into a cube

That isn't the way TM1 works. For most cubes, where you are reporting data, you are always going to have a lot of zero values. Some cubes which have only a few dimensions - two, or perhaps three - are sometimes completely full of data. However, this happens rarely for reporting and happens mainly f...
by dumbomichael
Wed Jun 27, 2012 7:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: combining dimentions into a cube
Replies: 3
Views: 2476

combining dimentions into a cube

hi Guys i am new to TM1 and am struggling to do the following task: i have an existing cube with various dimentions, including clients and departments. when we run cognos on this cube to do reporting, it firsts runs through all the data, and then suppresses the zeros. this causes the cognos server t...
by dumbomichael
Fri Jun 01, 2012 7:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: client groups
Replies: 7
Views: 5427

Re: client groups

hi guys

Thanks for your assistance. There was a rule written in the past that was that was associated with the groups, and is no longer used and was never deleted. i have now deleted it and it seems the problem has gone. thanks for your assistance, it is greatly appreciated.
by dumbomichael
Fri Apr 13, 2012 6:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: client groups
Replies: 7
Views: 5427

Re: client groups

The default maximum number of groups than can be created in a server session is a miserly 20. You can change this to a more reasonable number with the GroupsCreationLimit parameter in the tm1s.cfg settings. It will be effective on the next server restart. thanks for your response. unfortunately, we...
by dumbomichael
Thu Apr 12, 2012 9:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: client groups
Replies: 7
Views: 5427

client groups

Hi guys when i add new groups to the database, under security- clients/groups..., it gives me an error the first time i add the group and close the box. when i reopen it, i have to add the group again as it wasnt saved the first time. i have to do this(2 times) every time i add a group. when the ser...