Modify BW infoobject related to a property of a dimension in BPC

[Former Member]

Hi experts,

We are on BPC 10.1 (standard) and BW 7.5 reporting over BPC cube with a BEx query.

There is a reporting requirement to have multilingual texts on the property values of a dimension.

Our approach is to modify the BW infoobject related to the property of the dimension activating the flag for the texts loading the descriptions in BW infoobject.

We have tested to create members with values in the property, lite and full optimize, adding new properties to the dimension and planing data. Everything worked fine. The only problem we found is when modifying the property in BPC, we loose the modification in the infoobject for the text flag.

Does anybody done something similar to this? Any other implications?

Do you know another way to have texts on dimension properties?

Thanks and Regards,

Abraham.

[Former Member]

Hi Abraham,

This modification is not going to be transported with BPC transports.

Regards,

Gersh

[Former Member]

Hi Gersh,

We can move that modification with a BW transport after BPC transport.

[Former Member]

Yes, that's possible. Just mentioned it because customers often forget non-BPC transports. Same thing with UJBR.

Approach Vadim suggested is most commonly used. How to show those additional properties based on language selected depends on how you report on the cube: directly, using MultiProvider, VirtualProvider, build some custom cube on top of those.

Regards,

Gersh

[former_member186338]

"Our approach is to modify the BW infoobject related to the property of the dimension activating the flag for the texts loading the descriptions in BW infoobject." - Please, do not modify BPC opjects in BW! A lot of side effects! Not supported...

[former_member186338]

P.S. The only thing that can be done - multiple properties!

[Former Member]

Hi Vadim,

When you say multiple properties, you mean to have one property for de ID and another one for the description?

How can I manage multiple languages?

[former_member186338]

Not clear!

Descriptions are multilanguage in BPC...

Please explain what you want to achieve!

[Former Member]

Hi Vadim,

I am talking about descriptions of the dimensions/properties values.

We have one dimension for the material and that dimension has the material type as a property.

There is a description for each material that we load from BW. But for each material type we don't have any description available as it is a property.

[former_member186338]

How many material types you have?

[Former Member]

Not only for material types, we have to do this for some properties.

In some cases the property can have more than 300 different values and we need their descriptions in 6 different languages,

[former_member186338]

Sorry but BPC do not support your case

You may use Idea Place to ask for functional improvement....

[Former Member]

My understanding that author doesn't want to run those reports in BPC - he wants to use BW for that.

I'd think that this is possible using either approach. It looks like the question here is which approach is less intrusive.

[Former Member]

hi Abraham,

So you are actually modifying the infoobject which is created in the backend when we create a property in BPC frontend???

Could you please share the screenshots for more clarity?

Regards,

JP