Parameterized Data Mining Query Task
This may seem pretty basic but it is driving me nuts!!
How does one write a parameterized Data Mining Query task? I know you can map a variable to a parameter name on the parameter mapping tab. What I need to know is the exact syntax for getting that parameter into the DMX on the Build Query tab.
This is my DMX:
SELECT FLATTENED
Cluster(),
t.[AColumn],
t.[AnotherColumn]
From
[MiningStructure]
PREDICTION JOIN
OPENQUERY([Jason],
'SELECT
[AColumn],
[AnoitherColumn]
FROM
ATable
WHERE
Table.Column = WHAT ON EARTH DO I PUT HERE') AS t
I am running SQL 2008 SP2 and connecting using OLE DB Provider for Analysis Services 10.0
Thank you,
Jason
December 22nd, 2010 3:07pm