SQL Power Software Forum

Hi,

I'm working with latest Wabit, and am trying to produce a simple time series category line chart using an OLAP data source with a year and half of data.

Right now, it groups similarly named months together, making a spike in the first six months of data (where there are two records). But what I'd like to see is 18 months of categories that are somehow labelled to indicate the month and year (without the year repeating for every month, but being labelled only once for the group of months). Is this possible, somehow?

Thanks,
Steve

Hi Steve,

On one axis you have your time dimension which should contain the year as well as the months. When you are creating a chart from the OLAP query I am guessing you have the month defined as a category and some other columns defined as series. If you make the year column also a category column it will append the year to each month name and split up your months with the same name to be two different bars, one for each year. If I am wrong in my assumption on how your data is defined let me know more about how your cube is set up so I can make a better recommendation.

Thomas

This message was edited 2 times. Last update was at 2009-09-29 10:09:55

Thanks Thomas,

That almost works, bu what you end up having is a year.null category which is the sum of the year. This creates two records (in my example) that are disproportionate to the other months. If I exclude the member years - 2007 & 2008 - from the olap query, I am left with the correct months, but then the chart will automatically group the months which have common names.

I've attached a picture to clarify. Basically, what I want is the option to have year.month without any aggregations so they can be compared in a time series context. Thanks!

Hi Steve,

I played around with the chart some more and there is apparently no way of doing this at current. I've added bug 2291 for an enhancement to allow chart categories to be qualified with other columns. A column defined as a qualifier would add values in the columns to the category values which would split up the months for each year but not add the year in as a new column.

Thanks for the feedback

Thomas

Hi,

you could also just the "All Year" Element out of your query. There is the right click option in the OLAP query to exclude certain elements.

Benjamin

Hi Benjamin,

If you exclude 'all times' from the olap query, then you get the picture seen above. If you exclude each year individually (and leave the months), then the charting feature will automatically aggregate similarly named months.

I'm not sure if that's what you were referring to, but I can't seem to get wabit to separate each month without any kind of aggregation in the charting feature.

Steve

Sorry,

I should of had a closer look at the screenshot. You tried exactly what I was trying to explain.

Benjamin