cancel
Showing results for 
Search instead for 
Did you mean: 

Select Distinct on an object based on BEX created Universe

Former Member
0 Kudos

is this possible:

<expression>DISTINCT(@Select(Contacts\L01 Contact Type (Name))</expression>

Instead of listing all the values, I would like the object to return just distinct values.

I have seen a forum entry that mentions the use of Navigational attributes? how can this be done.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

MariannevL
Advisor
Advisor
0 Kudos

Bad news: No it is not possible, since expressions have to be numeric.

Good news: When this is an infoobject in its own right (LEVEL01, blue object when generated),

as soon as you combine it with keyfigure, the distinct (or rather group by) is implicit (assuming there is a standard aggregation in place like sum for that keyfigure). As query dimension BW will calculate the keyfigure results for each value of the infoobject.

Now about the navigational attributes.

Normal attributes can have duplication, like contact type can be an attribute of contact (green detail object when generated).

When you use such an attribute in the query BW will still aggregate on a contact level.

But if that attribute is a navigational attribute and you put that in the query on its own, it will get a blue version and BW will aggregate on that contact type level.

Needless to say you do need to use the blue version and not the green in the query, or the behavior will still be the same.

Good luck,

Marianne

Answers (0)