DAT05 Historic Revenue by Product

Hi, I'm trying to import historic quarterly 2019 data into the DAT05 Historical Revenue by Product module, but the time settings does not allow for me to select Quarters in the Time Scale column. Do I need to adjust the Time Settings for the Datahub model or is there something else I'm missing? Any guidance would be much appreciated!

Thanks!

Joseph

Accepted answers

Misbah

@jjconn13

Not sure if I understood your question. But let me answer it anyway

If you don't see quarters it most probably might be because you have not included "Quarters" on your TIME section of the model.

All comments

Misbah

@jjconn13

Not sure if I understood your question. But let me answer it anyway

If you don't see quarters it most probably might be because you have not included "Quarters" on your TIME section of the model.

jjconn13

Great, thank you! Since it was a Time Range I updated the below.

ssicefox

Hi,

I'm trying to import 2019 Actual Sales data into the DAT05 Historical Revenue by Product module, but the import of data always failed with a message "Expected fiscal quarter number in date/period".

When I select "Match names Match names from the source file against model timescale" in the Time Tab, the data will be imported into the module, but the data is not correct.

Any guidance would be much appreciated!

Best regards.

Wei

DAT05_Historic_Revenue_by_Product_6_117268.JPG

DAT05_Historic_Revenue_by_Product_7_117268.JPG

DAT05_Historic_Revenue_by_Product_5_117268.JPG

DAT05_Historic_Revenue_by_Product_2_117268.JPG

DAT05_Historic_Revenue_by_Product_3_117268.JPG

DAT05_Historic_Revenue_by_Product_1_117268.JPG

DAT05_Historic_Revenue_by_Product_4_117268.JPG

DAT05_Historic_Revenue_by_Product_8_117268.JPG

Misbah

@ssicefox

Mapping looks ok. Could you please show us the dimensions of the DAT05 module. It should be Product Flat List and Account Flat List apart from Time dimension. What is the Product Flat list looking like?

It looks like the numbers are being aggregated.

Misbah

ssicefox

Hi @Misbah

Thank you for your reply. I found a solution yesterday.

The Revenue should be applied to Product Flat and Account Flat. Then the data import is good.

Misbah

@ssicefox

Great!!

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385