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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Clustering on cube slices

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hi, I would like to use the clustering algorithm "seperately" on each cube slice.  The problem description: Having many employes and their arrival-to-work time I created a cube with a fact table and 3 dimensions: Employee, Time, Office and I would like to run the clustering algorithm seperately for each employee to receive his arrival-to-work clusters and to find his exceptions e.g., for the employee John who has the following arrival time records: 08:05, 07:55, 8:10, 8:07, 10:30, 10:31, 10:28, 15:00 I want to receive two clusters, the first one will include  08:05, 07:55, 8:10, 8:07 The second one will include 10:30, 10:31, 10:28 (and the exception will be 15:00) Having many employees I would like to create one data mining model and to use the cube slice and dice options    Searching the web and the MSDN I didn't find whether and how it can be done - I will very appreciate your help   Thanks in advance, Lora

View Complete Post

More Related Resource Links


Hi  I am a newbie for data mining. As part of a project I need to categorise a set of customers of a grocery based on their age, gender, and average spending. I believe I should use the Clustering algorithm. I created a mining model a structure and a cube as well from the existing data base. But i can't get much further than that. What kind of queries should i write to "cluster" the customers and get their relevant clusters??  

Would you use clustering to find documents similar to this one?

Hi, I am taking a BI Developer course and enrolled at a school where the teacher knows nothing about data mining. So I designed a project for myself and am trying to surmount the curve without the benefit of a mentor. Please have patience with me. I have a database full of documents where the entire text resides in a single field (nvarchar(max)) I want to find documents that are similar to the one I pick. I am not sure what approach I should take to get there..         1) create clusters for the entire database and then see what cluster my document is in OR                 2) some-how train a model on the single document and then let the DM engine go find the matches.   I have tried approach 1, but the similarity between the documents is not very high (at least in the few of thousands I looked at) I do not see how to do approach 2, unless I cluster with a test set size of 1, and that doesnt seem right.   Is clustering even the way to go?   Thanks, struggling in Austin

Getting Below error while accessing SQL server cube

Getting Below error while accessing SQL server cube   Error Generating Drop Down Values   Odbc driver returned an error (SQLExecDirectW).   Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. URL: http://SIMAPPWQS99/olap/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000) SQL Issued: SELECT "- AppReceivedTimeYQMDD"."Year" FROM "Medicare E2E Tracking" ORDER BY 1

Pie Chart - possible to order the slices?

Is it possible to order the slices in a Reporting Services 2008 pie chart, so that they are in order of magnitude (size) from largest to smallest?   Thanks, Chris

Restore - Cube Analysis Services 2005

Hi, I'm from Brazil. Sorry for my English. I made a backup for my cube that has more than 2 GB, but de backup is created with only 50 mb. The backup don't showed erro message. I restored this backup without erro, but when I tryed query the cube, i receive this message: The query could not be processed: o File system error: The following file is corrupted: Physical file: \\?\C:\SQL Server\MSSQL.2\OLAP\Data\teste.59.db\"Nome_Servidor" - "Nome_Database".190.cub\Fato Inadimplencia Safra Contrato.190.det\Fato Inadimplencia Safra Contrato.167.prt\172.fact.data. Logical file . Someone can help? I realy need make this backup.Fabrício França Lima | MCP, MCTS, MCITP | Visite meu site: http://fabriciodba.spaces.live.com/ | Dicas de artigos SQL: Siga-me no twitter @fabriciodba.

Cube Processing Error

Hi All when i process the cube some times i get the error  "OLE DB or ODBC  Error: Operation Cancelled; HY008. Internal Error: The Operation Terminated unsuccessfully  " https://connect.microsoft.com/SQLServer/feedback/details/286505/error-in-processing-cube?wa=wsignin1.0 In above link Microsoft they said to increase Query time out, i made it 0 even it repros I am using SQL Server 2008.   Thanks

Instant Refreshment of Cube

HI All, Is that possible cube get refreshed as soon as data updated into the relation database?   Kindly Suggest Regards Amit

How to determine when the cube refresh has completed?

I'm trying run code after a cube refresh is completed, but I can't seem to figure out how to write code to determine when the cube refresh has been completed. If it were a simple calculation, I could use the code below to determine the "calculation state", but there doesn't seem to be "refresh state" that I'm aware of. Any help will be GREATLY appreciated!! Application.CalculationState = xlDone

OLE DB Error: Network-Related or Instance-Specific while Deploying SSAS 2008 Cube

Hi, I encountered the below listed error while attempting to deploy SSAS 2008 DB: Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [5]. ; 08001.  0 0  I am running a standalone MSSQL 2008 named instance on Windows Server 2008 R2. Here are the steps I have taken but yet the issue is not resolve: 1) Enable Remote connections on the server 2) Enable TCP\IP 3) SQL Browser is Running 4) Set Firewall Inbound Exceptions for SQL Browser, Default Port 1433, UDP Port 1434 5) Using Management Studio I can successfully connect to the MSSQL named instance from the app server 6) I can ping I MSSQL box from the app server 7) Read and implemented all steps in the MSDN post below: http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx Thanks for your help.

SQL 2008 R2 Full Clustering

I was recently informed during a Microsoft Roadmap meeting that SQL2008R2 can now be fully clustered. That is full load balancing across SQL servers not just Failover. However, having come away from the meeting and done some investigation I cannot find any references as to how to setup SQL2008R2 in anything other than a failover cluster. My question is ... Is SQL 2008 R2 fully clusterable ... and if Yes where can I find some documentation helping with its setup ?   Thanks in advance Derek

20,000 foot view: Sql Server clustering vs. Windows OS Clustering

I read that Sql Server Failover requires Windows Sevrer clustering to be in place first. (The former builds on the latter). Why is this the case? In other words, what does "sql server clustering" bring to the mix  that normal Windows clustering doesn't supply? TIA, Barkingdog  

troubleshooting clustering

i need step by step for installations of clustering in sql server 2008 environment? please help me on this.

Clustering of Sql server

Hi Everybody, please answer this questions this will be very helpful to me     1. discuss at a high level how to add a new node to an existing SQL cluster in both SQL 2008 and SQL 2005. Begin with SQL 2005.   2. You are a DBA.  The SAN Admin has provisioned a LUN on the SAN and presented it to the nodes and made it clustered storage. At a high level, in either 2005 or 2008 walk through adding the new storage to the SQL instance and what is very important not to forget?   3. Beginning in 2005, there is a SERVERPROPERTY we can now use in T-SQL to discover which node the SQL instance is running on?     Thank you Regards rcnj

Problem in Cube processing

Hi All, I have created cube and processed with the setting "Stop Logging",and it would take 30 min to complete processing with the error shown  Error in Olap storage engine The attribute key cannot found when processing table "Factcalldata", column programid,value 7070.the attribute is Programid.   Kindly let me know is this is the reason which is responsible for Longer processing Time ,i have created partition and aggregation in all measure groups.   Regards Amit  

Creating a 3D cube and display content on each side

Dear all, I would like to show different content in each of a cube face that I can manipulated in space. My customer has see this in a desktop 3 D application somewhere on the net and would like to have this integrated in my applciation I am really interresting to integrate this has it is a good customer but have never done it Does any one have a done this already or sample for doing it ? regards SergeYour knowledge is enhanced by that of others.

Retrieve cube data directly from Relational database - is this possible?

I have a cube created in SSAS R2 2008. Now i would like to retrieve some data from this cube, using MDX language, and then to process it in Relational SQL database! Is this possible? I am new in SSAS, please help!  

Cube processing

HI All, I am new to SSAS and but i suppose to work on cube part. I have created cube with two partition both of 5 days using getdate()-10 to getdate()-5  and getdate (4) to getdate() ,,,,so tel me if i process full cube once and then other partition in full process,then will the 5 day process data overite the full data into 5 day data or not.   regards Shraddha
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