Hi All,
If an element type is "Simple" which means numberic data type, but we need the data to be string when some conditions met (with rule function "IF"), is there a rule function to enable the cell to demonstrate string value.
Element type
-
Goatship
- Posts: 33
- Joined: Tue May 25, 2010 4:15 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2007
Element type
I'm new to TM1.
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Element type
No. Add another dimension to your cube with 2 elements; "Amount" (classfied as simple) and "Text" (classified as string data). Of course, you don't have to call your elements that but you get the idea. This gives you the ability to store numeric and/or string data for each intersection of all your other dimensions.
Technically, you could also leave the original element typed as string and store either text or numbers in it (because numbers are also characters) but your hierarchy points won't work as expected. String data can't be the summed like numeric data so in essence, your cube will become a flat hierarchy with all levels in each dimension becoming a leaf as far as data storage is concerned. Not to mention whatever issues you'll run into with reports, having to convert numeric data that was stored as a string back to a number. I do this on occasion, storing numeric data in a string element, but mostly for element attributes, not entire cubes.
Technically, you could also leave the original element typed as string and store either text or numbers in it (because numbers are also characters) but your hierarchy points won't work as expected. String data can't be the summed like numeric data so in essence, your cube will become a flat hierarchy with all levels in each dimension becoming a leaf as far as data storage is concerned. Not to mention whatever issues you'll run into with reports, having to convert numeric data that was stored as a string back to a number. I do this on occasion, storing numeric data in a string element, but mostly for element attributes, not entire cubes.