Grouping objects in BO Designer

building semantic layer
1

Hi

I have a problem that i want to solve in Universe Designer.

I have object A, B and C and I want to create a new demension object that contains A, B and C. So if i call the new object Catagory and use it f.e.x with count i want it to display
Catagory Count
A – 10
B – 15
C – 30

Sorry if the is a dumb question but i tried ti search for solution but didn’t quite know what to look for.

atlih (BOB member since 2009-03-03)

2

No idea how you want to group those 3 objects in one single object and still want to show it as A, B & C with their count
Give more details on what you have and expected result
.

haider :es: (BOB member since 2005-07-18)

3

Sounds like your mixing up the definition of an object and the object values.
Looks to me like you want a CASE statement that counts the number of instances of the values A, B and C of an object.

dessa :madagascar: (BOB member since 2004-01-29)