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 |
|
MRIGUY
Starting Member
17 Posts |
 Posted - 2002-02-07 : 17:10:17
|
| I'm want to write a formula that conditionally uses members. Some cubes may have the member and some may not. So if [MemberA] exists use it otherwise use [MemberB]As soon as I reference [MemberA] in a cube that doesn't have it, error.Is there a function that can be used to check if a member exists? |
|
|
Mandolino
Starting Member
1 Post |
Posted - 2003-03-31 : 06:51:08
|
| Hello,You may use the Name property of a member.Here is an example:Sum(Filter([Language].[Language Code].Members,[Language].CurrentMember.Name="en"))In your case: <...>.Name="MemberA" |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-03-31 : 07:11:41
|
quote:
Checking for existence of a member
Never mind, I was thinking of something else.  |
|
|
|
|
|
|
Checking for existence of a member