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


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

Building a Mining Structure from a Cube

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
 
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


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

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

  

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

Building a Cube?

  
Hello All, I am Brand New to SSAS Development, Day 1... Please direct me .. I have a Database called "Prices" In the we have Tables "Analyst",Sales Rep,Sales Rep Sub & Users. We have another DB which is in build now which consists all the reports on our company. The Project will give analysis on the 5 tables. Can anyone direct me?FM

mdx or cube structure change?

  

Hi,

Here is the issue I am having with one of the fact table in cube:

My FactTable structure:

EID   LoadTime                         Billable  Traceable

230    2010-09-01 00:08:000      1               1

230    2010-09-04 11:03:000      0               1

230    2010-09-05 00:00:000      1               0

230    2010-09-06 09:12:000      1               0

230    2010-09-07 06:59:000      1               1

231    2010-09-03 09:17:000      1               1

231    2010-09-07 00:00:000      0               1

 

I created a measure group in the cube. EID is for a member and 1 member can have multiple loads. For any given time frame, I need to calculate 2 counts:

Count of EID's and SUM(Billable) of EID's with latest loadTime.

So, how can I calculate SUM(Billable) for EID's with latest LoadTime in

Project Server 2007 Cube Building Error

  

Everyone,

 

I have no experience with MDX and it appears that during the cube building process for Project Server 2007 there seems to be some deficient MDX scripts.  I looked at the SASS logs with no luck and looked in the application logs with no luck.  I scripted out the problematic cube MSP_Portfoilio_Analyzer and found the 'Reported' syntax but don't really know how to correct or if there is even a problem.  The cube has built in the past with no problems.  Any help would be appreciated.

 

Server build is as follows:

Microsoft SQL Server 2005 - 9.00.3200.00 (X64)   Oct  2 2007 12:23:02   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)  

 

The server has both SQL Server and SSAS installed.


cube building:

  

While creating cube i got the following errors,please help me out from this

===== Initiating cube build process =====
[10/21/2010 1:18 PM] Cube build request message has been added to the Project Server queue
===== Verifying and running pre-build server event handler =====
[10/21/2010 1:19 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[10/21/2010 1:19 PM] Cube build initialization started
[10/21/2010 1:19 PM] OLAP database and cube structure was determined successfully
===== Building database and cubes =====
[10/21/2010 1:19 PM] Cube build session started
[10/21/2010 1:19 PM] Analysis Services session started
[10/21/2010 1:19 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server seluws0426. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
 
Error:
===== Process Completed =====
[10/21/2010 1:19 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server seluws0426. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
 
Error:


i can't process and run my mining structure in SSBIDS (SQL Server 2008 R2)

  

Hello.

i'am a new user in SQL Server 2008 R2. i'am working in DATA Mining project. in one of my tests working with adventureworksDW2008R2

So after creating the data source and the data source view, and the mining structure using the bike buyer prediction...

i could process and deploy, then when i click run a failure message appears telling me

"Internal error: The operation terminated unsuccessfully."

"Server: The operation has been cancelled."

"The datasource, 'Adventure Works DW2008R2', contains an ImpersonationMode that is not supported for processing operations."

"Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW2008R2', Name of 'Adventure Works DW2008R2'."

Please anyone can help me in this one??????????????????

 


badrou zeggar

Help on building the cube

  

There is an existing cube with a set of tables being used , one for date dimension (dimdate-broken to hour level), one for sales dimension (dimsales), one for sales details (factsales). We have added the staff schedule (dimstaff-broken to hour level) recently.

The purpose of adding the staff schedule is to see the sales while a staff being on counter. A link was created between dimdate and dimstaff, and processed the cube. when sales are viewed for a period in a counter by a staff, the entire sales for the period is shown for each staff  available at the sales time. we tried to create a link between the factsales and dimstaff using the counter and date field but while processing it gives message that the attribute key is not found because some staff hour levels do not exists in the factsales.

The requirement is to show the total sales done during the time the staff was working. Any help on how to create the link and process the cube is greately appreciated. If what is followed is not the best practise, please suggest the right way.

Please let me know if more details are required.

Note: the factsales does not record the staffid so sales transaction is not related directly to any particular staff.

 


time series model - mining structure does not exist

  

I have successfully created a time series model using DMX code, but I haven't been able to export the predictions to my SQL database - the results are too large to copy/paste and I haven't been able to figure out code that will allow me to copy it directly to my SQL database. I know you have the option to save predictions to a SQL table in Visual Studio, so I'm trying to recreate the model using the new mining structure wizard on an entirely new SSAS database in Visual Studio. When I go to deploy the structure, it tells me that the mining structure does not exist. I'm confused because I'm trying to create the structure - of course it doesn't exist. Does anyone have any advice?


Myles McKee

time series - mining structure does not exist

  

I have successfully created a time series model using DMX code, but I haven't been able to export the predictions to my SQL database - the results are too large to copy/paste and I haven't been able to figure out code that will allow me to copy it directly to my SQL database. I know you have the option to save predictions to a SQL table in Visual Studio, so I'm trying to recreate the model using the new mining structure wizard on an entirely new SSAS database in Visual Studio. When I go to deploy the structure, it tells me that the mining structure does not exist. I'm confused because I'm trying to create the structure - of course it doesn't exist. Does anyone have any advice?


Myles McKee

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

 

 


Building a Searchable Phone Directory with Windows SharePoint Services

  
I want to continue to build out the intranet site we've started in our previous articles. A standard item in every intranet is a staff/employee list. Most companies implementing Windows SharePoint Services (WSS) are large enough to have a database that contains all employees. We will use the aggregation features of SharePoint to include data from this database into our intranet.

Building a grouping Grid with GridView and ASP.NET AJAX toolkit CollapsiblePanel

  
I've posted an update to this post to apply on demand loading of Details data using ASP.NET AJAX PageMethods. I'm demonstrating the usage if CollapsiblePanelExtender client events on the new post. Check it out.

I admit, Matt Berseth is really inspiring me! Few days ago I pass through 2 of his great posts:

.Surrounding your Data Table and Dialog Controls with ComponentArt Styled Panels
.Building a Grouping Grid with the ASP.NET 3.5 LinqDataSource and ListView Controls
The first one is pure design tips one which I used for making good presentation of my demo here. The 2nd post is actually the idea.

Building Layered Web Applications with Microsoft ASP.NET 2.0 - Part 1

  
"Building Layered Web Applications" that shows you how to build N-Layer applications with Microsoft ASP.NET 2.0. These articles teach you how to design, build and use custom business objects in your web application. The target audience for this series are developers that are ready to make the switch from using SqlDataSource controls to ObjectDataSource controls with custom business objects. Experience with ASP.NET 2 and C# is necessary while some knowledge about object oriented design certainly helps. The design I am going to show you in these articles is a simplified version of a design you would use in a real world application. It doesn't feature all the necessary functionality your application needs, but instead focuses on the underlying concepts.

Building a 3-Tier App with Silverlight 3, .NET RIA Services, and Azure Table Storage

  
Silverlight 3, .NET RIA Services, and Windows Azure Services Platform makes a 3-tier Cloud application easier to build: Silverlight 3 as presentation tier, .NET RIA services as the business logic and data access tier, and Windows Azure Table as the data storage tier. The sample application in this article demonstrates the architecture with a simple Survey application with all these technologies working together from Windows Azure.

Building a LINQ Provider

  
Throughout this article, we will build a simple IQueryable provider similar to the LINQ to SQL provider demonstrating what is needed to build a custom provider that is capable of executing LINQ queries and performing create, update and delete operations.

Building Re-Usable ASP.NET User Control and Page Libraries with VS 2008

  

I am having problems with a user control. I want my solution to have a separate project for holding my user controls.


The main project can get a reference to this user control project and can import this user control dll into my main project. 


Thanks in advance,

Dheeraj Mittal

dhemittal@gmail.com


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