Hello,
I am trying to load contract start dates into a cube and I get an error that says "Cell type is real".
The date is in the format 31/12/2009.I have tried making the variable type numeric and string.
I have also tried with the date as 40178 instead of 31/12/2009. Help!
Cell Type is Real
-
lotsaram
- MVP
- Posts: 3698
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Cell Type is Real
This error means that you are attempting to load string data to a numeric cell. Either change the cell type or the data type. Remember that it is the last dimension in the cube that determines cell type.
-
Martin Ryan
- Site Admin
- Posts: 1989
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Cell Type is Real
Did you ensure that the data type of the variable was Numeric in your TI process?telula wrote: I have also tried with the date as 40178
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer