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.
Using String Fields to transfer data
-
- 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