MDX FILTER HELP NEEDED

FAQ

Profile

MDX FILTER HELP NEEDED

Database Help (Home) -> OLAP

Next: programfiles(x86)

Author

Message

balajikkrishnan via SQLMo

External

Since: Mar 18, 2008
Posts: 22

(Msg. 1) Posted: Fri Jan 02, 2009 3:25 am Post subject: MDX FILTER HELP NEEDED Archived from groups: microsoft>public>sqlserver>olap (more info?)

I have a measure , I need to filter the measure based on these conditions in a single MDX QUERY 1. < Start Date (11/11/2005 2. Between Start Date (11/11/2005) and End Date (11/11/2006) 3. > End Date (11/11/2006) The patient count measure should slice with all this condition seperately in a single MDX QUERY, and my output should be something like this 10 30 50 Let me know how to write a MDX query for this? Thanks in advance Krishnan -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-olap/200812/1 >> Stay informed about: MDX FILTER HELP NEEDED

Display posts from previous:

Related Topics:

Filter function - Hello, I'm using AS 2005 SP2 build 3215 x64. I have the following mdx: with set s1 as filter( descendants( [Time].[Fiscal Hierarchy].&[20070002], //Q2 2007 [Time].[Fiscal Hierarchy].[FiscalWeek] //week14-26 ) , [Time].[Fi...

How to get the Filter Values - Hi, I need to know how to create a calculated measure that will return the values that have been included in the filter fields. The users see the cube through Excel 2007. We have preset some filters for them that return a subset of data. They can....

Use and ignore a filter in the same query - I have a degenerate Cube Dimension [Enrollment] that holds patient enrollments (i.e. referral date, admission date, etc). I have a related Fact Table [Enrollment Day]. For each date of the [Enrollment], the [Enrollment Day] table holds the Status o...

MDX: CurrentMember problem in filter expression - Hi, I am trying to create a filter expression, but it is keeps on returning #Error and I think that it is because I am having problems with the CurrentMember property. I have tried this: WITH MEMBER [Measures].[X] AS COUNT ( FILTER ( ..

MDX needed for Cost Percentage - I am building a sales cube using SSAS. I want to include a calculated measure called "Cost Percentage" that would be [Line Cost]/[Sales Amount]. Please let me know what the MDX would be for that.

	Database Help (Home) -> OLAP	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum