Can someone help me with the Budget Increasement? Whenever I try to apply the Increasement, the data for CY Actual disappears even though I did the exact same steps as in the tutorial.
Hi Fabian, Can you let us know what is Previous year and Current year? Also, selection in 1st step is applied on which entity?
Hi Jui, I fixed the issue, there was an issue with an entity but it works fine now.
Thank you for reaching out.
Hello, I also need help a this point. When I apply the increasement, der CY is empty. Also the Timestamp is not working. @Jui Date
Can someone help me?
Hi @BSalveter ,
the CY Budget cube should be calculated using a dataflow. That dataflow uses the PY actuals and the increase rate as input. Assuming the CY is 2023 and version is "Budget"—that's set as selection.
Then you can do the calculation in 2 steps:
Best, Helmut
Thanks a lot. The reference to “Previous Year” is missing in the task description of the exercise.
Can you also help me with the Timestamp? I don't know, why it shows zero (Sales Planning).
first of all, please check that your cube for the timestamp has the correct dimensions and type
Type should be "Text". Then, check the contents of the entity "Timestamp"
Check that you have these two steps in your initialization procedure
The dataflow step should extend on both dimensions
Hi @Helmut Heimann I did everything like this. However, the cube is displayed differently in the data view at the two marked points than in the sale upload.
Sales Upload (Sales Actuals):
the timestamp cube has a dimension "Timestamp". You'll have to select one member of that entity (either by reference on the block or in a layout-select). Here's what a layout-select would look like
I also did this…
ok, looks good. Can you please create a new screen with no selections at all, a pager on Country and a dataview with the timestamp cube where you put the "Timestamp" dimension in the rows?
Just to see, where the cube has data…
@Helmut Heimann this?
Best
Barbara
Hi @BSalveter , hello Barbara ;-)
yes, that's what I was looking for.
It shows that the algorithm you used to populate the timestamp cube during the initialization procedure is not working correctly. It should look (exactly) like this
@Date&" at "&@Time&" by "&@User
Please check whether you were missing any quotation marks or at-signs or ampersands.
…and please doublecheck that you extend the calculation in the timestamp-setting on Country and Timestamp:
@Helmut Heimann
Now it works. I just can't explain it because the algortithm didn't change after I overwrote this line. Thanks for the effort!!!
you're welcome, Barbara!