Skip to Content
avatar image
Former Member

Compounded object Input Control - duplicated texts

Hi all,

I know that there are many posts discussing about Compounded objects behavious in Web Intelligence, but I haven't found any talking about how description works for those Compounded objects.

Amongst posts and articles read but not useful for my issue:

BI4 SP5: All you need to know about compounded objects

How to get rid of compounded keys on WebI report | SCN

I have a Compounded Object in a Webi report, I can easily get the not compounded key as BO already provides it. However, I need to use this Compounded Object as an Input Control, showing the description, and the problem is that values are duplicated.

For example.

Description:     Key:     NotComp key:

Product          INT/001     001

Pack              INT/002     002

Service          INT/003     003

Product          EXT/001     001

Box               EXT/002     002

Service          EXT/003     003

In my Input Control should appear:

Product

Pack

Box

Service

However, I see:

Product

Product

Pack

Box

Service

Service

Do you know how to proceed?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 29, 2015 at 08:29 AM

    Hi,

    I couldn't still find anything related in any forum or blog about duplicated compounded objects texts behaviour in webi, but with some colleague help, we could solve it.

    How did we solve it?

    1. Create a new variable concatenating "Dimension (not compounded key) + Dimension (text)"

    2. Create a second variable substrating from first variable the (not compounded key).

    And done!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2015 at 10:07 AM

    Hi,

    Alberto,

    Sure above my links help you.....

    Kindly check out this....

    Remove compound characteristic from Analysis an... | SCN

    Removing Compounded objects from Web Intelligence report

    try,

    bexbrain.com .....

    Add comment
    10|10000 characters needed characters exceeded