I am working in a project with a high volume of data. The forecast is to load 1.250.000 records daily between new records and modifications. The queries will run over partitions in the DB with 10.000.000 of records every month.
I had done my model creating an DSO fot operative reporting with a the highest granularity and one infocube with low granularity. My problem now is I have seen that the 90% of reports requires the document and position numbers.
I am wondering if this infocube has sense and I am thinking to create the infocube with a high level of detail adding the document number.
I have thought to partition the DSO by months in ORACLE because ORACLE allows to partition the DSO directly in the DB.
I will appreciate if somebody with experience in projects with high volumes of data could give me some advices about how to manage the data.
The reports are very operative and don't requires to navigate only to show the data.
Thanks in advance.