Level 3 Sprint 1 - 5.2 PY Account Revenue

Hello All,

I have stuck with formula for 'PY Account Revenue' in 'TAR01 Detailed Sales Targets'.

Looks like formula:
'DAT02 PY Revenue to CY'.PY Sales Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account']
is not correct, because I have incorrect numbers in Check module.

Can anyone help with correct formula for that item?

Accepted answers

KonstantinGrishachev

Here is correct numbers:

The problem was formula for 'PY Country and Product Family Sales'. It should be sum by product and country. Use staging module to calculate it.

All comments

Misbah

@KonstantinGrishachev

We are not supposed to provide you answers but let me just provide you the hint here:

Check the dimensionality of your source module and target modules and see if you are missing any LOOKUPs.

KonstantinGrishachev

This is not a dimensionality problem.
Both modules has 'A2 Account>Product#' list, 'Time' list and 'Line Items' list.

I use LOOKUP to obtain information from Account level, but results is incorrect.

There is no information about 'PY Account Revenue' in User story and Model Build Specifications.

Also there is no data checks for 'PY Account Revenue'.

As I understand 'PY Account Revenue' is sum of 'PY Actual Revenue' for specific account in 'DAT02 PY Revenue to CY' module.

bleeds

Hey were you able to figure this out? I’m not looking for a direct answer, just perhaps a helpful hint. My dimensionality is correct for both the target and Source modules and my understanding is that this line item should produce the actual revenue for a specific account from the DAT02 Module as well. @KonstantinGrishachev

bleeds

@Misbah

Hey,

I was hoping you can shed more light on the above. I’ve confirmed that the dimensionality is correct for both the source & target modules. So presumably the issue is with my LOOKUP. Currently I’m referencing A1 Accounts from the SYS03 Module. Would you mind confirming that this line item is supposed to populate the sum of actual revenue for a specific account from the DAT02 module? There is no information related to this line item in the use case.

Best Regards,

Brian

KonstantinGrishachev

Hello Brian,

I have no solution on this question.
There is really no information about this line item (numbers or description).

This certification is on hold for me until other my partners will come to this question.

davidlloyddeguzman_*21119

I'm encountering this same issue.

It's asking for the prior revenue for that account.
So I do a look up which pulls the total revenue for that account.

However the check model build doesn't provide enough context.

macsimpson

Has anyone been able to come up with a solution for this activity? @davidlloyddeguzman @KonstantinGrishachev @bleeds @Misbah

KonstantinGrishachev

Here is correct numbers:

The problem was formula for 'PY Country and Product Family Sales'. It should be sum by product and country. Use staging module to calculate it.

macsimpson

Thanks! @KonstantinGrishachev

klameer

Thanks @KonstantinGrishachev this was really helpful.

RyanD

Can we just reference the revenue line item from the DAT02 module since the source and target module share A2Account>Product# list? In other words, no Lookup needed

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…