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

davide.garaffa · 2024-05-29T19:20:42+00:00

There was an error rendering this rich post.

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.

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.

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.

Top 5 products cartesian chart configuration:

Capsule Procedure details below:

Data Model Procedure details below:

Thank you for the help!

Find more posts tagged with

Accepted answers

All comments

Tommaso Riva

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

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?

Thank you for your help!

Tommaso Riva

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

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.

BUD - Initialize Budget procedure: BUD - DF - Sales LC (target; b) = ACT - DF - Sales LC (source; a)
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?

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

Thank you again!

Davide

Tommaso Riva

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