.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

Staff Shift Analysis

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server

We have a running SSAS project for Sales analysis and presently in need to integrate the staff shift with sales to analyze how sales peformes on diffenrt shifts (number of staffs on shifts, staff positions on shifts). The present cube is associated with a date dimension that has 24 hour break down per day. Staff schedule data schema is as follows

Shiftid     staffid          positionid           startdate       enddate             starttime        endtime

1            200              501                   1-jan-2010    7-jan-2010         08:00             16:00

2            300              502            &nbs

View Complete Post

More Related Resource Links

Toolbox: Static Analysis Database Tools, Managing Remote Computers, And More


If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.

Scott Mitchell

MSDN Magazine July 2009

Toolbox: Static Analysis Tools For .NET, Matt Berseth's Blog


This month we take a look at FxCop and other tools that enforce your design rules, along with jQuery.

Scott Mitchell

MSDN Magazine December 2008

Paradigm Shift: Design Considerations For Parallel Programming


This article presents an overview of the motivation behind new techniques that decompose problems into independent pieces for optimal use of parallel programming.

David Callahan

MSDN Magazine October 2008

Test Run: Competitive Analysis Using MAGIQ.


The goal of competitive analysis is to compare the overall quality of your software against similar systems. But it's not easy. Here James McCaffrey accomplishes the goal with the help of a little MAGIQ.

Dr. James McCaffrey and Nasa Koski

MSDN Magazine October 2006

Toolbox: Database job scheduling, Browser Analysis, and More


From a developer's perspective, once a database's schema has been defined and the tables, stored procedures, and other database objects have been created, it can be forgotten, abstracted away into the data access layer of the application's architecture.

Scott Mitchell

MSDN Magazine May 2006

Around the Horn: Engineer a Distributed System Using .NET Remoting for Process Intensive Analysis


Before the Microsoft .NET Framework, creating a distributed cluster of computers to perform scientific analysis was expensive in terms of hardware, programming and debugging time, and maintenance. You had to purchase expensive servers, spend time debugging network communication, design a distributed system completely different from a system deployed locally, and maintain a melting pot of error handling, data acquisition, networking, and analysis code. In this article, the author shows you how he was able to engineer a distributed computing system in C# to perform analysis of real-world data continuously acquired at high sampling rates, thanks to the .NET Framework.

Nate D'Anna

MSDN Magazine May 2005

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

Testing: Perform Code Coverage Analysis with .NET to Ensure Thorough Application Testing


When running your tests how do you know which parts of your product code are actually executed and tested? This article presents a complete system called Fundamental Function code coverage that operates at the method level. The author gives an overview of the system so you can understand code coverage principles, explains the key parts of the underlying code, and discusses how code coverage fits into the overall product development cycle. After reading this article you will be able to perform code coverage analysis on any .NET software system.

James McCaffrey

MSDN Magazine April 2004

OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP


Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003

Data Points: Techniques in Filling ADO.NET DataTables: Performing Your Own Analysis


How do you know which technique is best for retrieving data and populating a DataSet in ADO.NET?. Since the Microsoft .NET Framework offers so many choices on how to write the code, many developers are now taking a close look at the different options. See what they are.

John Papa

MSDN Magazine June 2003

Re-run WSS 3.0 Usage Analysis Logs


WSS3.0SP2, 64-bit.

The service which runs and collects the log files for the Usage Analysis report was disabled for some reason. We have it re-activated but the logs for when it was down were not processed. How do we re-process those older logs?

Previously asked at  http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.sharepoint.windowsservices&p=1&tid=f676c989-a369-4761-94e7-ef9b1c28fde7 and referred to here.

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.

I have added new fields to a table in SQLserver, why could not find these new fields in Analysis Ser

I have added new fields to a table in SQLserver, why could not find these new fields in Analysis Services database source view?  My version is 2005.

Help!!!! Permission issue with Analysis Services on Windows 2008 R2

Hi I'm with a project using Sql Server 2008 on Windows Server 2008 R2. It seems I can not connect to Analysis Services server with SA acount but only with Windows Authentication (The 'Authentication' option is diabled). And when I connect to Analysis Services with my windows acount , I do not have the permission to either create a database (ERROR:Either '***' user does not have the permission to create a new object, or the object does not exist) or grant server privilege to my windows account (ERROR: Only an administrator can make changes to server properties). Also, I failed to remote connect to Analysis Services on Server with my windows account (But I can remote connect to Database engine). Any idea?  Thanks!

How to get in which shift the maximum of time the employee falls?

DECLARE @CheckInTime AS TABLE(EmpID INT, InTime DATETIME, OutTime DATETIME) INSERT INTO @CheckInTime SELECT 1, '1900-01-01 00:50:00.000', '1900-01-01 08:50:00.000' UNION ALL SELECT 2, '1900-01-01 09:45:00.000', '1900-01-01 14:45:00.000' UNION ALL SELECT 3, '1900-01-01 14:20:00.000', '1900-01-01 22:45:00.000' UNION ALL SELECT 4, '1900-01-01 08:30:00.000', '1900-01-01 06:45:00.000' --SELECT * FROM @CheckInTime DECLARE @ShiftMaster AS TABLE([ShiftID] [int], [Name] [varchar](50) NOT NULL, [StartTime] [datetime] NOT NULL, [EndTime] [datetime] NOT NULL) INSERT INTO @ShiftMaster SELECT 1, 'G', '1900-01-01 09:30:00.000', '1900-01-01 22:00:00.000' UNION ALL SELECT 7, 'F', '1900-01-01 00:00:00.000', '1900-01-01 08:00:00.000' UNION ALL SELECT 8, 'S', '1900-01-01 08:00:00.000', '1900-01-01 16:00:00.000' UNION ALL SELECT 9, 'T', '1900-01-01 16:00:00.000', '1900-01-01 23:59:00.000' There is no relationship between @ShiftMaster and @CheckInTime. Here emp 1 should comes in F shift. He also falls in S shift. But he works more than F shift when compared to S shift Here emp 2 should comes in G shift Here emp 3 should comes in T shift (because he works more time in T shift) Here emp 4 should comes in S shift I wants to get (ShiftID) in which shift he works for more time. Thanks, Babu Kumarasamy.

Analysis Services Plugin using DMPluginWrapper with C#

I'm developing a desicion tree algorithm (CHAID) to be integrated as a plugin in SQL Server 2008 Analysis Services. It is almost done. The only thing that's missing in my implementation is the capability of testing the algorithm accuracy using any of the Mining Accuracy Chart. When I try to use these features, in my Visual Studio Business Intelligence Project, I get this error message: Query execution Failed Internal error: An unexpected exception occurred. COM error: COM error: DMPluginWrapper; Object reference not set to an instance of an object.. (Microsoft OLE DB Provider for Analysis Services 2008.) I think I'm not properly overriding a method or something like that. Since I have no documentation and no examples available, I'm not being able of detect where is the problem. Maybe some of you have experience developing plugin algorithms for SQL Server and have a clue of what I'm missing.   I know It's hard to help without seeing any piece of the source, but there're a bunch of files in the project. I've been reading and reading my source and I still don't know where the actual problem is.

SQL Analysis Service based Status Indicator

Can you help me on this error while i am trying to create sql analysis service based status indicator.. 1- I created a .odc file connection string from MS Excel 2010. 2- After that I uploaded that file to my sharepoint site data connection list. 3-  After that I Selected SQL Analysis Server Status Indicator & uploded a .odc file from data connection list. After uploading .odc file it shows an Error : Error :- "This data connection does not use encryption for the communication with the SQL Server Analysis Services server. It is recommended to enable encryption for the SQL Server Analysis Services server to help prevent unauthorized users from viewing this information." Sharepoint version :- 2010 Thanks and Regards, Faheem Ahamed
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