Search Results: dim date

• 
  Create Date Dimension with Fiscal and Time

  Here are three scripts that create and Date and Time Dimension and can add the fiscal columns too. First run the Dim Date script first to create the DimDate table. Make sure you change the start date and end date on the script to your preference. Then run

  Author:  MikeDavis     Date: 2/4/2011     Section: Blog

  tags : date, Date Dimension, dim date, dim time, dimension, fiscal, time, ssas
• 
  Script to load Dim Date and Dim Time

  Here is a script to create a Dim Date and Dim Time table in a data warehouse. I did not write this script but it is a popular request and seems to be hard for people to find on other sites. So I thought I would post it here to make it easier for people to

  Author:  MikeDavis     Date: 1/4/2011     Section: Blog

  tags : Create Dim Date, Date, Date Dimension, Dimension, Load Dim Date
• 
  Cube Design

  I created a sample data warehouse using the values you gave above. The only problem was the SK on the budget table. I had to create a row on the budget table to match the new sk's in the fact table. I was able to build and deploy the cube and I can browse

  Author:  MikeDavis     Date: 2/2/2010     Section: Forum

  tags : cube, dimension, fact, measure, SSAS
• 
  SSAS Calculation to Pull Previous Month Last Day

  Okay...so I added a End_Of_Month column to my date dimension. So now, for example, take December 15, 2009, my values are: Primary Key (int): 20091215 Date: 12/15/2009 End Of Month: 12/31/2009 My FACT table contains the bank account data such as Credit Lim

  Author:  EGAN     Date: 1/28/2010     Section: Forum
• 
  Mdx query to retrieve measure for working days in a month

  Hi Projack. Before I continue, allow me to say this: Multi dimension analysis, as SSAS, is intendend to aggregate information and display in reports/dashboards. In your case, seems that your time table isnt aggregate. You should have time dimension in day

  Author:  marcoadf     Date: 1/10/2011     Section: Forum

  tags : date code, dim date
• 
  SSRS Reporting- Charts with Analysis Cube

  Hi Mike, Thanks to reply... .. ... For me its fine if i get 2 date parameters and evaluate them on expression as you suggested. My problem is In mycube I am using Dim Date and Dim Time Two seperate dimensions. For these to Dimensions i have no releations.

  Author:  vineet_bidn_dubey     Date: 1/29/2011     Section: Forum
• 
  Named Set - Mdx script for current Month

  Shilpa, I would like to suggest you go with CAL YEAR MONTH dimension data looks like this 201001 201002 201003 201004 Only. Thanks, Nagen

  Author:  wwwnlc111     Date: 3/3/2011     Section: Forum

  tags : dim date, FISCAL, MDX, SSAS