Question:
For sales reporting, we are looking into a solution were we can combine reporting on customer masters(0customer, 0cust_sales, creditmaster ++) and billing information. We have tried with an infoset combining all but it proved to be not working due to performance, difficult to set good keys (large number of customers/billing trans.). We then tried to split it into seperate infosets and combined it all into a multicube. The problem was the same; poor performance, problems setting good char. relations (keys), difficult creating correct queries. Aslo, to 0rowcount, combined all infoproviders when counting masterdata, instead of showing on per infoprovider.
The next step would be to make masterdata as infoproivderes/and or create masterdata ODS, but we would like to avoid dublicate loading/storing .
Any suggestion for a possible solution?
Answer:
A sample report would be helpful, as I don't understand what you are trying to do.
_________________
Keep smiling
Answer:
An example:
Display customer billed last 6 months, 12 months, customers not billed, with additional characterisitics from Credit customer master.
Answer:
if you are in 3.x you shouldn't need an ods object, just insert 0cust_sales and 0customer as infoproviders and make a multiprovider with them and your billing infoprovider. all billing values as well as all attribute data from the characteristics should be available to query. for queries like "customers not billed" look up the how-to on slow-moving articles. performance i much better than infosets, you can make it emulate an outer join (for "not billed") i have done it for over 300000 customers against 3/4 of a billion transactions and get 1 - 5 min response time.
Answer:
We have a cube with > 11 billion records, ZMATERIAL with additional material prices, ZCUSTOMER.
All put in a multicube. Wehave reports like not sold materials, material prices (combinations of masterdata and transactional data).
The performance is ok (use of proper aggregates).
Check sapnet. (..BW-> Media Library -> Presentations... -> OLAP business scenario's and Selected OLAP features