Dimension update

[former_member229754]

Hi Experts,

I got a situation.

Entity, Property

- Paris, PA

-

Product,Property

- ProductA, PR1

- ProductB, PR2

CostCenter

- Costcenter Hierarchy, with members like PA_PR1 and PA_PR2, can use a context simple

Report level

- Row: Product Hierarchy and CostCenter (member only)

- Column: Time

Requirement.

I would like to store the Costcenter where it is concatenation between property of entity and product.

for example

If entity is Paris, so I get the property PA and concatenate the Property of Product: PR* for system  fill automatically the CostCenter

for example

Product, CostCenter, Time

ProductA, PA_PR1, 2010.10

ProductB, PA_PR2, 2010.10

The CostCenter should be dynamic based on concatenation of both property.enev

In another words, whenever I submit the records (or before, better ), the Costcenter value should be generated based on both propertys

Any clues how to achieve this in EPM Reporting? or do I need to do BadI or Script logic.

Thanks

Regards,

[Former Member · Accepted solution]

Hi Pheno,

When you submit data from EPM input sheet you have to select a cost center, you can have a validation in place to check if the cost center is the combination of product and entity's property.

You can use EPM formulas and excel formulas to warn user if they select the incorrect cost center for the selected entity and product before saving data,

or

you can modify the write back BADI to change the cost center to the combination of the properties of product and entity, and ignore whatever the user has selected from EPM.

Andy

[former_member229754 · Accepted solution]

Hi Andy,

Thanks a lot.

No, I don't want the user see the costcenter, I just want it be filled automatically based in both propertys.. It is going to be like a hidden column.

So it is still can be done using EPM Reporting?

I'm not that familiar doing in BadI.

Thanks.

Regards,

[Former Member · Accepted solution]

Hi Pheno,

yes, that is possible, you need to use cost center in the page axis, point the page axis to a cell, in the that cell use excel formula to derive the cost center from entity and product properties.

Andy

[cecilia_petersson2]

Hi Pheno,

If your products don't change, you can achieve this with a static report. If products are dynamic, I'm not sure if it's doable.

/Cecilia

[former_member186338]

Yes, dynamic input form will not work due to concatenation requirement. Unfortunately topic author do not describe how the input form will be prepared or changed by user.

Vadim

[former_member229754]

Hi Vadim/Cecilia,

Thanks for your input,  much appreciated

The Product is based from Hierarchy and it is dynamic.

What about the solution from Andy? It might work?

Else we can do in Script/BAdI.

Correct?

Dank

[former_member186338]

"The Product is based from Hierarchy and it is dynamic."

What do you mean - it's dynamic? How it will be changed? etc...

You are not describing users data entry process... I can't help you!

Vadim

P.S. Script/badi is also not a good option...

[former_member229754]

Hi.

Let me explain.

When I say dynamic its means it can be expanded with nodes below

When a user open an input template, it shows:

Row Level:

- Product (Hierarchy): ProductGRP1 (ProductA, ProductB) ProductGRP2 (ProductC, PRoductD) for example

- Cost Center (hidden)- base level)

Column

- Time

The Costcenter in row Level can be optional since I need that for "Store" initially (if possible) else, i can remove if we call a badi/logic script to fill it with the logic

Please find attached with two Hypoteses

Hypoteses I - With cost Center in input template

Hypoteses II - Without Cost Center input in input template

Achieve at the end.

Note: in Step2, if the users does not input data for example for ProductB, its optional that CostCenter get filled or not, because it only store data in the cube when the values is inputted

Thanks

Regards,

[former_member186338]

Sorry, but I don't see Entity...

"When I say dynamic its means it can be expanded with nodes below" - not clear!

It's a common practice that user receives a fixed template...

Vadim

P.S. It looks a bit theoretical...

[former_member186338]

P.S. By the way, what is the reason to have product CostCenters individual for each entity? Why not to have CostCenter per product group only? Anyway each figure on the CostCenter will have some Entity...

[former_member229754]

This is more complicated than that.

I'm just trying to explain more standard possible, else you going to be more confused.

When I say dynamic is where the users have capacity to expand and collapse the hierarchy.

For me static its some order will never change (fixed) like BEx Structure.

Entity is coming from the Context.

Costcenter = Contacate (Entity.Property & "_" & Product.Property)

Costcenter  = concatenaton (PA & PR1)

Costcenter = PA_PR1

finally

Product - Costcenter - value

ProductA - PA_PR1 - 15

Simple (or not that )

Thanks again

Regards,

[former_member186338]

Please answer my second post...

[former_member229754]

The Product Hierarchy got 5 Levels.

BusinessLevel1, BusinessLevel2,ProductGroup,SubProductGroup, Product (base level)

Client want to see whole products after BusinessLevel1.

The costcenter are concatenaed by the Product_Group-Product_SubGroup-Location

Costcenter_Level_1 = Product_Hierarchy_Level_1

Entity is something I created manually with: BusinessLevel1_Location, having the attribute Location

so whenever i have a product and want to apply to that costcenter automatically

I need to read the Location from the entity and concatenate with the Product/SubProductgroup (which is a property of the Product)

The entity is fixed in the template.

Let's say this is BL1_Paris, with PA as attirbute

Sorry, its bit difficult to explain.

(sorry difficult answer ur question, i'm kinda new in BPC)

[former_member186338]

Yes, I am unable to understand "Entity is something I created manually with: BusinessLevel1_Location"

Do you have Entity dimension?

What are the members? What is the business value?

Why you need to concatenate?

I want to have the explanation from the business point of view, not related to BPC directly...

Product hierarchy is also unclear... To have in one dimension both geography and product type?

Vadim

[former_member229754]

Hello Vadim,

Its bit complicated to explain to you everything, because it is too many things connected, it would take like 1 day to explain or more.

Product Hierarchy is a normal product hierarchy.

No problem here.

All I want is to write in CostCenter dimension the concatenation of product property and the entity property, then input a value/cost

This can CostCenter can be "calculated" in EPM template or when it submiting. User do not need to see that...its something which have to run in background.

Thanks.

Regards,

[former_member186338]

I don't see any "complicated" things - just no business case explanation...

You can't do a lot in EPM template!

You can save data to some dummy cost center and then using default.lgf you can move this data from dummy cost center to the real one.

Or you can use write back badi  to do the same even without dummy member.

But in the input form the saved value will disappear!

Vadim

P.S. BPC is not a ERP system

[former_member186338]

And you can try to play with local member with EPMSaveData in the input form. Actually you will not use EPM input form, the data will be saved by EPMSaveData.

Vadim

[former_member229754]

Thanks a lot

Please find a schema for you understand better.

Thanks a lot

Regards,

[former_member186338]

Sorry, but you are still trying to explain something theoretical instead of real business sample...