SEO

#1 (**permalink**) 04-08-2008, 05:20 AM

I have the following:

A hierarchy named [Tire].[Tire Hierarchy] that contains a list of tires by
tire manufacturer.

I have two measures in the fact table:
[Measures].[NRT Units]
[Measures].[Times Retreaded]

I need to create a sum of [NRT Units] for all tires at any level when the
[Times Retreaded] = 1. Anyone have any suggestions?

#2 (**permalink**) 04-08-2008, 02:38 PM

Would it be viable to create dimension on times retreaded? You can filter by
measure but it will be easier to do i you create a dim and then filter by
it. Not to mention what does it mean = 1? Does it aggregate on diff levles?

MC

"Owen J." <OwenJ@discussions.microsoft.com> wrote in message
news:83731526-A244-46C1-BF5A-278337846895@microsoft.com...
>I have the following:
>
> A hierarchy named [Tire].[Tire Hierarchy] that contains a list of tires by
> tire manufacturer.
>
> I have two measures in the fact table:
> [Measures].[NRT Units]
> [Measures].[Times Retreaded]
>
> I need to create a sum of [NRT Units] for all tires at any level when the
> [Times Retreaded] = 1. Anyone have any suggestions?

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

SEO

Aggregate when measure contains a specific value