Competing Text formats

Post Reply
fourfive
Posts: 5
Joined: Tue Aug 21, 2012 1:16 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007
Location: UK

Competing Text formats

Post by fourfive »

I'm attempting to create a cube that users can input data to, it's a mix of numeric input and text input. I've mocked it up below
MixedTextandNumeric.PNG
MixedTextandNumeric.PNG (26.34 KiB) Viewed 2319 times
The dimension displayed on the rows with elements 'Source' through to 'Deal100' has Source formatted to allow a pick list of Country.
The dimension on the columns with elements 'Comment', 'Deal Type' and P01 through to P12 has 'Comment' as text and 'Deal Type' as a Pick List, the P01 etc as numeric.

Users input Comments, deal type Source and values.

My problem is the formats compete so depending on the dimension order, one or the other prevails. Is there a solution?
Last edited by fourfive on Thu Jun 12, 2014 2:34 pm, edited 2 times in total.
Top
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:
Contact jim wood

Re: Competing Text formats

Post by jim wood »

Have done any research on string elements and their limitations? I would start there,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Top
Post Reply

Return to “IBM TM1, Planning Analytics, PAx and PAW”