Build Time Dimension - DevSharePoint.com

Build Time Dimension

Posted by sladescross on January 23, 2012

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/ae837cbc-90c5-4c79-8de4-f807441b74ce/

Create a store procedure in your DW database (datawarehouse).

Code Snippet

CREATE

PROCEDURE [dbo].[usp_Create_dim_Date_Table]

(

@StartDate smalldatetime = ’20080101′,

@EndDate smalldatetime =

... [read more]

Rating

not rated

Reviews

Submit a comment / review

There are currently no comments or reviews.

Submit a review:

Login required.

DevSharePoint.com
Categories
- SharePoint 2010 (451)
- SharePoint 2010 Extranet (3)
- Active Directory (12)
- SQL (100)
- Central Administration (245)
- SharePoint Server 2010 (28)
- Visual Studio 2010 (25)
- SharePoint Server (63)
- MOSS 2007 (18)
- Application Management (45)
- SQL Server (40)
- Project Server 2007 (2)
- MOSS (56)
- ASP.NET (22)
- InfoPath (32)
- Windows SharePoint Services (15)
- CAML (16)
- Web Part (39)
- Security (51)
- WSS (36)
Translate
SharePoint
Most Popular (7 Days)
- How to recover Unattached SharePoint Content
  
  For recovering Unattached SharePoint Content you n..
  By Adam Gorge
  on February 24, 2011
- Provisioning a Sharepoint Service Application Using Powershell
  
  http://sharepoint.microsoft.com/blogs/zach/Lists/P..
  By sladescross
  on November 2, 2010
- InfoPath Data Connection Wizard: Web Service Sample Parameter Error
  
  I came across an issue in an InfoPath (2007) form ..
  By GeorgeH
  on January 27, 2011
- How to Create List and Add Item to that List using SharePoint 2010 client object model?
  
  You can create a list and also you can add item to..
  By Fewlines4Biju
  on May 4, 2011
- CAML Query for Taxonomy Term
  
  http://pingpond.com/how-do-i-get-sharepoint-items-..
  By sladescross
  on March 18, 2011
- How to create a custom field type in SharePoint 2010 using visual studio 2010?
  
  There are default field types like Text, Note, Boo..
  By Fewlines4Biju
  on April 15, 2011
Recent Popular
- BCS Security
  
  http://blogs.msdn.com/b/bcs/archive/2009/11/24/..
  By sladescross
  on January 24, 2012
- BCS Infopath
  
  http://blogs.msdn.com/b/sharepointdev/archive/2..
  By sladescross
  on January 25, 2012
- BCS Develop the Model in XML and SharePoint Designer
  
  http://msdn.microsoft.com/en-us/library/ee81992..
  By sladescross
  on January 25, 2012