StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POmultiple dimension restrictions in a MDX where clause
primarykey
Id
369198
data
AcceptedAnswerId
371866
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2008-12-15T17:59:23.940
FavoriteCount
0
LastActivityDate
2009-02-09T22:52:23.427
LastEditDate
2009-02-04T08:18:47.437
LastEditorUserId
13995
OwnerUserId
13995
ParentId
0
PostTypeId
1
Score
0
ViewCount
8554
LastEditorDisplayName
Anders Rune Jensen
text
Body
I have the following problem. If I query values with a keyfigure which is a function I can't specify multiple values of the same dimension restriction, but if it is not a function it works. So this works: <pre><code>SELECT {[Measures].[Netto]} on columns FROM TDC where ({NonEmpty([Time].[Month].[Month].&[2008-03-01T00:00:00]), NonEmpty([Time].[Month].[Month].&[2008-04-01T00:00:00])}) </code></pre> But this doesn't: <pre><code>SELECT {[Measures].[CalculatedFunction]} on columns FROM TDC where ({NonEmpty([Time].[Month].[Month].&[2008-03-01T00:00:00]), NonEmpty([Time].[Month].[Month].&[2008-04-01T00:00:00])}) </code></pre> And this also works: <pre><code>SELECT {[Measures].[CalculatedFunction]} on columns FROM TDC where ({NonEmpty([Time].[Month].[Month].&[2008-03-01T00:00:00])}) </code></pre> I guess the solution is something like adding the where clause to the header but I really like this solution because it's so simple. The Calucated function is: <pre><code>CREATE MEMBER CURRENTCUBE.[MEASURES].Ultimo AS (iif ((not [Time].[Year - Month - Date].currentmember is [Time].[Year - Month - Date].defaultmember), IIF(NOT ([Measures].[LagerStk] = 0), Sum([Time].[Year - Month - Date].[Date].members(0): ClosingPeriod([Time].[Year - Month - Date].[Date]), [Measures].[LagerStk]), NULL) , IIF(NOT ([Measures].[LagerStk] = 0), Sum([Time].[Year - Week - Date].[Date].members(0): ClosingPeriod([Time].[Year - Week - Date].[Date]), [Measures].[LagerStk]), NULL))), VISIBLE = 1; </code></pre> The code is inspired from this and modified for two hierarchies in the time dimension: <a href="http://www.sqlserveranalysisservices.com/OLAPPapers/InventoryManagement%20in%20AS2005v2.htm" rel="nofollow noreferrer">http://www.sqlserveranalysisservices.com/OLAPPapers/InventoryManagement%20in%20AS2005v2.htm</a> This is on SQL server 2005 Enterprise edition.
Tags
<sql-server-2005><mdx>
Title
multiple dimension restrictions in a MDX where clause
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USAnders Rune Jensen
UserOwnerUserId
1. USAnders Rune Jensen
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.