Hi,

When I generate a pivot table in excel from a regular datasource
(SQL-Server), I am way more flexible in the type and constellation of data I
can calculate.

For example, I am missing the following features - maybe if I redesign my
AS-Cube, I get them aswell?:

1) A time dimension in OLAP will not allow me to directly place the years
within the month - this is useful, if you want to compare values by the same
time each year.

2) If I want to only see all products, which have been given away (price =
0), I cannot do that, if the price is a measurement, and not a dimension.

3) I cannot split a time-dimension onto multiple axes - ie I want the year
on the top, but the month on the left (important for correct charting
needs).

Is there a way to get any/all of these to work with an OLAP cube aswell?

thanks!

regards, Tilli

On number (1) and (3), you can create your own time dimension and not use
the default time dim of analysis services. You could create a dim that had
the year in front of all the months. And you could also create a month dim
and have it on the Y-axis while the time is on the X-axis.

For number two, I think you could use a case statement in your etl to link
any free products to a giveaway match in your dim table, this is similar to
creating an "unknown" entity in your dim table so you do not have nulls in
you fact table.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Tilfried Weissenberger" <tilli (AT) NOweissenSPAMberger (DOT) at> wrote

Allright, thanks!

regards, Tilli