Skip to Content
0

To avoid data loading in cube on daily basis

Nov 17, 2016 at 06:25 PM

86

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Mario Tibollo Nov 18, 2016 at 06:44 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Raf Boudewijns Nov 18, 2016 at 07:23 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
abhimanyu sharma Feb 24, 2017 at 03:56 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded