If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

TM1 dimension to capture string data

Started by hydrojoe, 26 Apr 2011 10:00:25 AM

Previous topic - Next topic

hydrojoe

Greetings everyone

First time poster, relatively new to TM1. Is it possible/good business practices to allow for users to input in string data into a dimension in a cube? An example, would be for financial forecasting purposes the user could enter in their forecasted dollar amount in a specific dimension, then have a separate dimension that would allow them to type in a short comment.  Any ideas would be greatly appreciated. Thanks

hydrojoe

Thanks to everyone for your comments and advice. Great forum!

CAARTI

Hi Hydrojoe,
You are welcome.
Anyways, My comments are, yes you can have strings in the dimension to let users input the additional information in the cube and which can be use effectively in further analysis.
However it is better to have the Picklist formatted elements for entering such string data so that manual typing errorrs can be eliminated.
And one more caution that is required to take is that, if such dimensions has to be kept last in the dimension ordering while creating the cube.