Hi All,
I have one question about have both string and number element in one dimension.
If i I set the other dimension in cube as string that the number element will not work.
if i set the other dimension in cube as number that the string will not work.
Does anyone has experience about this?
Qustion About Have String and Number elements both
-
- Posts: 15
- Joined: Wed Oct 13, 2010 6:09 am
- OLAP Product: COGNOS
- Version: 9.4
- Excel Version: 2003
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Qustion About Have String and Number elements both
I think you need to explain more fully what you are trying to do and why but you should be aware that in a TM1 cube it is the last dimension that determines whether data can be stored as numeric or string. Therefore it is only whether the element type is string of the last dimension of the cube that matters.