Copy from high level charac to low level charac

[Former Member]

The user enters data at a high level Charac A for a Key figure KF1.

i.e.,

Charac A --- KF1 values

A1 --- 10%

A2 --- 15%

A3 -

---

20%

Values for lower level charac ( charac B and Charac C) will #. The problem is that I need to copy this to low level charac and not distribute.

I need to copy the KF value to low level charac i.e

Charc A---Charac B---Charac C-KF1

A1--

---

B1

---

C1--

---

10%

A2--

---

B2

---

C2--

---

10%

A3--

---

B3

---

C2--

---

10%

I cannot use copy / distribute function as the values of charac B charac C should be determined at runtime hence I will have to use Fox formula.

The following code does not work.

FOREACH charac A.

PENPCT = {KF1,#,#,#}.

FOREACH Charac B.

FOREACH Charac C.

{KF1,Charac C, Charac B, Charac C} = PENPCT.

ENDFOR.

ENDFOR.

ENDFOR.

It is not able to read / assign values of charac B and charac C.

Would appreciate any help on the above.

Regards,

Raghu

[Former Member · Accepted solution]

Hi Raghu,

The reason it does not post to the lower level charicteristics in your example is because the FOREACH statment will only loop through records where data exists. If the combinations you wish to post to have values, make sure your planning level includes those values. If you need to generate new rows you will need to use varibles that contain the values you want and a do loop.

Mike.

[Former Member]

Thanks Mike.

Values for low level charac do exist in the cube. I'm not restricting the values in the planning level, So basically planning level should accept any value.

Have no idea whatz happening.

Let me try the 'do loop' option mentioned by you.

Master data for this low level charac is huge i.e around 200+. So I will have to create a exit variable and read the master data?

Raghu