Account dimension not passing in stored procedure in default logic

29 Views

Hello experts,

we have a default logic running a stored procedure with parameters:

*RUN_STORED_PROCEDURE=Z_SP_Test_Default('%ACCOUNTP_SET%','%BRANDS_SET%', ','%CATEGORY_SET%','%DATASRC_SET%','%ENTITY_SET%','%GROUPS_SET%','%INTCO_SET%','%MARKETP_SET%','%TIME_SET%')

with all the dimensions existing in the cube.

However, when we send data and the stored procedure is launched, the account dimension is not properly passed to the stored but the rest of the parameters are correctly passed.

Looking into the network, we have tried putting:

*SCOPE_BY = ACCOUNTP, BRANDS, CATEGORY, DATASRC, ENTITY, GROUPS, INTCO, MARKETP, TIME

*RUN_STORED_PROCEDURE=Z_SP_Test_Default('%ACCOUNTP_SET%','%BRANDS_SET%', ','%CATEGORY_SET%','%DATASRC_SET%','%ENTITY_SET%','%GROUPS_SET%','%INTCO_SET%','%MARKETP_SET%','%TIME_SET%')

but then, it is quite strange, because when the default logic is executed the ACCOUNT is passed correctly but the rest of parameters are passed as 0.

Any idea?

Thanks a lot for your help!