level3 sprint1 4.6.5 Sale Planning Model: DAT02 module

Deekshitha29

Hi,

I am now struck in below excercise 4.6.5.

`As`

As per the ask i have done the below steps

-Created a DAT05 module in datahub with Historic sales revenue for 2019

-In Sales model i have created DAT01 for Historic revenue and imported it from Datahub model

-Created DAT02 PY revenue to CY. And used the below formula for pulling the data from DAT01 with Account>product# list

'DAT01 Historic data'.Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS03 Account>Product Details'.Product Flat, LOOKUP: 'SYS00 Time Settings'.PY Qtr]

However the data is turning 0 in my module, not sure what is wrong. I have checked all the parameters. but still no luck

Can someone let me know what is wrong here? I am struck in it for days now.

Regards,

Deekshitha

Accepted answers

Deekshitha29

Hi @Prajjwal88

Below is the snapshot of SY03 Module.

Regards,

Deekshitha

All comments

Prajjwal88

Hi @Deekshitha29 ,

Can you share the snapshots of the Source module (DAT01 Historic Data) and the mapping modules used in Lookup (SYS00 & SYS03). I hope in your historic module you have data for previous year i.e., FY19 and In the SYS00 time settings module you're creating quarter by quarter mapping for previous year to next year.

Deekshitha29

Hi @Prajjwal88

Yes, I have imported the data for FY19 from Datahub Module and SY00 has PY Qtr, Below are the snapshot

regards,

Deekshitha

Prajjwal88

Hi @Deekshitha29 ,

The Source module data collection and the SYS00 time settings module looks correct, Just that if you can check on SYS03 mapping module (whether the values are correctly coming or not) and share the snapshot of the same as well, along with the blue print view (Check for A1 account)

Deekshitha29

Hi @Prajjwal88

Below is the snapshot of SY03 Module.

Regards,

Deekshitha

Deekshitha29

Hi @Prajjwal88,

I redid the entire Level 3 exercises from Scratch. This time the numbers were appearing as expected.

Thanks for your time and effort for helping me out.

Appreciate it

Regards,

Deekshitha😊

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…