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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-02 : 08:16:26
|
| hvr writes "Hi, In my Analysis Server, while browsing the cube, there are so many empty tuples for a particular combination of dimensions. I came to know that we need to use Non Empty Keyword( MDX expressions) for this.But this Keyword is used while writingMDX query. In my case Under CurrentmonthCat when i drag stockNos There are somany unwanted empty tuples which should not be displayed.Also i dont have any Calculated Members. As i saw NON EMPTY keyword being used only for Calculated members. plz provide solution about how i can use this keyword(if dont have any calculated members).Also,having doubt that , if use MDX query, it will be for one particular combination of Dimensions. For different combinationstupls shouldnot displayed.Thanks in advance" |
|
|
|
|
|
Problem with empty tuples while browsing cube