RE: Different field/dimension grouping

#1

Sounds like you simply need another time dimension - 'start date'. You can do
this simply by creating a view against the original time dimension table and
basing the AS dimension on the view.

HTH

"Rodrigo Guerra" wrote:

Quote:

Hello all.

Again.. I'm stucked:

I have a cube with production (in lots), so I have "month production began"
and "month production ended" for each record

For all calculations use "end month" (i.e. "Lots ended each month", a
measure with simple COUNT). This is my field to do relationships between Time
dimension

But now... I need to indicate how many "Lots started each month", but
relation for "end month" doesn't allow me it, because I can have lots started
in a different month than ended.

¿Do you know how to solve this?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: Different field/dimension grouping

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

RE: Different field/dimension grouping - 09-09-2004 , 05:57 PM