Skip to Content
0
Former Member
Sep 28, 2005 at 03:21 PM

Executing the planning function while opening the web interface

22 Views

hello all,

I have created a planning area based on multiprovider.This multiprovider is based on two transactional cube ie,COPA cube and Cost Center cube.

This planning area is meant for enabling integrated planning.One plans in COPA cube and other plans in Cost Center cube the income statement gets planned based on this two.

I selected planning items in multiprovider layout to display the income statement.The layout is as follows:

<b>PlanningItem</b> <b>Amount</b>

Net Sales<b>:</b> 9.000,00 INR (This comes from COPA)

Sales Overheads<b>:</b> 200,00 INR (This comes from Cost Center)

Depreciation<b>:</b> 200,00 INR (This comes from Cost Center)

Other Expenses<b>:</b> 300,00 INR (This comes from Cost Center)

EBIT<b>:</b> 0,00 INR

Interest Income<b>:</b> 0,00 INR

Interest Expense<b>:</b> 0,00 INR

Operating Income<b>:</b> 0,00 INR

Taxes<b>:</b> 0,00 INR

Now EBIT planning item is to be calculated from the planning items as follows:

EBIT = Net Sales-Sales Overheads-Depriciation-Other Expenses

For this i have created a planning function which calculates EBIT.This function works properly,there are no issues in it.

My problem is that i want this function to be executed as soon as i open the web interface for my planning application and the result should be as follows:

<b>PlanningItem</b> <b>Amount</b>

Net Sales<b>:</b> 9.000,00 INR (This comes from COPA)

Sales Overheads<b>:</b> 200,00 INR (This comes from Cost Center)

Depreciation<b>:</b> 200,00 INR (This comes from Cost Center)

Other Expenses<b>:</b> 300,00 INR (This comes from Cost Center)

EBIT<b>:</b> 8.300,00 INR

Interest Income<b>:</b> 0,00 INR

Interest Expense<b>:</b> 0,00 INR

Operating Income<b>:</b> 0,00 INR

Taxes<b>:</b> 0,00 INR

Can anybody suggest how to go about this problem?

Thanks in advance.

regards,

Yogesh