TM1 Forum

Is it possible to transfer data using a string field? Like for example I have 10 cost center, I want the people in this cost center to define which profit center they want to pass the cost to. What's the best approach to this?

So in the cost center cube I would have for example the the following dimension:
- Cost Center
- Month
- Expense
- Measure
- Amount (N)
- Comment (S)
- Profit Center (S)

Then the profit center cube would have the following
- Profit Center
- Month
- Expense
- Measure
- Amount (N)
- Comment (S)


I would also like to know how to feed strings like for example comment, so I can view the text field during Zero Suppression.