Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: traffic lights in OLAP Analysis View

  1. #1

    Default traffic lights in OLAP Analysis View


    I need in my OLAP Analysis View to use the traffic lights for some KPI Values. Just for values over then certain threshold the colour has to be yellow respectively red.

    How can I do this?

    Thank you for your answers,
    regards Peter

    In my fact table, on which base I defined the cube for the view mentioned above, using Schema Workbench, there is also a table field with already initialized flag values: 0 for green, 1 for yellow, 2 for red.

  2. #2



    that is a thing I am interested in too

  3. #3

    Default Maybe with this

    In the samples. You can use jpivot and conditional formating. Background color is used in:pentaho-solutions/bi-developers/analysis/query1.xaction
    the MDX query is:
    with member
    [Measures].[Variance Percent] as '([Measures].[Variance] / [Measures].[Budget])',
    format_string = IIf(((([Measures].[Variance] / [Measures].[Budget]) * 100.0) > 2.0), "|#.00%|style='green'",
    IIf(((([Measures].[Variance] / [Measures].[Budget]) * 100.0) < 0.0), "|#.00%|style='red'",
    select NON EMPTY ...

    This article:
    uses arrows "|#.00%|arrow='up'" or arrow='down'"

    In another article it is mixed

    And in here, they talk about modifying the CSS: jpivot/table/mdxtable.css.

    Using PRD is another option.
    Last edited by Javier_MX; 02-20-2012 at 03:59 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.