MS SQL Data Warehousing - Is it Possible to use Parameters in MDX? (MSOLAP.3 error)

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Is it Possible to use Parameters in MDX? (MSOLAP.3 error)

Pepper

2006-11-02, 7:12 pm

Is it Possible to use Parameters in MDX? I am tring to pull the last
30 days of data for a particular Market Area (i.e. Southeast) based on
Parameter inputed.
MDX Code:

WITH
SET [LastMonth] AS ' Tail(Filter([Fiscal Day].[Date].Members, Not
IsEmpty([Fiscal Day].CurrentMember)), 1) '
SET [Last1Months] AS ' [LastMonth].item(0).Lag(30) :
[LastMonth].item(0).item(0) '
Area as @Parameters!.[Area Desc}.Value

SELECT {[Measures].Members} ON COLUMNS,
{ [Last1Months]} ON ROWS,
NONEMPTYCROSSJOIN ({[Employee].Members},{[Mkt
Area].[Area].value},{[Bonusable Div].[Bonusable Div Desc].Members})ON
PAGES
FROM payrollrpts

I keep getting this error:
The ICommandWithParamete
rs interface is not supported by the 'MSOLAP.3'
provider. Command Parameters are unsupported with the current provider.

MDX is a new programming language for me...I am a SQL Developer.

Sponsored Links