Creating a custom Measure -
07-12-2006
, 12:10 PM
I have a fact table, with a field: pub_id that can have values 14, 15
or 16.
something like this:
Pub_ID
15
14
16
16
14
16
I want to create a cube where I get results for all records where
pub_id = 16.
So my result should contain total count of records where pub_id = 16.
In the above case, it would return: 3.
My question is: How can i create a custom Measurefor my data set?
Please explain.
Thanks. |