Using String Fields to transfer data

Post Reply
appleglaze28
Regular Participant
Posts: 269
Joined: Tue Apr 21, 2009 3:43 am
OLAP Product: Cognos TM1, Planning
Version: 9.1 SP3 9.4 MR1 FP1 9.5
Excel Version: 2003

Using String Fields to transfer data

Post by appleglaze28 »

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.
Post Reply