Compounding Issue

[former_member197527]

Hi,

We have an object named "Product"

It got a compounding as group meant for hierarchy.

However in reports, values coming as group/product, which is expected.

But Client doesn't want the same and he needs only product display.

Eg: Nylon instead of CR01/Nylon in the report

Any suggestions?

[KodandaPani_KV · Accepted solution]

Hi aditya,

select the product object in rows level then display as Text, it will work.

meanwhile refer the below document.

Raman document

Thanks,

Phani

[former_member197527 · Accepted solution]

If I add group in rows and do a no display then value comes as Nylon, its giving authorization issue (Group is authorization relevant and has value authorizations)

If I remove the same, then user has proper access but the compounded value comes as CR01/Nylon

[former_member197527]

If I add group in rows and do a no display then value comes as Nylon, its giving authorization issue (Group is authorization relevant and has value authorizations)

If I remove the same, then user has proper access but the compounded value comes as CR01/Nylon

User needs authorization along with this requirement satisfied

[berno]

Hi Sai

try to restrict the "group" in the filter using an authorization variable. The user will only see the group/products that he is authorized for. Put the product in the rows.

regards

[former_member197527]

HI Berno,

Issue is both the compounding and Authorization as both are interlinked.

Please see my previous reply

[MGrob]

HI

Make sure your users has the ":" access right on the product group in order to work for your requirement. This is the aggregated view

hope that helps
Martin

[Former Member]

Hi Sai,

Restrict the Compound characteristic with CR01 in the dynamic filter. Then you will get only Nylon instead of CR01/Nylon in the report.

Thanks,

Purushotham.

[former_member197527]

Didn't get exactly regarding dynamic filter?

[RamanKorrapati]

hi sai,

if you searched from google you may get my doc. always search before posting.

Search on google by using "How to hide compounding object from bex display".

Thanks

[former_member229708]

This message was moderated.

[former_member186399]

Dear Aditya

You can do a work around to do this.

Add Group in the rows of the report (above Product) and make it to No Display. Also for Product keep the display option as Key.

Regards

Gajesh

[former_member197527]

Hi Gajesh,

Already tried the same, but the issue is little tricky.

If I add group in rows and do a no display then value comes as Nylon, its giving authorization issue (Group is authorization relevant and has value authorizations)

If I remove the same, then user has proper access but the compounded value comes as CR01/Nylon

Not sure whats going on here. Product needs to be in rows though.

[former_member186399]

Dear Aditya

If the Group field is authorisation relevant then you have to make sure that this field is available as part of input selection of the report. If the user is authorised for multiple Groups, allow a variable which allows multiple selection

Regards

Gajesh

[former_member197527]

Hi Gajesh,

Yes Group is authorization relevant.

Product is the infoobject, to which the product hierarchy is added.