|
Home > Archive > MS SQL Server OLAP > September 2005 > filter fact records by measures
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
filter fact records by measures
|
|
| Word 2003 memory Leakage 2005-09-27, 8:24 pm |
| Hi,
I have a cube with a measurement "qtyReleased" of spills.
I would like to know the number of records with qtyReleased > 1000 (liters).
It seems impossible because it is not an attribute in a dimension.
Is there any solution to this?
Thanks,
Guangming
| |
| Darren Gosbell 2005-09-28, 3:24 am |
| Unless your cubes let you drill down to an individual fact record (which
most don't) I can't think of a way you could do this without altering
the cube.
You could create a view of your fact table with a new derived column
like:
CASE WHEN qtyReleased > 1000 THEN 1 ELSE NULL END as MoreThan1kReleased
The create a measure summing this column. This would of course require
re-designing the aggregations and re-processing the cube and it does not
let you alter the '1000' figure easily. You could however set up
multiple of these if you wanted to. (eg. 1k - 10-k, 10k - 100k, 100k +)
--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <B71A95BD-AB2F-4332-A7FA- D47DC9BD95C2@microso
ft.com>,
Word2003memoryLeakag
e@discussions.microsoft.com says...
> Hi,
>
> I have a cube with a measurement "qtyReleased" of spills.
>
> I would like to know the number of records with qtyReleased > 1000 (liters).
>
> It seems impossible because it is not an attribute in a dimension.
>
> Is there any solution to this?
>
> Thanks,
>
> Guangming
>
|
|
|
|
|