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

    Hello,

    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


    PS
    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

    Default

    BUMP

    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'",
    "#.00%"))
    select NON EMPTY ...

    This article: http://www.nicholasgoodman.com/bt/bl...rend-arrows-2/
    uses arrows "|#.00%|arrow='up'" or arrow='down'"

    In another article it is mixed http://www.redopenbi.com/group/jpivo...olorear-grilla
    "|###,00|style='green'|arrow='up'")

    And in here http://jasperforge.org/plugins/espfo...&topicid=18139, 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.