sql server data mining: Hello. I get the following error when I try to generate a
virtual cube from an MDT data mining model:

Error(-2147221425): The object structure is not valid (The
SourceTableFilter of a dimension of subclass type
sbclsMining must be of the
form "MSOLAP_MODEL_COLUMN='<column_name>'".);

Response from our OLAP DM guru, Cristian:

-----Original Message-----
From: Cristian Petculescu
Subject: RE: Error when generating a virtual cube from an MDT model

How did they build the mining dimension? Using tools? I don't think so
(because, obviously, you can create a DM dimension from a MDT mining model).

If they used the tools we need the repro.

If they did create it manually (a sbclsMining dimension) they need to add a
SourceTableFilter of the form MSOLAP_MODEL_COLUMN='<column_name>'. Column
name is the OLAP mining model column that identifies the tree.

If they used DDL to create a session virtual cube, the syntax is:

CREATE SESSION CUBE [Student DMM]
FROM [Children]
(
MEASURE [Children].[Sales],
DIMENSION [Children].[Population],
DIMENSION [Children].[Area]
DIMENSION [Decision Tree] NOT_RELATED_TO_FACTS FROM [My DM Model] COLUMN
[Measures.Sales]
)

(providing that My DM Model is a OLAP mining model based on the Children
cube.

[Measures.Sales] in this case would be mapped to a filter saying
MSOLAP_MODEL_COLUMN=[Measures.Sales]

C

--
Peter Kim
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]