URGENT - TM1 Data not updating

[ashishkmr1]

Hi All,
We are getting a strange problem. Till yesterday our TM1 implementation was behaving normally. Today morning when we are trying to update values at leaf level cells, we are not able to do so. We are able to enter values in the leaf level cells, but when we recalculate, the entered value goes off and the cell displays the original value again.
Can some one pls help with this?

Thanks,
Ashish

[ashishkmr1]

A couple of other problems that we are facing
1. We are not able to create dimensions. When we create dimensions directly thru Server Explorer, we get an error message saying "Dimension Save Failed".

2. We are not able to create new workflows or processes in the existing workflows. The same implementation in the development environment is working and we are able to create new workflows as well as add processes to the existing ones. But it does not work in the UAT environment. We keep on getting the error message "Workflow creation failed".

Can someone pls help with these also?

Thanks,
Ashish

[Martin Ryan]

Try checking your environment. Could possibly be that you've run out of diskspace and can't write back to the log files or dimension files.

Other possibility is that TM1 has recently been restarted with a different service login, one that doesn't have administrative rights.

My first attempt to fix (if the disk space isn't full) would be to stop and restart the service.

Martin

[ashishkmr1]

Thanks for the reply Marting.

Let me add some more information now. After posting the message, we started dignosing it. We found that only with the "Admin" user id (part of the ADMIN group), we are not able to update the cube values. There is another user "Admin 1" that is part of the ADMIN group and using Admin 1 id, we are able to update the cubes. So there is something that has got goofed up in the Admin user profile which we are not able to pinpoint.

For the diskspace part, there is enough diskspace (to the tunes of GB) available on the server. We would try stopping and starting the server again and check it out.

Thanks,
Ashish

[ashishkmr1]

Oops Did I just make you a verb??? Sorry for the typo in the post below.

Thanks for the reply Marting.

[ashishkmr1]

OK...so finally found out that the "Value" dimension in our implementation is actually not so "valued"...

The workflow problem finally got resolved after the IBM product development team sent the below explaination today...It seems things in workflow do not work well with the "Value" dimension....so to avoid this error, do not have a dimension called "Value" in your implementation...or wait for V10.1

"Development have come back and it seems this is a known defect that has been targeted for a fix in TM1 v10.1. The problem is that you have a "Value" dimension in the model, and that breaks the rules for the }ElementCaptionsByDimension cube.

There is a workaround for this issue, it is;

- Modify the '}ElementCaptionsByDimension' rule (first line) to display as follows:

['}CaptionMeasures':'Value'] =S:

I wanted to put this in an appropriate place where people can search for such known issues...If there is such a place in this forum, can some one pls put this there

Thanks,
Ashish

[Martin Ryan]

Ashish, the best place to put it is the bugs forum.

[comma]

...or wait for V10.1

I know my post is a bit out of topic, but did IBM mention when will this so called 10.1 be released?

[ashishkmr1]

@comma - No they did not say anything about the release date for 10.1

@Martin - I have posted it in the Bugs forum now.

[ashishkmr1]

OK the first problem of user "Admin" not being able to update data is also resolved. After a couple of days of looking into various cubes (and pls note that I am just learning TM1), finally figured out that }ClientProperties cube was the place to look at and the element "Read only User" should be set to 0 for the user to be able to update cells on TM1.

I think control cubes are a whole different specialization and I need to catch up fast on them to impeove a few other things

Thanks,
Ashish