Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2009-08-05 : 10:26:41
|
| Hi is it possible to do the following statement in SSAS, the part am wanting to get to work is after the OR [MM Flag] = 'M&M'This is not a measure its defined in my cube ok but is it possible to do this check. Also what if i have multiples to check like for example in SQL i'd use IN('xx','yyy') IIF((IsEmpty([MEASURES].[Total Actual Sell]) OR ([Measures].[Total Actual Sell])=0) , NULL, ([MEASURES]. [Total Actual Sell] - [Measures].[Total Cost Bcp] )/ [MEASURES]. [Total Actual Sell] * 100) OR [MM Flag] = 'M&M' |
|
|
|
|
|
Calculated Member statement