Troubleshooting
Problem
Running a TI process to import data writes message "Data Source line(1) Error: Data Procedureline(30): Cell type is consolidated" to process log when in fact the cell is not consolidated. Cells tested using Ellev functions and CelIIsUpdateable functions.
Cause
Formula used to calculate the variable being used in CellPutN command had a forward slash for divide not a backwards slash.
Wrong:
vResult= vPAXonGround * ( vValue / vTotalPAX);
Correct:
vResult= vPAXonGround * ( vValue \ vTotalPAX);
Resolving The Problem
Correct the formula.
[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21569202