Leve 200 Module 214 Section 4: L2 Demo Data Model Profit And Loss Statement Template

Question

My numbers do not line up (significant numbers of rows are not populated). What am I missing?

This is my configuration:

From Board Academy screenshot:

Joel Llacar · Answer

I did not run these in its proper sequence. And the data is now full populating matching the screens. Thank you

Anthony Miller · Answer

Hi Joel,

Thank you for allowing us time. Based on the issue you're facing, it seems that some parts of the build process from the previous lesson may not have been completed correctly.

Please go through the following checklist carefully and let us know which steps you have already tried:

Step‑by‑step verification:

* Data loading:

Did you run 1? Load Data and 2. Publish Data separately for Italy and the United Kingdom on both the Sales Data Upload and Expense Data Upload screens?
* Procedure group setting (Expenses):

In the ACT - Expenses Data Publish Data Model Procedure, is step 8 (Go to group) set to:* Procedure groups: Profit and Loss ACT
* Iterations: 1
* Get back: selected

* Dynamic selection (Expenses):

In the Profit and Loss ACT procedure group, at step 10 (Selection) of the same Expenses procedure, has a Dynamic Selection based on the ACT - DF - Expenses LC cube been applied to the Account Entity?
* Data flow – Step 12 (Expenses):

Is step 12 (Data Flow) configured as:* Target c: TEMP - Month, Currency, Account, Store = a * b
* Where a = ACT - DF - Expenses LC and b = UTIL - FX Rates

* Data flow – Step 13 (Expenses):

Is step 13 (Data Flow) configured as:* Target b: ACT - DF - Profit and Loss Statement GBP = a * -1
* Where a = TEMP - Month, Currency, Account, Store

* Procedure group setting (Sales):

In the ACT - Sales Data Publish Data Model Procedure, is step 10 (Go to group) set to:* Procedure groups: Profit and Loss ACT
* Iterations: 1
* Get back: selected

* Dynamic selection (Sales):

In the Profit and Loss ACT procedure group, at step 12 (Selection) of the Sales procedure, has a Dynamic Selection based on the UTIL - DE - Product - P&L Mapping cube been applied to the Account Entity?
* Data flow – Step 13 (Sales):

Is step 13 (Data Flow) configured as:* Target c: TEMP - Month, Currency, Account, Store, Product = a * b
* Where a = ACT - DF - Sales LC and b = UTIL - DE - Product - P&L Mapping

* Data flow – Step 15 (Sales):

Is step 15 (Data Flow) configured as:* Target c: TEMP - Month, Currency, Account, Store, Product = a * b
* Where a = TEMP - Month, Currency, Account, Store, Product and b = UTIL - FX Rates

* Data flow – Step 16 (Sales):

Is step 16 (Data Flow) configured as:* Target b: ACT - DF - Profit and Loss Statement GBP = a
* Where a = TEMP - Month, Currency, Account, Store, Product

* Country selections:

Have you applied the correct selections to Country?

Please go through these points and let us know which steps you have already verified and whether any were missing or incorrectly configured. This will help us identify the root cause.

Anthony Miller · Answer

Hi Joel,

Thank you for providing the screenshot. That’s very helpful.

We will check the configuration and get back to you as soon as possible. Please allow us some time to review.