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 |
|
isaac.bs
Starting Member
3 Posts |
 Posted - 2008-01-22 : 15:48:37
|
| Hi, I have 2 measures and 1 calculated memberThe measures are [Measures].[ASK] and [Measures].[RPK]The calculated member is called OF (Occupancy Factor) and defined as IIF([Measures].[ASK] = 0, NULL, ([Measures].[RPK]/[Measures].[ASK])*100)With the ASK and RPK measures any query works very fast, but when I try to add the calculated member I get the "The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples" Is there any workaround? Why the division causes this problem if I can get to very detailed levels if I use the measures alone, but when I try to use the calculated member it failsThanks in Advance |
|
|
|
|
|
4,294,967,296 tuples problem