Input form for asset transaction data

[Former Member]

Hi SAP EPM experts,

I have the below senario for Fixed asset transaction data.

My Asset master is as below

ID	Description	ASSET CLASS	COSTCENRTER	DEPKEY	DEP_AREA	ENTITY	EXPERIED LIFE	LOCATION	Scaling	USEFUL LIFE	WBS	PARENTH1
1000	Funiture
1001	Table	1000	10	SLM	1	CA	1	CA	N	10	NA	1000
1002	Chairs	1000	11	SLM	1	FR	2	FR	N	15	NA	1000
1003	Desks	1000	10	WDV	1	DE	1	DE	N	10	NA	1000
2000	Land
2001	India land	2000	12	WDV	1	US	4	US	N	25	NA	2000
2002	US land	2000	15	SLM	1	CA	2	CA	N	30	NA	2000
2003	German Land	2000	10	SLM	1	IN	5	IN	N	20	NA	2000

Now i want to input transaction data using Input form.

I want to have some link so that i can input data to Asset 1001 - table only to Cost Center10.

I have tried to create an Input form with Row as Asset number and colum to have Gl account with combination of Cost Center and Movement.

Input Form created with my GL accounts for Every Cost Ceter and movement for each asset i.e

For Asset 1001 table.

APC FURNITURE
COSTCENTER 10			COSTCENTER 11			COSTCENTER 12
Opening balance	Increase	Decrease	Opening balance	Increase	Decrease	Opening balance	Increase	Decrease

I want to have Input Form to have only Asset with the Relevant Cost Center link?

APC FURNITURE
COSTCENTER 10
Opening balance	Increase	Decrease

How can this be achived?

Regards,

Tej

.

[Former Member · Accepted solution]

hi Tej,

I would suggest you to have Asset and Cost Center in rows. In that case you can get required Assets and to get the Cost Centers linking to that perticular Asset, you can use Dimension Property in Selection Relatioship of Cost Center Member Selector.

For Cost center select - Selection Relatioship as Dimension property , under Dimension property select Asset dimension and Costcenter property. it will get Cost Center linked to the particular Asset

Regards,

Shalini

[Former Member · Accepted solution]

Hi Shalini,

Thanks for the quick response and solution. The solution given by you worked thanks for that. One more doubt, if i kept cost center in the Coloum and use the settings specified by you, then BPC is not getting the correct result?

We must create dimensions as ROWS if we want to use Dimension property for look up like the above one?

Regards,

Ravi Tej

[Former Member · Accepted solution]

hi Tej,

You can use it in columns as well. In that case Asset also should be in Column as Costcenter is linking to the Asset.

i.e. when using Dimnesion property relationship both the dimensions should be in rows or columns

Regards,

Shalini

[Former Member · Accepted solution]

Hi Shalini,

How to handle the same in BPC 7.5 version.

I dont see the similar option of Dimension propoerty in 7.5 all i can view are Member proporty of the Dimension.

Could you please help me in this too.

Regards,

Ravi Tej

[Former Member · Accepted solution]

hi Tej,

I wanted to tell you one more option in 10.0 itself.

if you want Costcenter in column itself then try this option:

Using EPMMemberProperty get the Costcenter property of selected Asset in a cell.

Use EPMdimensionOverride to get members of Costcenter.

Ex: EPMMemberproperty(,"Asset","CostCenter")  --> say this in cell A1

      EPMDimensionOverride("000","Costcenter",$A$1)

Regards,

Shalini

[Former Member · Accepted solution]

hi Tej,

I would help you get soultion in 7.5 as well. Just clarify me one thing you are getting one Asset at a time and Asset would be selection or in context right?

Regards,

Shalini

[Former Member · Accepted solution]

hi Tej,

I am not sure whether there is equivalent to Dimension property in 7.5.

You can try this option in 7.5 if you are getting one Asset at a time:

In 7.5 take Asset and Costcenter. You can take both Dimension in rows/ Columns or Asset in row and Costcenter in column.

In a cell get costcenter property of selected Asset using EVPRO(,"1001","Costcenter") - Say this is in cell E10 and "1001" is selected Asset ID.

then in memberset of Costcenter use =E10 (reference of the EVPRO cell)

or else directly write EVPRO(,B10,"Costcenter") in memberset of costcenter. here B10 would be Memberset cell Asset .

Regards,

Shalini

[Former Member · Accepted solution]

hi Tej,

In the example of EPMMemberProperty above Asset is selected AssetId. Instead of writing the AssetID you can refer to the cell where Asset is selected.

Ex: EPMMemberproperty(,"Asset","CostCenter")  --> say this in cell A1

      EPMDimensionOverride("000","Costcenter",$A$1)

Regards,

Shalini

[Former Member · Accepted solution]

Hi Shalini,

Thanks for the inputs, it worked, only thing is i have to use this EVPRO bseides every asset number and not in the EVDRE members range area.

7.5 BPC is complex and have to change alot even after applying the formulae regarding the Evdre cell range selections.

Thanks for the help.

Regards,

Ravi Tej