Focal Point
Brkout

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/4641061062

December 04, 2007, 02:16 PM
Janice
Brkout
What is the funtion of "Brkout" on a gadget options window window.


WF 8.09
December 04, 2007, 03:15 PM
Michael Paul
Hi Janice,

If you hover over “Brkout” you should notice it says “Breakout Lower Level Duplicates.”

When grouping on a dimension and you specify to group on a lower dimension level there might be duplicate possibilities for that lower level dimension.

For example let’s say for the Location dimension we have the below dimensional values stored. Notice that location level 3 has “Audio Expert” stored multiple times. If we tell the gadget to group on Location level 3 and we do not add location filters it will group and retrieve the values together in one record from both EAST/BOS/Audio Expert and MIDWEST/STL/Audio Expert. Basically you will get a high / mid / low score based on store Audio Expert regardless of the higher dimensional levels.

Location level 1 Location level 2 Location Level 3
EAST BOS Audio Expert
MIDWEST STL Audio Expert

The default functionality for gadgets is to combine the lower level duplicates for gadgets if no filters are applied.

Notice that the functionality to automatically “Brkout” lower level dimensions is disabled. We are working to implement this feature in a future release.

Brgds,
Mike
December 04, 2007, 03:32 PM
Janice
Great. I look forward to being able to use it. Thanks for the explanation.


WF 8.09