Is there a way to create a calculated member by counting the number of
records in a fact table where field1 = 0 and field2 = 0 and field3 = 0 and
Field4 = 0? These are simple indicator fields whose value is either 1 for
true or 0 for false. Are there other options?

This is a new requirement that wasn't cared for in the original OLAP design.
I'm trying to avoid having to alter the fact table and thus the ETL that
currently loads the fact table.


--
Michael Hardy
ETL Developer

Visit our web pages:
www.atlantis.com
www.oceanclub.com
www.oneandonlyresorts.com
www.kerzner.com

A couple of options come to mind:

- If you only need to count fact records that fulfill the one condition,
then you can define a new base 'sum' measure, say [FalseCount], whose
Source Column is a SQL expression like:

and field3 = 0 and field4 = 0 then 1
else 0 end

- If you need more flexibility in analysis, simple true/false member
dimensions can be created off each indicator field. Then the count can
be a calculated measure, based on the fact table record count with each
indicator dimension member selected as "false".


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!