During Level 200: Sales Planning (PY to Budget), after building the procedure to propagate PY sales data to the budget, I performed a functionality test to confirm that PY actual sales data gets populated into the CY budget. When the country selector is set to UK, the data is populating. However, when the country selector is set to Italy, the data is not populating.
Hello @Naganavya B
I understand the issue where the PY sales data populates for one country (UK) but not for another (Italy), even though the same procedure is being used.
To assist you further, please help us with further details.
Could you please provide screenshots of the following for our reference:
Additionally, please go to the Functional Test section, click on No Answer, and follow the listed steps to verify that everything matches as expected. For your reference, I’ve attached a screenshot below. https://nialsmith-gmail.tinytake.com/msc/MTEyNTE1NTJfMjQ5OTA5NTI Awaiting a response from you. Regards, Nial Smith
Hi @Nial, Attaching the screenshots for your reference.
Hi @Naganavya B
As the data flows from ACT - DF - Sales LC to BUD - DF - Sales LC, first check if the data is populated fro Italy in ACT - DF - Sales LC.
To check, create a sample dataview on the same screen with the cube ACT - DF - Sales LC with Product entiy in row dimension (Axis).
Situation 1: If the Data does't appear, then check previous module 205 > Build a Data Model and Capsule Procedure to publish the loaded data to reports > ACT – Sales Data Publish Data Model Procedure.
Situation 2: If the Data appears, then you need check modul 206 > Build Capsule and Data Model Procedures to populate CY budget with PY actuals data > BUD - Initialize Budget Data Model Procedure.
