Creation monthly reports

Yury

HI,

I'm looking to concept how to build the next thing in DataIKU:

I build the flow that will create monthly report (input data comes from DWH (oracle) with month='current month'). After logic of report will be developed - I need to create past months of this report where month='previous month' etc.

What is the best practice to do that? Parameters/loop/scenarios?

thank you

Operating system used: WIN

Alexandru

Hi,
There are several options here you could use partitions by MONTH
https://doc.dataiku.com/dss/latest/sql/pipelines/partitions.html
Build your flow based on the MONTH.

The other option is to use a project variable and the defined "month" and replace it accordingly in your recipes/ SQL queries https://knowledge.dataiku.com/latest/automation/variables/concept-introduction-syntax.html

Depending on your case, you may also want to create a Dataiku Application if you are able to easily generate a report for a specific month passed a parameter and later leverage the project variable
https://doc.dataiku.com/dss/latest/applications/index.html