Module 205 in Level 200 Building a Planning Solution in Board

Ken Walsh

Has anyone else picked up on this issue below in module 205 of Level 200?

In the Academy, module 205 there seems to be a fault. The “ACT – Sales Data Publish” procedure where it calculates ACT – DF – Sales GBP, does not calculate as per the screenshot. In order to make the data flow work properly I needed to split it into two data flows with a temporary cube where the temporary cube has the currency in it and the second data flow just removes the currency as it puts it into the ACT – DF – Sales GBP cube. I’ve seen exactly the same behaviour in client environments after upgrading to Board 12.

The issue seems to be that without the currency in the output cube that it merges the two currencies together with an effective exchange rate of 1.88 instead of 1.

Crystal Zhao

Hi Ken,

I see exactly what you mean. I like the way that you created the temporary cube to get the calculation to work. An alternate solution that I used was to add a step directly before the multiplication data flow to Select Entity based on cube (with the cube based on TEMP - ACT - DR - Sales LC) so that it would look for only one currency.