Aggregate when measure contains a specific value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Owen J. - 07 Apr 2008 23:01 GMT

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?

Reply to this Message

MC - 08 Apr 2008 06:09 GMT

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

>I have the following:
>
[quoted text clipped - 7 lines]
> I need to create a sum of [NRT Units] for all tires at any level when the
> [Times Retreaded] = 1. Anyone have any suggestions?

Reply to this Message