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