Filling Missing Dates on Chart Axis in Web Template

[Former Member]

Hi,

I have a chart in a web template that uses a range of data that is organized by date. The data does not contain every date in the range, for example:

Record 1: Jan 1/09

Record 2: Jan 14/09

Record 3 Feb 4/09,

Record 4: etc

The requirement for this chart is to display the dates on the category axis with the axis displaying all the dates between the first and the last date even if records for the dates do not exist. This can be done in a chart in Excel, but I have not found a way to duplicate this in a BW3.5 web template.

Our envionment is BI7 SP13, but we are still using the BW3.5 front end tools.

Thanks,

Mel

[Former Member]

Hi Mel,

you can solve this with a structure. First entry with variable date and all others with offset.

regards Sven