I have a plan on Material and Plant level in a planning cube

[Former Member]

Hi Gurus,

Thanks in advance...

I have a plan on Material and Plant level in a planning cube and I have actuals on Material plant and storage location level in actual cube I want to have a plan actual comparison in a query which has storage location how you will design that ...?

Thanks,

Venkat

[Former Member · Accepted solution]

Hi Venkat,

You can create a multiprovider on plan and actual cube.Then You can create query on this multiprovider,even in query you can restrict Storage location with both # and some value.

Rgds,

Indu

[Former Member · Accepted solution]

Hi Indu,

Thanks for your info....

Okay, creation multiprovider, and creation on query on multiprovider , But we you restict the storage location because of we have strorage location only on actual cube,

can u give me some more info on this...

your answer is helpful answer for me, thatz why givem helpful points to u..

Thanks,

Venkat

[Former Member]

thanks

[Former Member]

Please follow the following steps:

1. Schedule global planning sequences in ABAP Editor with

the UPC_BUNDLE_EXECUTE program

2. Select an existing planning sequence; local and global

sequences are listed together in alphabetical order

3. To run a particular global planning sequence, use variants

for the UPC_BUNDLE_EXECUTE program

4. To schedule the run, choose Program u2192 Execute in

Background and select an option:

a. Specified Date/Time

b. After job

c. After event

d. To define a job to run the defined variant, choose

System u2192 Services u2192 Jobs u2192 Define Job

5. To access log information via planning workbench (BPS0), choose Planning u2192 Planning Sequences u2192 Tools u2192 Logs

6. To include the job to run the global planning sequence in a process chain via BW u2192 Administration u2192 Process Chains

Please award points if it helps.

[Former Member]

Plan Cube: Material, Plant

Actual Cube: Material, Plant, Storage Location

If storage location is to be there in the query, Keep it in free characteristic, so when we run the query, will see both actual and plan. When we drilldown on storage location, we will see actuals corresponding to each storage location and plan corresponding to # storage location.

Or restrict the plan keyfigure to always storage location as # and keep the storage location in rows.

I guess this is just a report not input enabled query.

[Former Member]

Hi Bindu...

Thanks for you detail info on this, I given points to u.

Bindu do know How to schedule a global planning sequence in BW-BPS.

Thanks,

Venkat

[Former Member]

Hi Venkat,

You can restrict storage location in your query filter with # (not present in one cube -so the value wld be as good as #) and another values present in another cube.

Rgds,

Indu

[Former Member]

Hi Indu....

Thanks for you Gr8 Info on this....

I hope it will help me a lot, Let me try to design as per your view Okie.

Indu... Do you know How to schedule a global planning sequence in BW-BPS

I given Very Helpful Points to You....

Thanks,

Venkat.