DAT05 Historic Revenue by Product

jjconn13
Occasional Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: DAT05 Historic Revenue by Product

@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.

 

Misbah_0-1615872223148.png

 

View solution in original post

6 REPLIES 6
Misbah
Moderator

Re: DAT05 Historic Revenue by Product

@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.

 

Misbah_0-1615872223148.png

 

View solution in original post

jjconn13
Occasional Contributor

Re: DAT05 Historic Revenue by Product

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

 

jjconn13_0-1615873026504.png

 

ssicefox
Frequent Contributor

Re: DAT05 Historic Revenue by Product

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

Misbah
Moderator

Re: DAT05 Historic Revenue by Product

@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
Frequent Contributor

Re: DAT05 Historic Revenue by Product

Hi @Misbah

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

 

ssicefox_0-1629459711867.png

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

ssicefox_1-1629459968908.png

 

 

Misbah
Moderator

Re: DAT05 Historic Revenue by Product

@ssicefox 

 

Great!!