Qustion About Have String and Number elements both

Post Reply
keigo840413
Posts: 15
Joined: Wed Oct 13, 2010 6:09 am
OLAP Product: COGNOS
Version: 9.4
Excel Version: 2003

Qustion About Have String and Number elements both

Post by keigo840413 »

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?
lotsaram
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

Post by lotsaram »

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