Grouping Characteristic Values

[Former Member]

I want to group facilities into categories. Example:

Facilities A, D and F belong to 'Joe'.

Facilities B, C and E belong to 'Larry', All other Facilities are 'Unassigned'

I want to display on the report, who the facilities are assigned to.

In other reporting tools, I have used if..then statements.

How would this be done in BEx?

Can this be done with Variables?

[former_member188975 · Accepted solution]

Hi Jeff,

You can try to effect this by creating an attribute for Facilities (Belong to) or may be a hierarchy.

Or may be a characteristic structure in the query with selections for different facilities.

Hope this helps...

[Former Member · Accepted solution]

Hi Bhanu,

Thanks for the reply. We have used hierarchies, but the BEx user can't build new hierarchies. I was looking for an easy way for the BEx user to put the facilities into categories. Could you give some more detail about what a characteristic structure is?

[former_member188975 · Accepted solution]

Hi Jeff,

Using the char structure, you can create selections for chars, like Selection1 (Joe)= facility A, B and C, Selection2 (Larry) = facility D, E and F. But again this is something that needs to be set up in the query definition and is not at all flexible...

[Former Member · Accepted solution]

Bhanu,

When we use structure, Can it be OR ed also ? I mean either A,B or C = Joe ?

Dave Bret