Skip to Content
avatar image
Former Member

Building a BI based dashboard in Visual Composer


We are using the Visual Composer to build a KPI dashboard based on BW KPI's from multiple queries (NO SEM in the background !)

What we need is to place the keyfigures in the rows and the keyfigure value in the colums. In the colums we further also need an arrow that indicates the trend based on the keyfigure value (ascending, descending,...)

this is how it should look


Keyfigure Value Trend

Gross Sales 100€ Down

Net Sales 80€ Up

Costs 20€ Up

(*) The trend is based on a calculated keyfigure that compares this month's values with previous month's values.

In Visual Composer I'm trying to fit this in a table. After playing around I found that I need to place my keyfigures (column A) in a structure in the Rows in the BW query. Afterwards I can use the "characteristic" Key Figures and place it in my column in the VC table together with the value and the trend.

However, now my real problem occurs. I want to link trend with an image but the image should not be based on a condition linked with the main keyfigure from my row A but on another calculated keyfigure that I do not want to show in my rows at all. I'm affraid this is not possible since I don't see an option.

If anyone has an idea, please share. This kind of VC cockpit apps you see quite often on slides and Xapp presentations but I'm affraid they were all created with SEM cockpits in the background so I hope to be proven wrong.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 20, 2007 at 05:27 PM

    Id'try the following:

    a) your trend-field is in your query, but unselected in the field list

    b) build a formula on this unselected field which selects the image (from the Image Manager)

    More on modeling can be found in the Visual Composer WIKI:

    and many postings in the Visual Composer (where it might make sense to ask such questions in the future), where I also moved this question.

    Add comment
    10|10000 characters needed characters exceeded