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 |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2009-12-08 : 10:44:49
|
| Hi I have the following query, and would like to add a parameter to it, it will be running off a report. In a normal sql query i would just add 'where fields = @param'obviously its not the same here.Any help?Thanks!Select non empty { [Measures].[GBP Val]} ON Columns,non empty { [Purchases Supp Dim].[Master Parent ID].[Level 04] *[Unit Dim].[Parent Unit ID].[Level 05]} ON RowsFROM [IPP Supplier]WHERE ([Year Dim].[Year Long Name].[2008/09]) |
|
|
|
|
|
mdx query with parameter