Help me create a time dimension to my Cube in Analysis Services 2008 R2
$2-10 USD / hour
Đã hủy
Đã đăng vào hơn 12 năm trước
$2-10 USD / hour
%3cspan style%3d%22font-family%3a arial%2c helvetica%2c sans-serif%3b color%3a %23333333%3b%22%3eHello everybody%2c%3cbr /%3e %3cbr /%3e I%26nbsp%3bsuccessively created a cube in Analysis Services based from a SQL Server 2008 R2 database. I need someone to help me to create a time dimension with the following characteristics%3a%26nbsp%3b%3cbr /%3e %3cbr /%3e Fiscal Year %28FY%29%3a 10/01/YYYY to 9/30/YYYY%3cbr /%3e Calendar Year %28CY%29%3a 01/01/YYYY to 12/31/YYYY%3cbr /%3e Quarters %28Q%29%3a 10/01/YYYY to 12/31/YYYY%3b 01/01/YYYY to 03/31/YYYY%3b%3cbr /%3e 04/01/YYYY to 06/30/YYYY%3b 07/01/YYYY to 9/30/YYYY%3cbr /%3e Months %28M%29%3a Calender months%3cbr /%3e Any specific date range%3a example. 07/21/YYYY to 9/12/YYYY%3cbr /%3e %3cbr /%3e The new time dimension needs to be created at the server level and then related to an existing dimension.%26nbsp%3b%3cbr /%3e %3cbr /%3e Please state your experience in DW/BI using Analysis Services/ SQL Server 2008.%3cbr /%3e %3cbr /%3e Thanks%21%3c/span%3e