TM1 Forum

I have concatenated it with error message using CellGetS function.

For example:
My error message is 'Maximum Headcount has exceeded' and my value is some 50.
I wrote as follows:

'Maximum Headcount has exceeded' | CellGetS(Cube,dim1,dim2,value);

Regards,
Jeshwanth

I have got the solution.

Regards,
Jeshwanth

Hi, I need to use a string value in my error message. Let me explain the scenario. I am having a cube with only 2 dimensions. Organization and MaxHeadCount. I am assigning some maximum headcount to each org. So, in the form when the user enters the headcount more than maxheadcount, i am showing a er...

That doesn't help me. Actually my main concern is about moving of positions from one group element to another. Previously when this requirement is not there, i have used a lookup cube for showing the available for each group and assigned them using a MDX Expression. But now, I am stuck with the new ...

Even this didn't help my requirement.
I have tried this, but it doesn't work.

Regards,
Jeshwanth

I have gone through the above functions. But that doesn't help me. Actually I am having Organization Structure like this: XYZ (Company Name) --> AA01 (Dir Name) --> AB01, AC01, AD01 (Group Names) I am also having a Job(Postions) dimension and a Job Desc No (JD No) dimension. I have used a lookup cub...

As I am new to TM1, i have no knowledge about what to use.
I need help from scratch. Please give me the good solution.
please do the needful.

Regards,
Jeshwanth

Hi, The organization dimension I am using is as follows: A --> B --> C There are job(positions) and job code dimensions defined. Now my requirement is as follows. For example the group C is split into two groups C and C1. If there are 200 positions against C then out of these 50 have to be moved to ...