"Farrukh Pulak" <fshiar@hotmail.com> wrote in message
news:%23XMj1SsDEHA.3796@TK2MSFTNGP10.phx.gbl...
> Hi every one:
> I am realy stuck!
>
> 1. I am always receiving an error while running query using DMsample.exe.
I
> have installed lattest service packs and installed ocx componenet
according
> to SQLSERVER.DATAMINING faq .
>
> --> Error message comes: The operation has failed because of an error in
the
> COM component (Microsoftr OLE DB Provider
> for Data Mining Services) Unexpected end of statement
>
> For example I am trying to run following query, I get error:
> SELECT FLATTENED class FROM [car] NATURAL PREDICTION JOIN (SELECT 'low' AS
> [Buying], 'med' AS [Maint],'2' AS [Doors], 2 AS [Persons], 'small' AS [lug
> boot], 'high' AS [Safety],27 AS [mpg] ) 2. Is there any example with
select
> statement?
>
> Please help !
>
>
>
>

"Bogdan Crivat [MSFT]" <bogdanc@online.microsoft.com> wrote in message
news:ulYqS1xDEHA.2804@tk2msftngp13.phx.gbl...
> The singleton select rowset should be aliased. The query will work if
> something like 'AS InputRowset' is appended:
>
> SELECT FLATTENED class FROM [car] NATURAL PREDICTION JOIN (SELECT 'low' AS
> [Buying], 'med' AS [Maint],'2' AS [Doors], 2 AS [Persons], 'small' AS [lug
> boot], 'high' AS [Safety],27 AS [mpg] ) AS InputRowset
>
> For help with the SELECT statements in data mining, please go to the
> following section in the SQL Server Books Online content:
> "Building SQL Server Applications\Analysis Services Programming\PivotTable
> Service\PivotTable Service Programmer's Reference\Data Manipulation
> Language\SELECT Statement"
> It contains the full BNF description of the SELECT Data Mining statement.
>
>
> Hope this helps!
>
>
> --
> --
> --
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Please do not send email directly to this alias. It is for newsgroup
> purposes only.
>
> thanks,
> bogdan crivat
> SQL Server Data Mining
>
>
> "Farrukh Pulak" <fshiar@hotmail.com> wrote in message
> news:%23XMj1SsDEHA.3796@TK2MSFTNGP10.phx.gbl...
> > Hi every one:
> > I am realy stuck!
> >
> > 1. I am always receiving an error while running query using
DMsample.exe.
> I
> > have installed lattest service packs and installed ocx componenet
> according
> > to SQLSERVER.DATAMINING faq .
> >
> > --> Error message comes: The operation has failed because of an error in
> the
> > COM component (Microsoftr OLE DB Provider
> > for Data Mining Services) Unexpected end of statement
> >
> > For example I am trying to run following query, I get error:
> > SELECT FLATTENED class FROM [car] NATURAL PREDICTION JOIN (SELECT 'low'
AS
> > [Buying], 'med' AS [Maint],'2' AS [Doors], 2 AS [Persons], 'small' AS
[lug
> > boot], 'high' AS [Safety],27 AS [mpg] ) 2. Is there any example with
> select
> > statement?
> >
> > Please help !
> >
> >
> >
> >
>
>

"Farrukh Pulak" <fshiar@hotmail.com> wrote in message
news:elOdTG7DEHA.624@TK2MSFTNGP10.phx.gbl...
> 1. That realy works. Appreciate your effort very much. But, I beleive, my
> previous select statement works in analysis server (service pack 2) even
> without alias statement at the end. Because I copied that select statement
> from one of the older published paper. May be it is changed now.
> 2. I realy like to see some select examples in SQLSERVER.DATAMINING
> communities DMsample. All they have, some create statement. Can somebody
> step forward to put such example there. I saw few more peoples like me ask
> similar questions.
>
> "Bogdan Crivat [MSFT]" <bogdanc@online.microsoft.com> wrote in message
> news:ulYqS1xDEHA.2804@tk2msftngp13.phx.gbl...
> > The singleton select rowset should be aliased. The query will work if
> > something like 'AS InputRowset' is appended:
> >
> > SELECT FLATTENED class FROM [car] NATURAL PREDICTION JOIN (SELECT 'low'
AS
> > [Buying], 'med' AS [Maint],'2' AS [Doors], 2 AS [Persons], 'small' AS
[lug
> > boot], 'high' AS [Safety],27 AS [mpg] ) AS InputRowset
> >
> > For help with the SELECT statements in data mining, please go to the
> > following section in the SQL Server Books Online content:
> > "Building SQL Server Applications\Analysis Services
Programming\PivotTable
> > Service\PivotTable Service Programmer's Reference\Data Manipulation
> > Language\SELECT Statement"
> > It contains the full BNF description of the SELECT Data Mining
statement.
> >
> >
> > Hope this helps!
> >
> >
> > --
> > --
> > --
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > Please do not send email directly to this alias. It is for newsgroup
> > purposes only.
> >
> > thanks,
> > bogdan crivat
> > SQL Server Data Mining
> >
> >
> > "Farrukh Pulak" <fshiar@hotmail.com> wrote in message
> > news:%23XMj1SsDEHA.3796@TK2MSFTNGP10.phx.gbl...
> > > Hi every one:
> > > I am realy stuck!
> > >
> > > 1. I am always receiving an error while running query using
> DMsample.exe.
> > I
> > > have installed lattest service packs and installed ocx componenet
> > according
> > > to SQLSERVER.DATAMINING faq .
> > >
> > > --> Error message comes: The operation has failed because of an error
in
> > the
> > > COM component (Microsoftr OLE DB Provider
> > > for Data Mining Services) Unexpected end of statement
> > >
> > > For example I am trying to run following query, I get error:
> > > SELECT FLATTENED class FROM [car] NATURAL PREDICTION JOIN (SELECT
'low'
> AS
> > > [Buying], 'med' AS [Maint],'2' AS [Doors], 2 AS [Persons], 'small' AS
> [lug
> > > boot], 'high' AS [Safety],27 AS [mpg] ) 2. Is there any example with
> > select
> > > statement?
> > >
> > > Please help !
> > >
> > >
> > >
> > >
> >
> >
>
>

"Peter Kim [MS]" <peterkim@online.microsoft.com> wrote in message
news:ua9iKMQEEHA.700@TK2MSFTNGP09.phx.gbl...
> In the MSN DM group, Files-->DMSample folder
>
(http://groups.msn.com/AnalysisServicesDataMining/files1.msnw?fc_p=%2FFiles%
> 2FDMSamp&fc_a=0), there is DMXQuerySamples.zip which you can load to
> DMSample and run it. The zip file contains a few tens of DMX examples each
> of which contains three statements (CREATE/INSERT/SELECT) that exercise a
> variety of DMX features.
>
> --
> Peter Kim
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Farrukh Pulak" <fshiar@hotmail.com> wrote in message
> news:elOdTG7DEHA.624@TK2MSFTNGP10.phx.gbl...
> > 1. That realy works. Appreciate your effort very much. But, I beleive,
my
> > previous select statement works in analysis server (service pack 2) even
> > without alias statement at the end. Because I copied that select
statement
> > from one of the older published paper. May be it is changed now.
> > 2. I realy like to see some select examples in SQLSERVER.DATAMINING
> > communities DMsample. All they have, some create statement. Can somebody
> > step forward to put such example there. I saw few more peoples like me
ask
> > similar questions.
> >
> > "Bogdan Crivat [MSFT]" <bogdanc@online.microsoft.com> wrote in message
> > news:ulYqS1xDEHA.2804@tk2msftngp13.phx.gbl...
> > > The singleton select rowset should be aliased. The query will work if
> > > something like 'AS InputRowset' is appended:
> > >
> > > SELECT FLATTENED class FROM [car] NATURAL PREDICTION JOIN (SELECT
'low'
> AS
> > > [Buying], 'med' AS [Maint],'2' AS [Doors], 2 AS [Persons], 'small' AS
> [lug
> > > boot], 'high' AS [Safety],27 AS [mpg] ) AS InputRowset
> > >
> > > For help with the SELECT statements in data mining, please go to the
> > > following section in the SQL Server Books Online content:
> > > "Building SQL Server Applications\Analysis Services
> Programming\PivotTable
> > > Service\PivotTable Service Programmer's Reference\Data Manipulation
> > > Language\SELECT Statement"
> > > It contains the full BNF description of the SELECT Data Mining
> statement.
> > >
> > >
> > > Hope this helps!
> > >
> > >
> > > --
> > > --
> > > --
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > Please do not send email directly to this alias. It is for newsgroup
> > > purposes only.
> > >
> > > thanks,
> > > bogdan crivat
> > > SQL Server Data Mining
> > >
> > >
> > > "Farrukh Pulak" <fshiar@hotmail.com> wrote in message
> > > news:%23XMj1SsDEHA.3796@TK2MSFTNGP10.phx.gbl...
> > > > Hi every one:
> > > > I am realy stuck!
> > > >
> > > > 1. I am always receiving an error while running query using
> > DMsample.exe.
> > > I
> > > > have installed lattest service packs and installed ocx componenet
> > > according
> > > > to SQLSERVER.DATAMINING faq .
> > > >
> > > > --> Error message comes: The operation has failed because of an
error
> in
> > > the
> > > > COM component (Microsoftr OLE DB Provider
> > > > for Data Mining Services) Unexpected end of statement
> > > >
> > > > For example I am trying to run following query, I get error:
> > > > SELECT FLATTENED class FROM [car] NATURAL PREDICTION JOIN (SELECT
> 'low'
> > AS
> > > > [Buying], 'med' AS [Maint],'2' AS [Doors], 2 AS [Persons], 'small'
AS
> > [lug
> > > > boot], 'high' AS [Safety],27 AS [mpg] ) 2. Is there any example
with
> > > select
> > > > statement?
> > > >
> > > > Please help !
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

"Farrukh Pulak" <fshiar@hotmail.com> wrote in message
news:%23Nyq4xmFEHA.2600@TK2MSFTNGP12.phx.gbl...
> Hi:
> I appreciate your reply. Unfortunatley, while I open the examples using
> dmsample.exe, I only see "Create" statements like following:
>
> Create Mining Model BottomCount1
> (
> TheKey long key,
> Age double continuous,
> Gender text discrete,
> HairColor text discrete PREDICT,
> CarColor text discrete
> ) using microsoft_decision_trees
> I don't see any example with insert or select in that zip file. I am
> definately missing something.
> Please feel free to indicate me. Thanks again. Farrukh
>
>
> "Peter Kim [MS]" <peterkim@online.microsoft.com> wrote in message
> news:ua9iKMQEEHA.700@TK2MSFTNGP09.phx.gbl...
> > In the MSN DM group, Files-->DMSample folder
> >
>
(http://groups.msn.com/AnalysisServicesDataMining/files1.msnw?fc_p=%2FFiles%
> > 2FDMSamp&fc_a=0), there is DMXQuerySamples.zip which you can load to
> > DMSample and run it. The zip file contains a few tens of DMX examples
each
> > of which contains three statements (CREATE/INSERT/SELECT) that exercise
a
> > variety of DMX features.
> >
> > --
> > Peter Kim
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Farrukh Pulak" <fshiar@hotmail.com> wrote in message
> > news:elOdTG7DEHA.624@TK2MSFTNGP10.phx.gbl...
> > > 1. That realy works. Appreciate your effort very much. But, I beleive,
> my
> > > previous select statement works in analysis server (service pack 2)
even
> > > without alias statement at the end. Because I copied that select
> statement
> > > from one of the older published paper. May be it is changed now.
> > > 2. I realy like to see some select examples in SQLSERVER.DATAMINING
> > > communities DMsample. All they have, some create statement. Can
somebody
> > > step forward to put such example there. I saw few more peoples like me
> ask
> > > similar questions.
> > >
> > > "Bogdan Crivat [MSFT]" <bogdanc@online.microsoft.com> wrote in message
> > > news:ulYqS1xDEHA.2804@tk2msftngp13.phx.gbl...
> > > > The singleton select rowset should be aliased. The query will work
if
> > > > something like 'AS InputRowset' is appended:
> > > >
> > > > SELECT FLATTENED class FROM [car] NATURAL PREDICTION JOIN (SELECT
> 'low'
> > AS
> > > > [Buying], 'med' AS [Maint],'2' AS [Doors], 2 AS [Persons], 'small'
AS
> > [lug
> > > > boot], 'high' AS [Safety],27 AS [mpg] ) AS InputRowset
> > > >
> > > > For help with the SELECT statements in data mining, please go to the
> > > > following section in the SQL Server Books Online content:
> > > > "Building SQL Server Applications\Analysis Services
> > Programming\PivotTable
> > > > Service\PivotTable Service Programmer's Reference\Data Manipulation
> > > > Language\SELECT Statement"
> > > > It contains the full BNF description of the SELECT Data Mining
> > statement.
> > > >
> > > >
> > > > Hope this helps!
> > > >
> > > >
> > > > --
> > > > --
> > > > --
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > Please do not send email directly to this alias. It is for newsgroup
> > > > purposes only.
> > > >
> > > > thanks,
> > > > bogdan crivat
> > > > SQL Server Data Mining
> > > >
> > > >
> > > > "Farrukh Pulak" <fshiar@hotmail.com> wrote in message
> > > > news:%23XMj1SsDEHA.3796@TK2MSFTNGP10.phx.gbl...
> > > > > Hi every one:
> > > > > I am realy stuck!
> > > > >
> > > > > 1. I am always receiving an error while running query using
> > > DMsample.exe.
> > > > I
> > > > > have installed lattest service packs and installed ocx componenet
> > > > according
> > > > > to SQLSERVER.DATAMINING faq .
> > > > >
> > > > > --> Error message comes: The operation has failed because of an
> error
> > in
> > > > the
> > > > > COM component (Microsoftr OLE DB Provider
> > > > > for Data Mining Services) Unexpected end of statement
> > > > >
> > > > > For example I am trying to run following query, I get error:
> > > > > SELECT FLATTENED class FROM [car] NATURAL PREDICTION JOIN (SELECT
> > 'low'
> > > AS
> > > > > [Buying], 'med' AS [Maint],'2' AS [Doors], 2 AS [Persons], 'small'
> AS
> > > [lug
> > > > > boot], 'high' AS [Safety],27 AS [mpg] ) 2. Is there any example
> with
> > > > select
> > > > > statement?
> > > > >
> > > > > Please help !
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

"Peter Kim [MS]" <peterkim@online.microsoft.com> wrote in message
news:%23ne7CxoFEHA.2428@tk2msftngp13.phx.gbl...
> You should be able to see "Queries" drop menu at the top of the DMSample
> screen, from which you can choose the query you want. CREATE is being
> displayed just because it's the first query of the xml file you loaded.
You
> could also add more queries to the current open file and save it.
> --
> Peter Kim
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Farrukh Pulak" <fshiar@hotmail.com> wrote in message
> news:%23Nyq4xmFEHA.2600@TK2MSFTNGP12.phx.gbl...
> > Hi:
> > I appreciate your reply. Unfortunatley, while I open the examples using
> > dmsample.exe, I only see "Create" statements like following:
> >
> > Create Mining Model BottomCount1
> > (
> > TheKey long key,
> > Age double continuous,
> > Gender text discrete,
> > HairColor text discrete PREDICT,
> > CarColor text discrete
> > ) using microsoft_decision_trees
> > I don't see any example with insert or select in that zip file. I am
> > definately missing something.
> > Please feel free to indicate me. Thanks again. Farrukh
> >
> >
> > "Peter Kim [MS]" <peterkim@online.microsoft.com> wrote in message
> > news:ua9iKMQEEHA.700@TK2MSFTNGP09.phx.gbl...
> > > In the MSN DM group, Files-->DMSample folder
> > >
> >
>
(http://groups.msn.com/AnalysisServicesDataMining/files1.msnw?fc_p=%2FFiles%
> > > 2FDMSamp&fc_a=0), there is DMXQuerySamples.zip which you can load to
> > > DMSample and run it. The zip file contains a few tens of DMX examples
> each
> > > of which contains three statements (CREATE/INSERT/SELECT) that
exercise
> a
> > > variety of DMX features.
> > >
> > > --
> > > Peter Kim
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Farrukh Pulak" <fshiar@hotmail.com> wrote in message
> > > news:elOdTG7DEHA.624@TK2MSFTNGP10.phx.gbl...
> > > > 1. That realy works. Appreciate your effort very much. But, I
beleive,
> > my
> > > > previous select statement works in analysis server (service pack 2)
> even
> > > > without alias statement at the end. Because I copied that select
> > statement
> > > > from one of the older published paper. May be it is changed now.
> > > > 2. I realy like to see some select examples in
SQLSERVER.DATAMINING
> > > > communities DMsample. All they have, some create statement. Can
> somebody
> > > > step forward to put such example there. I saw few more peoples like
me
> > ask
> > > > similar questions.
> > > >
> > > > "Bogdan Crivat [MSFT]" <bogdanc@online.microsoft.com> wrote in
message
> > > > news:ulYqS1xDEHA.2804@tk2msftngp13.phx.gbl...
> > > > > The singleton select rowset should be aliased. The query will work
> if
> > > > > something like 'AS InputRowset' is appended:
> > > > >
> > > > > SELECT FLATTENED class FROM [car] NATURAL PREDICTION JOIN (SELECT
> > 'low'
> > > AS
> > > > > [Buying], 'med' AS [Maint],'2' AS [Doors], 2 AS [Persons], 'small'
> AS
> > > [lug
> > > > > boot], 'high' AS [Safety],27 AS [mpg] ) AS InputRowset
> > > > >
> > > > > For help with the SELECT statements in data mining, please go to
the
> > > > > following section in the SQL Server Books Online content:
> > > > > "Building SQL Server Applications\Analysis Services
> > > Programming\PivotTable
> > > > > Service\PivotTable Service Programmer's Reference\Data
Manipulation
> > > > > Language\SELECT Statement"
> > > > > It contains the full BNF description of the SELECT Data Mining
> > > statement.
> > > > >
> > > > >
> > > > > Hope this helps!
> > > > >
> > > > >
> > > > > --
> > > > > --
> > > > > --
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > > Please do not send email directly to this alias. It is for
newsgroup
> > > > > purposes only.
> > > > >
> > > > > thanks,
> > > > > bogdan crivat
> > > > > SQL Server Data Mining
> > > > >
> > > > >
> > > > > "Farrukh Pulak" <fshiar@hotmail.com> wrote in message
> > > > > news:%23XMj1SsDEHA.3796@TK2MSFTNGP10.phx.gbl...
> > > > > > Hi every one:
> > > > > > I am realy stuck!
> > > > > >
> > > > > > 1. I am always receiving an error while running query using
> > > > DMsample.exe.
> > > > > I
> > > > > > have installed lattest service packs and installed ocx
componenet
> > > > > according
> > > > > > to SQLSERVER.DATAMINING faq .
> > > > > >
> > > > > > --> Error message comes: The operation has failed because of an
> > error
> > > in
> > > > > the
> > > > > > COM component (Microsoftr OLE DB Provider
> > > > > > for Data Mining Services) Unexpected end of statement
> > > > > >
> > > > > > For example I am trying to run following query, I get error:
> > > > > > SELECT FLATTENED class FROM [car] NATURAL PREDICTION JOIN
(SELECT
> > > 'low'
> > > > AS
> > > > > > [Buying], 'med' AS [Maint],'2' AS [Doors], 2 AS [Persons],
'small'
> > AS
> > > > [lug
> > > > > > boot], 'high' AS [Safety],27 AS [mpg] ) 2. Is there any example
> > with
> > > > > select
> > > > > > statement?
> > > > > >
> > > > > > Please help !
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>