Wednesday, September 3, 2008

OBIEE TimeLine graph Line settings

In 10.3.4.0 Oracle introduced finally the DTA or Time Line graph. In there haste to release it the forgot the chart properties editor. This means we have to edit the PCXML files ourselfs, to get dotted lines, other colors or the plus symbol.

In the timeline.pcxml file look for the SeriesDefinition tag:

Within this tag you can set the following properties:

LineColor='#ff0033'
{the color of the line; possible colors all web RGB colors}

SymbolColor='#3366ff'
{the color of the Symbol; possible colors all web RGB colors}

FillColor='#66ff99'
{the color of the FillColor; possible colors all web RGB colors}

LineWidth='1.0'
{the width of the line in pixels; possible values 'Off','1.0','2.0','3.0','4.0','5.0','6.'0'}

LineStyle='Dashed'
{the style of the line; possible values 'Plain','Dashed', 'Dotted', 'DashDot'}

SymbolType='Circle'
{the symbol at the datapoint; possible values 'Off', 'Dot', 'SmallSquare', 'Square','SquareOutline', 'Circle', 'CircleOutline', 'Triangle', 'TriangleOutline', 'Plus', 'PlusOutline', 'Diamond', 'DiamondOutline'}

ShowArea='True'
{show the area below the line; possible values 'True', 'False'}

Till next time

2 comments:

nir said...

It did solve me the issues in version 10, but what is the procedure in 11g?
What is the replacement of the pcxml file?

Kevin C said...

Is it possible to define a custom symbol type (like a gif/jpg) and use in this config file?