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


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

time series model - mining structure does not exist

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

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


View Complete Post


More Related Resource Links

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

Optimizing Data Mining processing time for a Time Series model in SQL Server 2008 R2

  

Does anyone have any references around optimizing the initial processing time for a data mining model? Books, blogs, etc. I have the Wiley “Data Mining with SQL Server 2008” book, and while I’ve learned a lot from it, it doesn’t seem to cover much around trouble shooting things like processing time. I also have a few other books that have a chapter or two on data mining, but again just basic “here’s what it is and how to set it up”, nothing that quite covers trouble shooting or optimization. I’ve also checked out the various Data Mining blogs/sites.

 

I’ve got a Microsoft Time Series model I’m basing on a Cube. Very simple, trying to forecast sales. I have one dimension which is the list of products (about 1600), a second which is the time dimension, finally the measure is daily sales figures for each, about 3.2 million rows in total. On a brand new server, with two quad core processors and 16 gig of ram it took 40 hours to process. Seems rather high?

time series data mining help

  

I have sales data for several sku's over 2 years by month. (by location but that isn't necessary atm)

How do I use the data mining tool to give me strait predictive sales from this pocket of data.

 

I have cubed it, I have run the time series where I have to pick partnumberDim for start, and then nest the date dim.

But I can't seem to make any sense of what this is telling me.


foxjazz

Errors in Olap Mining Models (Time Series)

  

1.    In a model that is

Extracting Association Rules from Data Mining Model

  
Hi I have succesfully created a Data Mining Model using the Association Model. I have deployed and processed it. I need to extract all the rules that is generated by the model. I know that you normally query the model using DMX prediction queries, but in this case I need to extract the rules to a separate table for further processing. I have tried the following approaches unsuccessfully: 1. Linked server in MSSQL Management Studio. DMX query using OpenQuery. The DMX query looks like this: SELECT FLATTENED NODE_CAPTION, NODE_SUPPORT, NODE_PROBABILITY, MSOLAP_NODE_SCORE FROM DataMiningModel.CONTENT WHERE NODE_TYPE = 8   On small models this method works. On larger models with many rules I receive an exception: "XML for Analysis parser: The XML for Analysis request timed out" before it was completed This always happens after 70min. I might have missed a timeout option? 2. Using SSIS to run the same DMX query as above. The method is presented here: http://www.sqlservercentral.com/articles/MDX/64697/ This method works on small models. On larger models that did not work with method 1, it return rules. The number of rules returned is sometimes different for the same package run multiple times. For the largest models it simply returns 0 rules. I suspect that the same XML Parser error happens under the hood of SSIS. I'm currently stuck, and need some inp

Time series algorithm parametrs

  
Hello everybody! I have the following questions to You: I have mining model with data by working hours(every day from 08AM-05PM). What PEREODICITY_HINT I have to use? {24} or {9} The second problem is that on the chart I see historical data wiht axis format 08AM-05PM, but in prediction part the periods is 00-24. It is not correct! I want to see the same 08AM-05PM periods too!   Help me please!   Thank You!  

what's the Best practice about exploiting the time series predections history?

  
Hi all, We are predicting our revenue with two frequency : The first is monthly , the second is weekly with the same parameters daily . The first aimed to have a big picture of our performance during the month , the second is more operational and it's used to drive operational action. So every day we train the second structure with all data and  MTS predicts different value each day basis on the new data used in training. Example: Day of process : 05/07/2010 data used to train : 01/01/2002 ---->05/07/2010 values predicted between : 06/07/2010------>31/07/2010 the value for 18/07/2010 : 35000 $ ------------------------------------------------------------------- Day of process : 10/07/2010 data used to train : 01/01/2002 ---->10/07/2010 values predicted between : 11/07/2010------>07/08/2010 the value for 18/07/2010 : 42000 $   Certainly The second method (predict daily with new training data)  value will be more accruate but it can't be used to drive strategy because it's change every day. Any reflex about this ? saving all data (all prediction for all series every day for the 30 coming steps)? or update coming value with the actualised prediction(the manager will be confused )  

Mining Model - Business user's view

  
Using BIDS, when I create a Mining model solution I can see lot's of useful utilities like Mining Model viewer, Mining Model Prediction etc that comes with lot's of graphs' etc. What would be the best approach to display these graph's to business users. Can I do this easily using SSRS/PowerPivot etc..

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

Advice on collecting data in a time series

  
Hi everyone,  I just wanted to get some ideas of what you would think be the best way to collect data/numbers that are part of a time series?  Let's say I'm collecting monthly data from the users, related to some product and I'd like to be able to provide them a simple and efficient way of entering these numbers based on some month end period.  So for instance on 6/30/2009, they could enter some numbers for a set of data points that pertain to that product.  Would one of the data controls (such as GridView or DetailsView) be sufficient to do this?  I know the GridView isn't so much able to save data but I believe the DetailsView has some functionality for that. In the end, I'd really like to provide a seemless way to do show this and ability to enter and save this.  Any ideas would be appreciated.Thanks

CASES & CONTENT of a Decision Tree Mining Model in One View

  

I would like to have a SQL view that presents both the CASES & CONTENT of the decision tree mining model in one view. Meaning - the view shall consist of the following fields: Node_Name, The Column to Predict, Unique Number (or Key) of a case, and input features of the case. Here is an example:

  Node_Name        | Key |   Column to Predict   | Input1 | Input2 | Input3 |...

0000000000101      |57|

0000000000101     |372|

0000000000100     |118|

0000000000100      |52|

0000000000100     |623|

000000000010000  |41|

000000000010000 |205|

 

I'm familiar with queries such as those:

SELECT *
FROM OPENQUERY(AnalysisServer,
'SELECT * FROM [MyMiningModel].Cases
')
As DMX

SELECT *
FROM OPENQUERY(AnalysisServer,
'SELECT
NODE_NAME
FROM
[MyMiningModel].Content')
AS Dmx

I wish that there was a way to present the information in one view.

Thanks!


Best time to save "structure" session variable

  

I have a structure that groups a number of fields together that I want to use to retain values between different web pages. My plan was to transfer the structure to a session variable and retrieve it as each page loads. In theory each of the different fields could be stored in and retrieved from separate session variables but the structure approach seemed more elegant.

I was initially assuming I would be a "sensible time" (e.g. specific event) when I could consistently save the structure content to the session variable but I realise that I may be on the wrong track and that it may be necessary to transfer to the session variable to the structure each time one of the individual field values is updated as there is no way of determining when the user is about to move to another page.

Is there a solution to this or a better approach?


Unusual results using Time Series Algorithm

  

I am trying to forecast Q4 2010 activity.  The dataset is constant with no gaps from 200401 - 200909.  I want to compare my model with the actual Q4 2009 to verify its accuracy.  The dataset has two columns (month - Key Time and Sales - Predict Only).  I set the PERIODICITY_HINT to {12} since our data is very seasonal.  The problem is every December has increased in sales from the previous year in the dataset, but the prediction fails to recognize this trend.  Is the problem that for 2009 I only give 9 months?  Please help.  A snapshot of the data set is below:

Dataset:

 

200401 866 200402 709 200403 748 200404 1053 200405 829 200406 957 200407 872 200408 917 200409

892

...

 

200907 3909 200908 3829 200909

3976

 

 

 


deploying mining model error

  

Error -- metadata Administrator errors. ' Sequence Clustering ~ MC ' Cube identifier of the reference to ' Sequence Clustering ~ MC-Order Number ', the name is ' Sequence Clustering ~ MC-Order Number ' dimension does not exist. There is an error in the metadata Manager. From the archives ' \\? \C: \Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\Adventure Works DW 2008R2 SE.0. db\Sequence Clustering ~ MC.1.cub.xml ' loading Sequence Clustering ~ MC cube.  

Thanks & Regards


deploying mining model error

  

Error -- metadata Administrator errors. ' Sequence Clustering ~ MC ' Cube identifier of the reference to ' Sequence Clustering ~ MC-Order Number ', the name is ' Sequence Clustering ~ MC-Order Number ' dimension does not exist. There is an error in the metadata Manager. From the archives ' \\? \C: \Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\Adventure Works DW 2008R2 SE.0. db\Sequence Clustering ~ MC.1.cub.xml ' loading Sequence Clustering ~ MC cube.  

Thanks & Regards


Cannot assign multiple keys in the Time Series Algorithm

  

We had a small problem, which we really need to know how to solve as soon as possible, as I told you in our last session that we are running out of time, and this issue is stopping us from completing our predictions. I will try to mention our exact business case and explain it as much detailed as I can so you can help us as soon as possible.

 

                                Kindly check the following scenario:

 

                                Table name: X

                                Columns: ID [Identity column], DATE_TIME [its granularity is hour], NODE_NAME, REASON, REQUESTS

                          

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