Project Description: We need an expert in SQL Server 2005 and Analysis Services to help us solve the problems described below. We do not know the technology required to solve these issues ( assuming they are solvable), so it is anticipated that the coder will give us the proper technology choice based on the requirements. We must use all native SQL Server / .NET platform capabalities. No 3rd party tools unless approved by us before-hand. 1. We need a SQL Job that updates existing cubes in a SQL Analysis Services instance at prescribed intervals. We would prefer if the SQL job were configurable such that we can refresh different cubes at different intervals. For instance, refresh (process) cube 1 every 5 minutes, and refresh (process) cube 2 every 15 minutes. 2. We would like a C# class that allows us to create new cube definitions by calling the SQL API. We anticipate that we would give a table name, dimensions and measures as parameters to the method calls. Deliverables: For requirement 1, a working SQL job and all instructions to make it work in our environment. It is anticipated that the coder will need to be online to support getting this working. For requirement 2, a working C# console application written for .NET 3.5 in Visual Studio 2008. Anticipate minor changes as we work thru the requirements in more detail. Only experts in this technology should bid. We need this work done quickly with little supervision. We will provide sample DBs to work from.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
SQL Server 2005 / Analysis Services .NET 3.5 VS 2008 C#