Change number format of chart axis values

[Former Member]

Hello everybody,

First of all I'm a newbie in designing Web Intelligence Reports.

Currently I try to design a report with a universe based on a SAP BW query as the datasource. In the report there is a chart where I want to change the format of the X Axis values. The X Axis consist of two dimensions: Date (dd.mm.yy) / quarter of the hour of the day (a number from 01 - 96). In the Chart properties under Appearance --> X Axis --> Values --> Number format I can just change the number format of date. The second dimension quarter of the hour can't be changed. My goal is just to show the date without the second part. Is there a way to achieve this?

Regards,

Chris

[Former Member]

Sorry, probably I did not express clearly what I want to do. The values in the chart look like they should. I just want to change the labels below the X axis.

[Former Member]

Hey Christian Hausin,

It is not possible. I guess, changing that Variable/object name will suffice the req.

Gracias...!!

Let's play with Aurora (BO XI 4.0)

[Former Member]

Hey Chris,

My goal is just to show the date without the second part. Is there a way to achieve this?

Create Variable in BO WebI Report which will subtract that Quarter part and give you only Date part.

Now use this Variable in place of existing for Chart.

Use Substr(), trim() etc..., functions to get exact data.

Gracias...!!

Let's play with Aurora (BO XI 4.0)

[Former Member]

.

Edited by: Alok Gupte on Oct 28, 2010 2:10 PM

[Former Member]

.

Edited by: Alok Gupte on Oct 28, 2010 2:07 PM

[Former Member]

.

Edited by: Alok Gupte on Oct 28, 2010 2:06 PM