Solved

How could the Key column be included in a DMX query?

Posted on 2013-01-01
2
404 Views
Last Modified: 2016-02-18
How could the Key column be included in a DMX query under the Mining Model Prediction tab?

The model used, say DT (for Decision Trees), can list every input and/or predict column except for the Key column.

Is there a way or work-around to include this Key column?
0
Comment
Question by:rodqxo
2 Comments
 
LVL 19

Accepted Solution

by:
Kash earned 500 total points
ID: 38736138
this example may point you to the right direction >> http://technet.microsoft.com/en-us/library/cc280466%28v=sql.100%29.aspx
0
 

Author Comment

by:rodqxo
ID: 38749411
On BIDS/VS2008, I tried StructureColumn(‘KeyColumnName') but I get this error:
"The STRUCTURECOLUMN function cannot be used in the context ..."

Here's the DMX query I used:
SELECT StructureColumn('KeyColumn') From [AR]; where [AR] is an Association model.

I defined KeyColumn as a Key; as opposed to Input, Input+Predict, Predict only.

The [AR] model seems to be only aware of the Input and Predict columns. It is blind to the Key type column, i.e., KeyColumn.

Later on ...

Ok, got it. I should use it this way:
SELECT StructureColumn('KeyColumn') From [AR].CASES

But for now it does not work with a PREDICTION JOIN statement.

Thanks.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now