Steps to plan and save data in Workbook

[Former Member]

Hi all,

Please provide me steps to Plan and save a data in a real time cube using workbook.

I have gone through different articles in SDN and tried to relicate but failed to save the data.

May be I am missing some thing, some steps. Please provide me with steps as giving links will not help me.

Thanks

Sunny

[Former Member]

Hi,

You will have to follow the below steps to create a workbook which can save data in realtime cube.

1. First create Aggregation level(mandatory for input ready query which can save data) in Planning Modeler.

Aggregation level you will have to create on Reatime cube.

Transaction code for Planning modeler is RSPLAN.

2. After you have created aggregation level .

-> Create Query in Query Designer on the Aggregation level.

3. Make sure that you have made the setting for keyfigure as Input-ready.

Also make sure to make you have set the Query Property as 'Start Query in Change mode".

-> Then only query will be eligible for entering and saving the data on execution.

4. Now when you execute the query in Bex Analyser and save it as Workbook.

-> Data can only be entered and saved when the query open in input-ready mode.

5. The best way to check in Bex analyser whether query is input-ready or not is

-> In the query result layout , use Right lcik of Mouse -> then in the context menu

-> you should see the following two options apart from other options

Two options are:

1. Transfer plan values

2. Save values

If you get these two options then query is input ready and you can enter data and save it in realtime cube using the

Right mouse click -> Save values

6. If query is not coming as input-ready then it means that not all charateristics are drilled down

-> means that rows does not contains unique records.

In that case you will have to drilldown to make each rows contain unique records.

-> The best way is to restrict the characteristics with variable or single values in filter area.

-> this will give you drilldown data and so the query will come as input-ready.

Pls also check the link:

http://help.sap.com/saphelp_nw70/helpdata/en/43/f234619e3c4c5de10000000a155369/frameset.htm

Regards,

Amit

[lucimar_moresco]

Hi Sunny

First you have to create an input ready, then open the input ready query with the bex analyzer, create buttons to save and transfer values. To create the buttons, you can use the wizard and choose planning commands. After these steps, just save that as workbook.

You will see the light blue border in the input ready cells.

Let me know if you need more help.

Best regards

Lucimar