What do you do when the live SAP BW data you're working with doesn't have
a hierarchy organized the way you'd
like? If you're working with SAP Analytics Cloud,
one solution is to create your own custom grouping directly in a story.
In this video, SAP Analytics Cloud Global Product Evangelist,
Ingo Hilgefort, shows you how it's done.
Welcome to another video on the integration of SAP Analytics Cloud and BW.
This time we will take a look how you can build custom groups.
So first of all, we're going to build a model based on a BW query.
So we're going to connect to our BW system.
We choose the query and generate the model,
and then we're going to save the model in our SAP Analytics Cloud system.
So we saved the model,
now we can actually go and build the story.
And we will start by building our story with a table.
And in our case,
we will use a dimension Product to simply show the data.
So with dimension Product
now there, we want to build our own groups.
Now in this case,
the groups are actually listed as part of the hierarchies.
So we can go and open up the hierarchy menu,
open the list of hierarchies,
and you can see there is an option called Create Custom Group.
And we can actually just create our own groupings now,
so we have a Node,
we can simply enter the text and then we can
assign products from the left hand side to this node.
So you can actually create your own group that will then be
visible as part of the table. So you can have as many nodes as you wish,
and we will also actually create multiple levels of nodes in a second.
So we're just gonna use the casing products and put them in product group
two, and now we're going to add another node and
move this node below the product group two,
so we basically have two levels of nodes now already.
So as you can see,
we can create our own nodes,
we can create multiple levels of nodes,
and when we return to our table,
we can actually open and close these nodes as if this would be a hierarchy we
created in BW. So now in addition to the table,
let's create a chart.
And actually let's take a look if we can simply
reuse the custom groupings as part of the chart.
So we're going to add a measure and then we're going to add dimension Product.
So here we go into the hierarchy menu,
and when you open up the list,
you will see the custom group that we just created.
So you have the same ability for the charts as for the table.
And when you created it once,
you can reuse it across the different widgets.
It's very important to understand that
these custom groups are actually saved with your story,
so you cannot right now reuse them across the different stories.
So another important item to mention is please take
a look at SAP note 2827190, 57 00:04:00,885 --> 00:04:04,250 which does outline the prerequisites for
the custom group functionality with BW and SAP Analytics Cloud.
Right now, this capability is only available for the BW live connection.
I want to say thank you for watching and listening.
Please subscribe to the SAP Analytics channel to keep up to date on
this video series and other SAP Analytics Cloud content. See you next time!