Level 200, module 206: Sales Planning Screen not showing data

davide.garaffa
davide.garaffa Customer
Level 200: Building A Planning Solution in Board Name Dropper First Comment Level 100: Foundations of Building in Board
in Academy

Hi there,

I completed all steps to build the Sales Planning screen, but it seems to not give me any output data at all. Can someone please help me out? I am out of ideas.

The capsule selection was set to UK as Country, 2023 as Year, Budget as Version, and dynamic selection on currency from BUD - DF - Sales LC. However, it shows nothing on the screen even playing with any other filter or set no filters at all.

image.png

I have troubleshot all the suggestions from the functional test below, but everything in data model and capsule was set up as explained in the guide box.

image.png

Here following the data view configuration. I tried playing with the Screen and Layout Selections, by changing fields and filters, but nothing changes in the data view.

image.png

Top 5 products cartesian chart configuration:

image.png

Capsule Procedure details below:

image.png
image.png
image.png

Data Model Procedure details below:

image.png
image.png
image.png

Thank you for the help!

Answers

  • Tommaso Riva
    Tommaso Riva Employee
    Fourth Anniversary 25 Likes 5 Answers 10 Comments

    Hi @davide.garaffa

    Is it possible to confirm that the source cube "ACT - DF - Sales LC" shows the data?

    Simply enter a data view with that cube and input the year by column in a new screen without any screen selection and check whether the figures are displayed correctly for the years 2022 and 2023.

    Regards,

  • davide.garaffa
    davide.garaffa Customer
    Level 200: Building A Planning Solution in Board Name Dropper First Comment Level 100: Foundations of Building in Board

    Hi @Tommaso Riva

    You're right, ACT - DF - Sales LC doesn't show any figure at all.

    This is the configuration. What should I do to fix it?

    image.png
    image.png

    Thank you for your help!

  • Tommaso Riva
    Tommaso Riva Employee
    Fourth Anniversary 25 Likes 5 Answers 10 Comments

    Hi @davide.garaffa,

    I see from the snapshot that the cube is linked to two data flows.

    Assuming that one of the two data flows is the one shown in the original message (please confirm), where you have BUD - DF - Sales LC = ACT - DF - Sales LC, verify the other:

    Is the source cube in that data flow step populated?

    If not, check the data loading procedure where the data should be fetched (data reader).

    If yes, check the calculation domain in the data flow step.

  • davide.garaffa
    davide.garaffa Customer
    Level 200: Building A Planning Solution in Board Name Dropper First Comment Level 100: Foundations of Building in Board

    Hi @Tommaso Riva

    Thank you so much for your help! I was able to see some figures by fixing and re-making the second data flow step you noticed. The source cubes are all populated. So now the two data flows are as follow.

    1. BUD - Initialize Budget procedure: BUD - DF - Sales LC (target; b) = ACT - DF - Sales LC (source; a)
    2. ACT – Sales Data Publish procedure: ACT - DF - Sales LC (target; b) = TEMP - ACT - DR - Sales LC (source; a)

    I still have a mismatching problem though:
    The data appear to be duplicated for these 5 Product members, while missing for all other 31 members.

    The product entity contains 36 members as it should. The bar chart has the keep top 5 filter, and the data view doesn't. Removing this filter doesn't load any more members. In the screen, 2023 is set as default year, UK default country, budget default version, and dynamic selection for currency.
    The data view is configured as the first message screenshot:
    Product by row; Block a) BUD - DF - Sales LC ; Block b) ACT - DF - Sales LC [Previous Year time function on]; c) a-b ; d) c/b*100 .

    Do you have any idea?

    image.png

    image.png

    (Functional test of solution section; m.206, 1)

    Thank you again!

    Davide

  • Tommaso Riva
    Tommaso Riva Employee
    Fourth Anniversary 25 Likes 5 Answers 10 Comments

    Hi @davide.garaffa,

    it's great to see that we're making progress.

    If you copy the data view object to a blank screen (without screen selection), does it show all the products? That will help you troubleshoot your issue.

    Thanks

Categories