Skip to Content
Author's profile photo Ingo Hilgefort

How to create a facet navigation in SAP BusinessObjects Design Studio ?

Did you ever wonder how to create a facet style navigation like in SAP BusinessObjects Explorer with SAP BusinessObjects Design Studio ?

Perhaps you were trying to create a set of cascading filter in Design Studio and had to create a set of scripting functions to do so ?

Well… there is a much easier solution, called a Facet Filter.

With our upcoming release of our Extensions for SAP BusinessObjects Design Studio these requirements can be fulfilled with a few clicks.

/wp-content/uploads/2015/12/facet_082_843810.jpg

So lets start with our Data source in Design Studio, which has several data sources and several measures.

/wp-content/uploads/2015/12/facet_080_843811.jpg

When I assign the data source to the Facet Filter component, I get the default layout with a Facet for the list of measures and a facet for each of the dimensions listed in the Initial View of the data source.

In addition all of the facets are shown as a list by default (we come back to that) and the selected measure value is shown next to each of the dimension members.

/wp-content/uploads/2015/12/facet_083_843842.jpg

So now lets take a look at the configuration options – here shown for the dimension Product Group.

First of all I can configure the height and width for each of the facets. I can then also configure the Display – which allows me to choose between the Key, Text, or Key and Text for the dimension members.

The Control property allows me to choose how I would like to visualize the list of members. I can choose between a List, Radio Buttons, Check Boxes, or Chosen.

/wp-content/uploads/2015/12/facet_084_843843.jpg

If we take a screenshot above:

– Key Figures are shown as Radio Buttons

– Product Group is shown as Check Boxes

– Product Category is shown as Radio Button

– Product is shown as “Chosen” – basically listing the selected items only

– Country is shown as a list

In addition you can configure the option to include a search option, include an All Member, and to enable or disable the display of the measure value.

Automatically the Facet Filter will work in a cascading fashion as you can see in the small video at the end.

All that is left to do is to enter the name of the target data source and my facet filter is ready to go.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Ingo,

      Having used Facets for many years I really am excited to try this one out. We use BW queries for data sources. Can you please expound on the performance of the Facet Filter item?  That is, is it like setFilter where a round trip occurs when used? If so, does that round trip occur on each click, or is there a way to delay it until all selections have been made? Thanks in advance.

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author

      Hello Kirk,

      the Facet navigation is part of our update for end of next week and you can register on our website for a trial

      http://visualbi.com/sap-design-studio/dsx-extensions/

      You can use queries as a data source and you choose to either assign a target data source and then the target data source will get filtered on each click automatically or you can use the scripting and decide yourself what should be happening.

      regards

      Ingo Hilgefort, Visual BI

      Author's profile photo Former Member
      Former Member

      Hi Ingo,

      Thank you very much for your response. We have purchased the extensions already so I look forward to the upgrade.I'll do performance testing then.

      Regards,

      Kirk