Could not initialize process : Incorrect type for parameter

Post Reply
vasek1192
Posts: 47
Joined: Sun Jan 24, 2021 5:55 pm
OLAP Product: IBM Planning analytics
Version: 2.0.9.3
Excel Version: 2019

Could not initialize process : Incorrect type for parameter

Post by vasek1192 »

Hi,

I got stuck with this little problem and would appreciate any kind of help or advice.

I am executing a subprocess through another process. The master process supplies the subprocess with parameters from data source (cube) variables.
The subprocess then executes CellInctrementN function into different cube.

ExecuteProcessLine:

Code: Select all

ExecuteProcess('L_OO_JN_6MK_zadavaci_JN_6MK_Vkladaci', 'psVerze', psVerze, 'psMaska', sMaska, 'psRozlozenost', sRozlozenost, 'psZavod', sZavod, 'psDruhyVozu', sDruhy_Vozu, 'psTemata', sTemata, 'psMesic', vsMetrika, 'psMetrika', vsG_OO_JN_6MK, 'pnValue', vnValue);

CellIncremenetN line

Code: Select all

CellIncrementN(pnValue, sTargetCube, vsH_Zeme, vsH_Rozlozenost, vsH_Vozy_6MK, vsG_Zavod, vsG_Druhy_Vozu, vsG_Temata, psMesic, psverze, vsMetrika);
I am getting this error:

"Could not initialize process : Incorrect type for parameter 9 ("pnValue") of process "L_OO_JN_6MK_zadavaci_JN_6MK_Vkladaci", string expected"

All the measure elements in TargetCube are numeric. The data source value from the first cube is set as numeric (viz pic1). The parameter in the second cube is set as numeric (viz pic1). I am using CellIncrementN. I have no idea why he would require string value?

Any help or advice?

Data source (First cube, first process):
Source 1 problem.jpg
Source 1 problem.jpg (72.61 KiB) Viewed 698 times
Parameters in subprocess:
parameters.jpg
parameters.jpg (46.04 KiB) Viewed 698 times
User avatar
gtonkin
MVP
Posts: 1199
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Could not initialize process : Incorrect type for parameter

Post by gtonkin »

What is vnValue set to in the parent process? Could be that it is being set to a string.
vasek1192
Posts: 47
Joined: Sun Jan 24, 2021 5:55 pm
OLAP Product: IBM Planning analytics
Version: 2.0.9.3
Excel Version: 2019

Re: Could not initialize process : Incorrect type for parameter

Post by vasek1192 »

Hi, vnValue is set as numeric in the datasource (viz first picture in original post). Some of the measure elements are string but they are filtered off from the sourceview.
Post Reply