Hi

[Former Member]

Hi,

I have a requirement, wherein the client has given his requirements in a excel file, to form one shhet it is

depending on other sheet. Ex.: to form Salaries & Wages, the data has to bring data from another sheet

called Manning, so they have given with sheet reference and cell refernces. All most all his requirments

are in the same fashion. So How do we do in BPC.

Thye have also given some paramenters and with their values to form one sheet. Ex.: Salary per hour,

Working hours of a Machine... etc.,we have to calculate lot of things to form a sheet. In this do we require

to open so many application like Rate? Please do help me in this regard.

[Former Member · Accepted solution]

well i feel your pain.. my customer wants the same in report costing and so on. but practically if they do not need that value exist in audit and just reporting purposes i rather create manually excel calculation for perKg, PerHour, PerDay and so on.

and some other i made evsnd and logic script. looks cumbersome ya!! but i don't have any idea.. : )

hope helps

[Former Member]

Our company uses some complex reports and financial statements that use a lot of cell referencing. It is a combination of EVGTS() within the EVDRE. With EVGTS you can easily specify Applications and the desired values you wish to retrieve. If you embed these EVGTS in a EVDRE, as long as the row & column keys are properly mapped, you will be able to get your desired results.

The only problem you might face is when you have a dynamic report (which expands either Rows or Cols or both) and you want to reference to another sheet. Cell referencing during the expansion may get mixed up and end up referencing to the wrong cells.

Hope this helps.

Brian