Re: Calculated Cell or Member
- From: Deepak Puri <deepak_puri@xxxxxxxxxxxxxxx>
- Date: Tue, 28 Jun 2005 12:39:29 -0700
Assuming the data source is SQL Server, create a "sum" cube measure on
the field (say it's "Fact1.Field1"); then use a SQL expression as the
measure's Source Column, like:
>>
case when IsNumeric(Fact1.Field1)
then Fact1.Field1 else 0 end
>>
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***
.
- References:
- Calculated Cell or Member
- From: Tim Chapla
- Calculated Cell or Member
- Prev by Date: Anyone out there processing 3 million rows/ hour and 60 million rows/day?
- Next by Date: MDX Query Woes
- Previous by thread: Calculated Cell or Member
- Next by thread: Building large fact tables
- Index(es):
Relevant Pages
|
