.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Error when building a Data Mining Structure with nested tables on cubes

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
 

Apparently there is a bug in Analysis Services (2008R2) when building a Data Mining Structure (Time Series model) with nested tables on cubes. If the dimension key has a column name, AS becomes confused and gives an error that do not allow to process the structure.

"Error (Data mining): The data type specified for the  'xxxxx' column of the 'nnnnnn' OLAP mining structure is not compatible with its source attribute ('xxxxx' in the 'dddddd' cube dimension")

 Everything is solved by removing the name column, in the attribute of the dimension used. This bug was already reported for SQL2005 in: http://social.msdn.microsoft.com


View Complete Post


More Related Resource Links

Building a Mining Structure from a Cube

  
Hi, I have a problem with creating a time series mining structure from an existing cube. I get the error: The data type specified for the  'Date' column of the 'Purchase Date' OLAP mining structure is not compatible with its source attribute   My date column in this dimension is in fact a Datetime, so it should be the right type for this exercise.  I wonder, am I getting this error because the cube dimension has a Name column of type Varchar specified even though the Key column is dateime?   Thanks, Steve

Building a Mining Structure from a Cube

  
Hi, I have a problem with creating a time series mining structure from an existing cube. I get the error: The data type specified for the  'Date' column of the 'Purchase Date' OLAP mining structure is not compatible with its source attribute   My date column in this dimension is in fact a Datetime, so it should be the right type for this exercise.  I wonder, am I getting this error because the cube dimension has a Name column of type Varchar specified even though the Key column is dateime?   Thanks, Steve

Error when entering data into tables durring Asp.net walk through

  

Hi, not sure were to ask this question, any help in pointing me in right direction is much appreciated.

 

so I've set up the table as described.. (seems to be some directions missing with regards to, is identity? and is Primary Key? and what those values are and should be set to for name, description, and price  durring table setup)  So, ive tried to set the table up as directed and then go on to click DATA which allows me to fill in the table.  I can fill in the table all the way accross but when i reach the end of the first row it says:

INVALID DATA  your change could not be committed to the database. after you clik ok you can fix the invalid entry or press to cancel your changes. 

 

thanks for you help

Sincerely

Chris


Error Processing Mining Structure - Errors in the high-level relational engine.

  

Hi community,

I am trying to learn some datamining with SQL Server. I have some demo projects I am trying to run under my test environment: Windows Server 2008 + SQL Server 2008 R2 Enterprise. Sample projects seems to be ok, but when I try to process a mining structure, I get this error:

"Errors in the high-level relational engine. The following exception occurred while an operation was being performed on a data source view: The type initializer for 'System.Xml.Schema.XmlSchemaComplexType' threw an exception.;Bad IL range.."

Any ideas?

Thanks in advance

 

 


MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

datarow data insertion error

  

this is the code which i am using and what i want means when i==0 first record should bind to datatable and when i==1 2nd record should bind to datatable. that means when i==1 1st and 2nd record should be present in datatable  Please see the code below

error:

when i am binding 2nd record to datatable 1st record is getting deleted and recently inserted value is getting inserted please tell me how to resolvie this

code:

datatable dt11=new datatable();
DataRow row11=null;



if (i == 0)
{
row11 = dt11.NewRow();

row11["qid"] = qnumber;

row11["question"] = question;
row11["useranswer"] = correctans;
row11["flag"] = answerstatus;

dt11.Rows.Add(row11);
}

if (i == 1)
{

qnumber =ds5.Tables[0].Rows[i][0].ToString();
question =ds5.Tables[0].Rows[i][1].ToString();


row11 = dt11.NewRow();

OData and AtomPub: Building an AtomPub Server Using WCF Data Services

  

Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.

Chris Sells

MSDN Magazine August 2010


Practical OData: Building Rich Internet Apps with the Open Data Protocol

  

See how you can build Rich Internet Applications that take advantage of the OData protocol to creatively interact with Silverlight, PowerPivot, SQL Server, SharePoint, the Windows Azure platform, "Dallas" and more.

Shayne Burgess

MSDN Magazine June 2010


Data Access: Building a Desktop To-Do Application with NHibernate

  

Building an NHibernate-based desktop application isn't any harder than building a web application, and in many cases NHibernate simplifies elements of session handling and concurrency.

Oren Eini

MSDN Magazine December 2009


Data Points: Building An Out-of-Browser Client With Silverlight 3

  

Silverlight 2 applications are restricted to running inside a browser. However, Silverlight 3 applications can run inside the browser or out. Here we build a social networking app as a standalone Silverlight 3 application.

John Papa

MSDN Magazine June 2009


.NET RIA Services: Building A Data-Driven Expense App with Silverlight 3

  

.NET RIA Services provides a set of server components and ASP.NET extensions such as authentication, roles, and profile management. We'll show you how they work.

Jonathan Carter

MSDN Magazine May 2009


SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005

  

In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

Jamie MacLennan

MSDN Magazine September 2004


Data Points: Creating Audit Tables, Invoking COM Objects, and More

  

Dealing with error handling between T-SQL and a calling application, evaluating when a field's value has changed, and creating auditing tables in SQL ServerT are all common issues that developers must tackle.

John Papa

MSDN Magazine April 2004


ADO.NET: Building a Custom Data Provider for Use with the .NET Data Access Framework

  

The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers. Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their implementation, and how they can be used to write a variety of different kinds of data providers.

Bob Beauchemin

MSDN Magazine December 2001


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend