Input data to the cell within calculating row

[Former Member]

Hello, experts,

I'm building Input Schedule using EVDRE functrion, account dimension in rows and user-defined dimension in columns. I use formula for calculating account dimension members, for both parent and child. How can i make the cell as editable in child member in my input schedule? That is, with three columns for example, two cells are calculated with formula and the third i want to be editable, to input data.

Thanks.

[sorin_radulescu]

This is not possible but I can provide a trick how to achieve this.

To achieve your idea you have to use another account C_INP

I don't know what means for you column fact and plan but I suppose it represent category.

this C_INP will be base member and not calculate.

The C account it will be calculate like:

If Category = plan then C = A+B

If Category = fact then C = C_INP

so always the value of C will be good but actually the insert will be done into C_INP.

I hope this will help you to create your report with right calculation.

Regards

Sorin radulescu

[Former Member]

Hi Sorin, thanks for your suggestion! I guess it would be helpful

[sorin_radulescu]

This is not possible but I can provide a trick how to achieve this.

To achieve your idea you have to use another account C_INP

I don't know what means for you column fact and plan but I suppose it represent category.

this C_INP will be base member and not calculate.

The C account it will be calculate like:

If Category = plan then C = A+B

If Category = fact then C = C_INP

so always the value of C will be good but actually the insert will be done into C_INP.

I hope this will help you to create your report with right calculation.

Regards

Sorin radulescu

[Former Member]

Hi,

You need to make use of the format range in EVDRE template.

Somewhere towards the bottom, design the format options for your EVDRE. Use 6 columns. The structure should be something like following.

CRITERIA                 EVALUATE IN          FORMAT                               USE         PARAMETERS              APPLY TO

Default                                       keep the cell unlocked                                                   DATA

Mention the                COL                keep the cell locked                                                     DATA
criteria based 
on some 
property
(ex: dimension.CALC = "Y")

Refer to these cells in you format range of EVDRE.

Hope this helps you to understand.

Edited by: nilanjan chatterjee on Dec 10, 2009 8:39 AM

[Former Member]

I tried using Format options but it does not allow me to save data to calculated member. The problem is how to switch CALC property in account member (which is calculating in FORMULA property) from "Y" to "N" in proper cell in order to input and save data?

[Former Member]

Hi Maksim,

I am sorry. May be I misunderstood your query.

We cant post data to a member for which CALC is set to Y. It will create discrepencies. The reason behind it is:

When a member is set to CALC = Y, this member is calculated on the fly and the result is not stored in the database table. However, when we send data from input schedules, the data gets posted in the table. So, this will create a discrepency. If we try to process an application, and if there is any member in the table for which the calc is y, it will throw an error, and we cannot proceed any further. This means that we cannot send data to a member until that member has calc = n.

So, my suggestion would be, if you want to send data to this member, then you need to make it a child member.

Hope this helps.

[Former Member]

Thanks for your answers, Nilanjan. I'll try to explain more exactly. For example, we have three account memebers A,B and C (they do not belong to a parent, child members). And another dimension is in column, user defined, with two members: Plan and Fact. Account C is calculating as Account A + Account B.This formula is written in Formula property in Account dimension. So Account C is calculating row.

In Input Schedule built with EVDRE i want that Account C in Plan column will be calcucated cell but in Fact column it should be input cell. So is there any solutions to get it?

[Former Member]

Hi Maksim,

I am afraid, this is not possible.

Once you write a dimension formula for a member in the dimension sheet, the CALC property for this member becomes Y. The data cannot be posted to any member for which CALC = Y.

CALC propery becomes Y in 2 cases - one is when the member is parent member, second is when the member has a formula. CALC is N only for a child member. Data can be posted only to those members for which CALC = N. This is the reason, I am suggesting you to make the member a child member. Otherwise, the data can not be posted to this member.

Hope this helps.

[Former Member]

Ok, thanks for your suggestion, Nilanjan