To avoid data loading in cube on daily basis

[abhimanyu_sharma]

hello experts,

I have a DSO - ABC in which sales matrix flat file will be loaded on daily basis.

From the sales matrix file i need to pick sales man name based on the logic provided and populate the salesman name in billing cube by looking up on DSO ABC and on top of cube we have created a report for our clients.

But here we have major concern. The sales matrix file will get change on daily basis. Due to this we have to delete and load the billing cube on daily basis to reflect the changes. With the course of time, the data volume will increase gradually, hence it would be difficult to drop and load the billing cube on daily basis.

Could you please provide me the real time solution for this so that there would no need to delete and load cube .

Currently my system is bw on hana .

Thanks,

Abhimanyu Sharma.

[RafkeMagic]

So you're saying that in, let's say, 2 years from now you're still going to change the sales man based on a flat file of that day? Sounds a bit weird to me (at least in a DataWarehouse environment).

The proposal by Mario Tibollo makes a lot of sense, but you could also work with logical partitioning.

[former_member186445]

an option would be to define the data coming from the xls as master data attributes of a master data in the cube... that way you can reload the data on a daily basis without deleting the content of the infocube.

[abhimanyu_sharma]

We have created a SQL Script calculation view and look up on DSO to get Sales Matrix based on 13 combinations provided.

Then in Composite Provider , we add it as Right join and set join on Billing document.