In this blog I will showcase how you can embed a dimensional hierarchy within a scorecard.
There is a certain level of customization required to achieve this using the scorecard component options.
Very briefly, the steps involved in embedding the hierarchy within Scorecard component are:
Next, I will elaborate the steps mentioned above:
a hierarchy on Country dimension, expanded to level 2.
OK + Create CROSSTAB:
2. The crosstab is generated and the hierarchy data is represented as follows:
3. Now we start building and customizing our scorecard component. Drag and drop
the scorecard component from the Analytic Component panel on the left.
and press “Generate Initial Scorecard”.
2. The generated scorecard looks like this:
3. Let’s start customizing the scorecard columns.
below the Header text and choosing “Reset to Default”.
2. Key in custom text and name the Header as “Country Hierarchy” and press enter.
The header text in scorecard is updated accordingly.
3. Next we will define additional columns. Place the selection on column 2 and press
the “+” button. This will add a new column after Column_2.
4. Once the column is added (COLUMN_3), set the following options:
5. Next add another column after COLUMN_3 and set the following options:
6. Now for the final column, COLUMN_5. Go ahead and add COLUMN_5,
and set the following options:
Now that we are done with setting the options on new columns, let’s get back to
setting and customizing our “Country Hierarchy” Column.
1. Select COLUMN_1 (Country Hierarchy), and start by configuring the “Icon” property:
a. Binding Type is dimension member content, which is straightforward.
We are binding the country dimension.
b. Member display requires a bit of configuring, as we will require to set it to
“Member Node State” and set Conditional formatting. Please note this is
essential as we will require to expand and collapse the hierarchy when we
select a node in the Crosstab. We are assigning icons from SAP UI5 library
for “EXPANDED” node state and “COLLAPSED” node state. Therefore, the
configuration for setting
icon next to the Dimension Member Content text box.
To add additional conditions, use the
conditional formatting ( invoked by pressing the”+” icon.
c. Now to finally view all the icons you have configured in the previous step, it is required to
set the “Display Mode” to “Icon with text”.
2. Next we configure the “Show Icon” property:
Member Content text box. Add an additional condition and key-in “HIERARCHY_NODE”
and set it to default selection by checking the checkbox. Uncheck the default value checkbox.
This setting will set the icon display to show HIERARCHY_NODE. Icon will show only for HIERARCHY
NODES.
3. Finally, we now switch to “Cell Layout” to configure the padding property.
This is required to indent the different levels of hierarchy nodes display.
Cell Padding will take care of the top, right, bottom and left margins for content alignment
Conditional Format to “10px 10px 10px {value}0px”. Please notice that we have a
{value} in braces, which will be replaced by the value fetched by the “Member Level” i.e.
if we have 3 levels in our hierarchy and we select level 2, then the {value} will be replaced
by 2. As we have {value}0px, the result will be 20px. I hope that explanation helps.
cross-tab, you will also see the hierarchy expand and collapse in the scorecard.
This concludes the blog on embedding and configuring a Hierarchy within SAP Business Objects Design Studio 1.6
Scorecard Component.As this is the first release of the component, there is a possibility of additional refinements
in the future releases.
To remove the dependency on cross-tab to manage the hierarchy(expand and collapse) within scorecard, refer to this blog:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |