Skip to Content
0
Former Member
Jun 04, 2008 at 01:47 PM

How can i read Value(Actual) from another Planning area..

17 Views

Hi Experts,

I am facing problem when i ahow to read the values from actual area(actual values).

My req is like i have two planning areas as follows..

1 Basic Cube Planning area.(Actual)

2.Transactional cube planning area(Plan).

I created Multi-planning area from above two planning areas.

I have a Actual value in Basic Planning area (i created a layout and i restricted planning area - actual).

now i want to distribute actual value in to second planning area(i created a layout and i restricted planning area - Plan).

As per my req i am using two layouts because i have some other fields also client don't want on same layout actual and plan,they need different layouts.

How can i read Actual value here i am using Fox code to distribute the values.

Ex: I have a week1 actual value $7000.

dayUsing fox code distribute above value to my week days

day1 day2 day3 day4 day5 day6 day7 total

$1000 $1000 $1000 $1000 $1000 $1000 $1000 $7000.

and also i have to check actual value and sum of week days value should be equal if greater i have to pass error message(how can i??).

here i created dynamic layout for week days.

Can your share ideas and if you have sample code also please

I'll assign full points ....

Thanks.