Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 

Recently I have been assigned with a reporting requirement to compare measures (E.g. Sales Figures) from This Year's date compared with the same date from Last Year's. Below might give some idea of the reporting requirement or report format requires.

The reason for such reporting requirement is because the client need to compare how good the sales is compared with the same day of last year. This is to make sure that the marketing strategy could be in place or to discontinue certain line of products when there is a drastic change of the sales observed. Nevertheless there could be multiple ways to look at these data.

This Year DateLast Year DateThis Year SalesLast Year SalesThis Year MTDLast Year MTD
05.01.201505.01.20145,500.004,000.0027,500.0025,500.00
04.01.201504.01.20144,000.003,500.0022,000.0021,500.00
03.01.201503.01.20141,000.002,500.0018,000.0018,000.00
02.01.201502.01.20148,000.008,000.0017,000.0015,500.00
01.01.201501.01.20149,000.007,500.009,000.00

7,500.00

In order to create such a reporting requirements, a single InfoCube that contains the Day Sales are created. In this InfoCube there should be 3 different dates, that is the Current Date, Last Year Date and Next Year Date. These dates should be populated accordingly during data load.

In order to view the above mentioned report format we need to combine two different InfoCubes but in order to prevent data duplication of Previous Year data, we could instead create another InfoSet from the same InfoCube that we have created previously and named it as Sales Figure (Last Year). This eventually will be used in the MultiProvider that combines the original InfoCube and the new InfoSet created.

In the MultiProvider, it should combine 2 InfoProviders, that is the original InfoCube and the InfoSet. There within the MultiProvider should be the Current Date and the Last Year Date InfoObjects. Additionally, 2 sets of key figures should be included that is the sales figures from the InfoCube and InfoSet.

Assignment of the InfoObjects to the InfoProvider should look like below.

InfoProviderThis Year DateLast Year DateThis Year SalesLast Year Sales
InfoCubeThis Year DateLast Year DateSales Figure
InfoSet (Last Year)Next Year DateThis Year DateSales Figure

Explanation:

In order to get the Last Year Sales figures from the InfoSet the "This Year Date" should be assigned to the Next Year Date InfoObject in the InfoSet and "Last Year Date" should be assigned to the This Year Date InfoObject in the InfoSet. In this manner we are able to read the Last Year Sales Figure without duplication the data in another InfoCube.

I hope my explanation of the above is details enough and clear for your understanding.

Best Regards

David Yee

Labels in this area