Skip to Content

This is an introduction of the new scorecard component.

The scorecard component introduced in release 1.6 will allow you to define highly customizable tables. You will have influence on all visualization properties for the content and more content types (small charts) as well. Binding any property of the content to the data view is allowing you to react on some values / master data and make any property value conditional.

The Idea in Overview

The main idea behind the scorecard component is the mapping between the data source and the visualization. The visualization is based on a table, so what you can define are columns of the table. A column has cell content with type, header and some general properties. A property has a value which can be maintained directly or bound to the data set using the known data selection model -> this is the binding concept. Every property is independent of each other, but you can make them a kind of dependent if you bind them to the same data cell value.

Selection for Row Scope

Before you can start definition of the scorecard, you need to understand the Row Scope concept. The row scope is defining how many rows you will have in the scorecard and which data are accessible for you in a single row. You need to select a dimension from row dimensions and then the scorecard will get as many rows as many combinations of the selected dimensions are available.

Property Binding

To fill a property with value you can bind it to a chosen aspect of a data source. It can be data cell, some metadata or master data. Of course, the majority of the properties must use the conditional bindings to translate the selected value from data source to the target value. E.g. you want to set the background color to RED when conditional format (BEx Exception) has value 5. For this you have to map it, 5 => RED. then the system will evaluate the value and match the conditional binding to fill in the correct color value.

Example on Simple Data Source

We will try to visualize the following data source (here as crosstab) with scorecard, reducing number of rows and compacting the information.

Crosstab. In my data source I have 3 dimensions in rows (Region / Product Group / Customer) and 2 dimensions in columns (Year Quarter and Measures). For the row scope we can select only from dimensions from rows. In my example I will select the row scope “up to Product Group”. What does this mean? The scorecard will be defined by multiplied members of those 2 dimensions, the number of rows will be defined by number of members of the Regions by Product Group. Result members are counted as standard members.

sc-1.PNG

Scorecard. When the row scope is defined, you can generate an initial scorecard. What you get is this (see documentation for the generation routine).

sc-2.PNG

The columns are as below:

1. the members of “Region”

2. the members of corresponding “Product Group”

3. the “Result Member” for the dimension “Billed Quality” (as this is the first one in the measures)

4. a line chart for members of dimension “Customer”.

5. comparison chart (which in this case makes not much sense, so we delete this column).

Few Changes to Achieve my View

Now, having a scorecard, I want to achieve a bit different view. I want to have the column chart in column 4 and I want to have line chart for the dimension “Year Quarter” to see the change between Q4 and Q1.

The first change is simple, we just need to change the chart type. all other properties stay.

The second change is also simple, we add new column and defined this to the type “Trend Chart, Line”. The most important setting is the selection of the content for “Actual Values”. For this, we use the binding type “Multiple Cell Values” (the only one for multiple values) and select the cells we want:

sc-7.PNG

What is important in this selection dialog is, the dimensions which are in tow scope do not matter. This is because those have values assigned by the rows. The dialog is visualizing the selection, but you can logically ignore it. Then, as we want to have all members of the dimension “Year Quarter”, we will not touch this dimension, the system will add corresponding selection for it. We just need to specify the others dimensions to fix their members – in this case, the result for “Customer” and “Sale Value” for measures.

This is the effect of the selection:

sc-4.PNG

Understanding the selections

When you look at the used selection, there is the “BLUE” one (locked, not changeable) and “WHITE” one (in the property with value help).

The BLUE value represents the effective selection – this one do not contain the dimensions which are included in the row scope definition. It means this one is always less specified than the selection in the WHITE property (here “Selected Data Cells”). Additionally, all not selected dimensions will be introduced with “*” or “?” key as selection – it means, “all” members or “all w/o result” members will be selected from the dimension.

The WHITE property is holding 1:1 as the Help-Dialog is requiring it. It includes all defined dimensions (which is required to allow the same selection when dialog is started again). This effect is important and this is also the reason why you should never change the data source or row scope once the scorecard has already specified columns.


Example:

Assuming: REGION is in Row Scope (removed) and YEAR_QUARTER was not selected (inserted with “?”)


WHITE: {“(MEASURES_DIMENSION)”:”BILLED_QUANTITY”,“REGION”:”80501″,”DISTR_CHANNEL”:”0″}

BLUE: {‘(MEASURES_DIMENSION)’:’BILLED_QUANTITY’,’DISTR_CHANNEL’:’0′,‘YEAR_QUARTER’:’?’}


Additional Settings which helps you in Comparison.

Making the settings as above, you will see the line – but you need to be aware about the scale. The scale is based on each row values. It means you see the direction in each row (increasing or decreasing) but you cannot compare the rows with each other. For this, you can use the fixed values for minimum and maximum.

sc-8.PNG

Then, you can see the chart like here:

sc-9.PNG

or as columns, changing to columns and adjusting the fixed scale:

sc-10.PNG

I hope this will help with startup, I will try to provide more examples on different scenarios.

The example can be downloaded from this link:

applications/SCN_SCORECARD_1-20151203125915.zip at master · org-scn-design-studio-community/applications · GitHub

(download as raw content and import in Design Studio)

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

    1. Karol Kalisz Post author

      Hi, how you mean “on text” – what is the text logically. if you mean a property – all properties are supporting data binding.

      (0) 
  1. Zeynep Karakaya

    Hi Karol,

     

    I’m trying to add a line break (\n) to the header text of a measure column, but the Scorecard ignores any line breaks even if they are defined in the query (e.g. name of a formula).

     

    Do you know how to do this?

     

    Sales  <– What I want   vs. What I get –> Sales 2014
    2014

    (0) 
  2. Maria Daniela Petersen Marichal

    Hi,

    For trend charts (columns), is there any way to put a custom conditional color?

    Now it only allows to select from the dropdown list (good, neutral, error…) there is a “Custom” option but i don’t know where to define this..

    any ideas?

     

    Thanks

    (0) 
  3. Agata L.

    Karol,

    Very useful post. Thank you.

    I have a question regarding Year_Quarter trend example. You are only comparing 2 quarters: 201404 and 201501. Your trend chart shows 2 data points, accordingly. What if you added a new measure to your query, say Billed quantity in the last 2 years (8 quarters)?
    This would result in additional 6 columns of data for each of your existinig measures, as in Design Studio there is no suppression on empty columns. Your trend chart would get extra 6 data points (zeros) (x-axis would be 8 quarters long). Is there a way to suppress those additional columns that are not relevant to the measure my chart is looking at?

    I have complex queries showing different measures: 12mths (which I want to show as trend), but also 2 years, 5 years etc. My 12mths trend chart becomes 60 months long, as a result.

    I know this is an old thread, so if I don’t hear from you (which is absolutely fine) I will post my question on the general forum.

    Thanks,
    Agata

    (0) 
  4. Meghana Gaddam

    Hi Karol,

    am unable to see the property ‘Navigation mode’ for this component and i would like to set it to ‘Pagination’

    am unable to set it using CSS too! Only Scroll option is available on ‘Overflow’ property.

    Any suggestions on how to achieve it?

    Thank you,

    Meghana

    (0) 

Leave a Reply