January 05, 2000 11:04 AM

MDX Puzzle

Rating: (0)
SQL Server Magazine
InstantDoc ID #7932
In Mastering OLAP, "Cell-Level Security" (December 1999), I discussed OLAP Services' cell-level security capabilities and how an MDX expression lets you control which cells a user can access. When a user doesn't have access to a cell, OLAP Services returns the cell value #N/A. This month's MDX puzzle question is "How would you write an MDX query so the cells that you don't have access to return empty (null) values instead of #N/A?" Until next time, if you have ideas or questions for future colum...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS