DAT05 Historic Revenue by Product

jjconn13

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

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

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!!