Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Date
1442 results found
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
Date
issue
I have a report that has a date parameter. Within the query I create a @DateFrom = to the first day of the month from the parameter and a @DateTo = to the last date of the month as follow: Declare @DateFrom date,@DateTo date if ltrim(rtrim(@pDate )) = ''
Author:
jmontani
Date: 3/27/2013 Section:
Forum
tags :
calendar
,
report
,
ssrs
Function to calculate end of month - SQL Server 2012 - new function EOMonth
As in my previous blog posts, I've been posting some new features in SQL Server 2012. In today's post, I would like to show you a new T-SQL function wich will lead you to solve a daily problem. So far, when you needed to get the last day from current mont
Author:
marcoadf
Date: 4/2/2012 Section:
Blog
tags :
end of month
,
eomonth
,
function
,
new features
,
new functions
SSAS Reporting Actions with
Date
Parameters
Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want to pass in some parameters to the report so it shows the relevant data. If the parameter name matches the item in excel then this is a br
Author:
MikeDavis
Date: 4/22/2011 Section:
Blog
tags :
Action
,
Cube
,
Dilldown
,
Report
,
SSAS
,
Reporting action
,
SSRS
MonthName function
The MonthName function seems not to be working properly: ==iif( IIsNothing(Parameters!pDate.Value), ""From " + format(First(Fields!DateFrom1.Value, "Process_Period"), "dd-MMM-yyyy") + " to " + format(First(Fields!DateTo1.Value, "Process_Period"), "dd-MMM-
Author:
jmontani
Date: 13 days ago Section:
Forum
tags :
calendar
,
MonthName
,
report
,
ssrs
Derived
Date
part function
Hi josephtys86 . Why cant you do it with datepart? you just have to make sure that you get all the expression, even if you must add 2 digits to make sure you get 2 numbers for hour, 2 numbers for minutes ans 2 numbers for seconds. For example: RIGHT("00"+
Author:
marcoadf
Date: 4/3/2012 Section:
Forum
tags :
concatenate hour
,
derived column
,
format date
,
hour
,
minute
,
second
Creating a Rolling
Date
Range Named set in MDX
Creating a Rolling Date Range Named set in MDX One Client I was working with wanted a named set that would give them the last 5 years. Of course this needed to be a rolling 5 years so it automatically moved the years up every January. To create this I use
Author:
MikeDavis
Date: 12/6/2010 Section:
Blog
tags :
Date
,
Date Range
,
Named Set
,
Rolling Date
,
MDX
Comparing Previous Rows in SQL
Comparing Previous Rows in SQL I had a client recently that needed me to get the direction a student’s GPA was headed on a regular basis. To do this I needed to get the last GPA record on the table and the previous GPA. The dates on these rows were differ
Author:
MikeDavis
Date: 4/1/2011 Section:
Blog
tags :
common table expressions
,
cte
,
PREVIOUS ROW
,
SQL
Use
Date
Picker Control with MDX Based Reports
If you've done a couple cube based reports, you've run into the issue of the dates being in string format. Because the dates are strings inside your cube, you can't use the neat little date picker control reporting services gives you for datetime paramete
Author:
DustinRyan
Date: 1/15/2010 Section:
Blog
tags :
calendar control in MDX report
,
date picker in MDX report
,
SSAS
,
MDX
Convert 24 Hour Time with SSIS Derived Column
If you want to convert the time part of a DateTime data type into common non-military time display of hour and minute with AM or PM with no leading zeros, you can use this expression in a Derived Column. It uses the DATEPART Function to get the appropriat
Author:
timmurphy
Date: 8/12/2011 Section:
Blog
tags :
derived column
,
expression
,
Time
Date
Filtering in Excel from your Analysis Services Dimension
I recently had to set up another Date Dimension and went through the process of setting up all the properties in the date dimension so that when it is used in Excel, the end users would then be able to use the Date Filters built into Excel. The Excel Date
Author:
guavaq
Date: 29 days ago Section:
Blog
tags :
Excel
,
SQL Server Analysis Services
,
SSAS
,
ssis
SSAS MDX Previous Year to
Date
Getting the YTD from a cube is a simple MDX formula either using the PeriodToDate function or using the YTD function. One request you may get it to see the previous year to date. So if you are looking at March 21, 2011 year to date, you want to see the ye
Author:
MikeDavis
Date: 6/23/2011 Section:
Blog
tags :
MDX
,
Previous Year to Date
,
Year to date
,
YTD
,
SSAS
How to validate a date within SSIS
If you're looking for ISDATE() - meaning is this date a valid date to store in a SQL Server DATETIME column - SSIS does not natively support that. I've seen a few solutions to this. One easy option is to handle this at your data source. I'm assuming that
Author:
KeithHyer
Date: 6/22/2011 Section:
Forum
tags :
data validation
,
date validation
,
SSIS
SSRS
Date
Parameter Help
We still have not found a solution to this issue using the date picker, however we have implemented a work around that allows for cascading parameters giving the user access to both pre-designated date ranges along with custom dates. The solution consiste
Author:
hendersonms
Date: 3/9/2012 Section:
Forum
tags :
Date parameter
Compare
Date
s Across Different Dimensions
Anyone know of an efficient way (Block Level Computation) to compare dates across different dimensions? Is it even possible, Logically? I can't seem to convince myself that it is, but I thought I'd ask just in case. [Order Dates].[Calendar Date Hierarchy]
Author:
feemurk
Date: 5/24/2012 Section:
Forum
tags :
Compare
,
Dates
,
Dimensions
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
MDX Named Set Rolling
Date
Range
In an Analysis Services Cube (SSAS), named sets can be used to filter data. One of the popular request I get for named sets are rolling date ranges. Here are some examples of rolling date range named sets I have created. There are several ways to make thi
Author:
MikeDavis
Date: 4/5/2011 Section:
Blog
tags :
Named Sets
,
Range
,
Rolling Date
,
MDx
Dimension "Process Update"
I am working in a scenario where I want to update certain cell values in the dimension tables (in the DW) and then bring those changes to the cube dimensions using "Process Update". I know there is a writeback option but I want to update my datawarehouse
Author:
az.asharma
Date: 7/6/2011 Section:
Forum
tags :
cube
,
Dimension
,
Distinct Count
,
Process Update
SUM function
Date
Range Selection
Dear Friends i, I have a requirement to select date range in SUM function based on another date dimension. SUM({[Date].[YYYY-MM-DD].currentmember >= [SomeDate].[YYYY-MM-DD].currentmember.lag(30): [Date].[YYYY-MM-DD].currentmember <= [SomeDate].[YYYY
Author:
djha
Date: 9/6/2012 Section:
Forum
tags :
:
,
DateRange
Simple calendar generator
In Internet exists many solution for generating calendar. Original idea I've found here but i've done some changes with using some SQL 2008 features Perhaps it will be useful for somebody. Fiscal calendar in our company contains 364 days per year and has
Author:
DMaletin
Date: 6/29/2010 Section:
Blog
tags :
T-SQL
,
SSMS
Parameter Default Value from a query
I would love some input. Problem: Setting a default start date for a date parameter based on value from another parameter. The users do not like the drop down list and wants to use the Date picker API. User can pick predefined Recurrence levels – Select a
Author:
Mitch
Date: 6/3/2011 Section:
Forum
tags :
Default
,
Parameters
,
Values from a Query
Dynamically executinmg the ssis package
Ok, I think I'm following now. You have 2 options that I can think of off hand ( there are probably more ): Option 1: You could set up a parameter on the package with a default value ( in your date format ) of "{0000}{00}{00}" ( 8 zeros ) - then use a der
Author:
KeithHyer
Date: 12/18/2011 Section:
Forum
tags :
conditional
,
derived column
,
inline if
Variable Expression - first day of current month
Sorry about that. I assumed since you said, "with no timestamp" that you meant you wanted it without any time on the end. To convert what either Daniel or I did to a datetime, create your variable as a DateTime data type and modify the expression with a t
Author:
KeithHyer
Date: 8/9/2011 Section:
Forum
tags :
datetime
SSIS: DTS duration (outside) & display it on Project
Hi. Sometime is very useful to know DTSs duration. In big DWs, we often get performance issues. Just for example, in one of my datamarts I have more than 110 DTS packages running each day. And with that information I can focus where to improve. I have 2 w
Author:
marcoadf
Date: 1/29/2010 Section:
Blog
tags :
DTS
,
Duration
,
Project
,
SSIS
Resolving #NUM error in excel
I was using excel to display data from a cube. I tried to do a caluclated cell in excel to display number of months between two dates. Here is the formula I used to do this. =Datedif(H1,G5,"m") But I received an error -- #NUM Then I again looked at the da
Author:
indupriya
Date: 2/22/2012 Section:
Blog
tags :
#NUM
,
#VALUE
,
Datedif in excel
Page 1 of 58 (1442 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
11
...
Next >>
Go to page:
[Go]