Hi All!

Is there in MDX analog of simple CASE or searched CASE expressiona of T-SQL?

The "Professional SQL Server 2000 data warehousing with Analysis Services"
of Tony Bain, Mike Benkovich etc. said that this construction exisits in
MSAS MDX but I can't write a formula with this expression for calculated
member.

Thank's!

Eugene.

Unfortunately, there is no CASE. I seem to recall that CASE made it's way
into the OLEDB for OLAP spec, but not the product.

tom @ the domain below
www.tomchester.net


"Eugene Frolov" <john (AT) alice (DOT) ru> wrote

"Eugene Frolov" <john (AT) alice (DOT) ru> wrote

The alternatives are:

1. Nested IIFs
2. Choose function.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================