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.

All Forums  Development Tools  Reporting Services Development  "Less than or equal to" olap report parameter

Author  Topic  pmak Starting Member 41 Posts Posted - 2006-09-07 : 15:01:45 How to create a "less than or equal to" parameter with a SSAS olap cube as the data source using sql 2005 reporting services? Here is the MDX query for the dataset with the two parameters having the "equal" operator. I want to change one of this parameters to "less than or equal to" Thanks. SELECT NON EMPTY { [Measures].[Costing], [Measures].[Pharmacy DW By Account Period Count] } ON COLUMNS, NON EMPTY { ([Drug Cost By Account Period].[Account Period].[Account Period].ALLMEMBERS * [Drug Cost By Account Period].[Protocol Code].[Protocol Code].ALLMEMBERS * [Drug Cost By Account Period].[Drug First Word].[Drug First Word].ALLMEMBERS * [Drug Cost By Account Period].[Drug Name].[Drug Name].ALLMEMBERS * [Drug Cost By Account Period].[Agency Id].[Agency Id].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@DrugCostByAccountPeriodAccountPeriod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DrugCostByAccountPeriodDrugFirstWord, CONSTRAINED) ) ON COLUMNS FROM [Drug Cost By Account Period])) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS