Skip to Content

To avoid data loading in cube on daily basis

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 18, 2016 at 06:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 18, 2016 at 07:23 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 03:56 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded