Back up cube for report from planning area

[former_member309586]

Hi Gurus,

We are in implementation and i had seen that client wanted to see daily data and wanted to delete that data and load next day data.One more point is client even wanted monthly data as well in a same cube and this two facilities should be in single info cube.

How is is possible?

for further info we have calday and calmonth time Chart.

please suggest me some good ideas.

I will be verythankfull to your suggestions.

Thanks a Lot

Regards,

Raj

[Former Member · Accepted solution]

Hi Raj,

I want to help out but i have a couple of questions.

When you say "daily data" do you mean that data should in daily buckets or do you mean that the user wants to see the most recent data as of today? Same question goes for "monthly data"..do they want the data in monthly buckets or they just want to the view of data to be limited to the current month?

Also, where is this data coming from? Does it come from R/3 or APO?

Please clarify and i will try to help out

[former_member309586 · Accepted solution]

Hi Emmanuel,

You are correct

1,Users wanted most recent data and we have monthly buckets & monthly data as well.

2.data is getting from APO

It will be really great help

Thanks a Lot

Regards,

Raj

[Former Member · Accepted solution]

Hi Raj,

You can use SAP BW to create reports for the user. You have the option of using an external BW system or the BW system that is coupled with the APO server. If you have an external BW system, then it is recommended that you report from there. As you may know APO is an OLTP system and thus is configured for such. The external BW system will be configured for OLAP access and thus would be much more suitable for reporting purposes.

You may want create a SAP RemoteCube so that the data in your report is "as fresh as possible".

Here are the steps if you will be using the BW component in the APO system:

1) Create an export datasource for your planning area. (Transaction /n/SAPAPO/SDP_EXTR)

2) Create an InfoSource and attach the datasource your have created in step 1. (transaction RSA1 Modelling tab)

3) Create a SAP RemoteCube and attach your InfoSource and SourceSystem to that.

4) Create a BeX query and a BeX report (either in Web or Excel).

If you will be using an external BW system here are the steps:

1) Create an export datasource for your planning area in the APO system (Transaction /n/SAPAPO/SDP_EXTR)

In the external BW system:

2)replicate the datasource your have created.(transaction RSA1, Modelling tab, sourcesystems->choose the APO system->Right click->Replicate DataSources).

3) Create an InfoSource and attach the datasource that you have created in step 2. (transaction RSA1 Modelling tab)

3) Create a SAP RemoteCube and attach your InfoSource and SourceSystem to that.

4) Create a BeX query and a BeX report (either in Web or Excel).

Note that a RemoteCube is only suitable for few users only. If you will have many users, you need to create a Basic InfoCube instead.

In your BeX query, you can choose the granularity of your report. If you want your report to be aggregated to monthly level then be sure to include the 0CALMONTH InfoObject.

Please post again if things are not clear and I will be happy to help out.

[former_member309586 · Accepted solution]

Hi Emmanuel,

Thanks for your answer.

1,If the Users wanted to see the recently changed data (in APO) and wanted to see in reports in BW,How can that be possible (i.e Daily)?

2.For daily changes we had kept CALDAY in the cube and what to do next.Please help me .Do we need to create separate cube (Reporting cube) for daily changes ?

I will be very thankful to you.

Thanks a Lot

Regards,

Raj