Consolidation process
Hi everyone,
I'm having issues when launching the consolidation process after loading data on the cube.
Below you can see the calculation that is triggered when the consolidation process is l...
Forum Discussion
Hi Henning
thank you for the answer.
The problem seems to be somehow linked to that specific calculation that I showed above. To give you more context, I added the following logs to the script:
api.Data.Calculate("A#2A900A01:O#Top:I#None:F#CHI:U1#None:U2#None:U3#None:U4#None:U5#None:U6#External:U7#None:U8#None=A#3ABCDEF0:O#Top:I#Top:F#None:U1#TotProduct:U2#TotC2:U3#TotMarket:U4#TotC4:U5#TotCostCenter:U6#External:U7#None:U8#None")
test = api.data.getdatacell("A#3ABCDEF0:O#Top:I#Top:F#None:U1#TotProduct:U2#TotC2:U3#TotMarket:U4#TotC4:U5#TotCostCenter:U6#External:U7#None:U8#None")
test2 = api.data.getdatacell("A#2A900A01:O#Top:I#None:F#CHI:U1#None:U2#None:U3#None:U4#None:U5#None:U6#External:U7#None:U8#None")
BRApi.ErrorLog.LogMessage(si,"3ABCDEF0: " & test.ToString)
BRApi.ErrorLog.LogMessage(si,"2A900A01: " & test2.ToString)
the POV in the calculation (first row) and POVs within the logs are the same. If the calculation worked fine, I would expect to see the same value assigned to both accounts. Nevertheless, while the log related to the account 3ABCDEF0 return the correct value, the log related to the account 2A900A01 returns 0, which means that the initial formula is not working for some reason
My intention is to help you to dissect the calculation in a way that you spot where it goes the wrong way. Usually in such cases, one member is wrong (not in the constraint, no input, etc.). Setting up a cube view helps as it provides a quick entry point for the analysis.
This one will not work, because O#Top cannot be a target:
api.Data.Calculate("A#2A900A01:O#Top:I#None:F#CHI:U1#None:U2#None:U3#None:U4#None:U5#None:U6#External:U7#None:U8#None=A#3ABCDEF0:O#Top:I#Top:F#None:U1#TotProduct:U2#TotC2:U3#TotMarket:U4#TotC4:U5#TotCostCenter:U6#External:U7#None:U8#None")
Try O#Forms, and then try it in a cube view as well to verify you can enter data into that exact POV selection manually. Once you confirmed that, you can try writing (i.e. calculating) data there as previously described.