Picklist in Cognos Insight data spread fails on one element
Posted: Fri Feb 08, 2013 9:27 am
Hi All -
I have assigned a pick list of service functions on one of the string measures and it has following members;
'
- Delivery
- Organisation
- Admin
I built this model in TM1 Architect, and was able enter a couple records correctly, including selecting a value from the pick list. I packaged the data model into Cognos Insight application manually, and opened up Cognos Insight, and it started to act weirdly. Now, when i drag and drop the cube into Insight tab, and try to select 'Delivery' as the value from the pick list, it gives me the following error:
update cell data error.
Invalid Cell Data
Cell Data not updated
Details:
SPREAD INVALID SYNTAX (Function):(3): Delivery
If i select Organisation or Admin from the pick list drop down, i don't get any errors. This pick list defined in measure attributes, and comes from a static subset from service delivery dimension. The element 'Delivery' is very much there in the dimension as well. I am not doing any rule or data driven operation using the element Delivery. furthermore; I am able to select 'Delivery' in Architect and enter data without any errors.
Could you please help me with this one?
Environment: Cognos TM1 10.1.1 & Cognos 10.2
Windows 2008 Server
Thanks.
I have assigned a pick list of service functions on one of the string measures and it has following members;
'
- Delivery
- Organisation
- Admin
I built this model in TM1 Architect, and was able enter a couple records correctly, including selecting a value from the pick list. I packaged the data model into Cognos Insight application manually, and opened up Cognos Insight, and it started to act weirdly. Now, when i drag and drop the cube into Insight tab, and try to select 'Delivery' as the value from the pick list, it gives me the following error:
update cell data error.
Invalid Cell Data
Cell Data not updated
Details:
SPREAD INVALID SYNTAX (Function):(3): Delivery
If i select Organisation or Admin from the pick list drop down, i don't get any errors. This pick list defined in measure attributes, and comes from a static subset from service delivery dimension. The element 'Delivery' is very much there in the dimension as well. I am not doing any rule or data driven operation using the element Delivery. furthermore; I am able to select 'Delivery' in Architect and enter data without any errors.
Could you please help me with this one?
Environment: Cognos TM1 10.1.1 & Cognos 10.2
Windows 2008 Server
Thanks.