Search Results: time

• 
  SSRS: Information about reports ran

  Some times is very useful to gather information about report execution, for example: How often a report is requested Report duration time (slowest reports) User that ran more reports What formats are used the most This information can be achieved from Exe

  Author:  marcoadf     Date: 4/6/2010     Section: Blog

  tags : ExecutionLog, reports ran, reportserver, slowest reports, ssrs
• 
  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
• 
  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
• 
  How to create Day,Month,yearwise Cube in SSAS

  about time dimension, there is some posts about it. take a look at: Mike's post in2bi's post In SSAS, there is this link with a good tutorial on how to build time dimension in your as cube. If this helps you, mark post as answered please. Best regards.

  Author:  marcoadf     Date: 2/10/2012     Section: Forum

  tags : build, dimension, table, time
• 
  What’s New In Denali for SSRS

  I was so excited when I found out that Denali was released last week. Like it was Christmas time, I almost immediately went to download it and then I looked for what was new. J Unfortunately though, in the CTP that was released, there are no changes to Re

  Author:  briankmcdonald     Date: 11/23/2010     Section: Blog

  tags : Brian K McDonald, New in SSRS for Denali, SSRS, Denali
• 
  Report Render Duration

  Every once in a while I come across a scenario where I really want to know how long it took a report to render. This is often the case if the report is taking abnormally long, but some environments may want this kind of information included in its report

  Author:  briankmcdonald     Date: 6/15/2010     Section: Blog

  tags : Execution Duration, Report Run Duration, Reporting Services, SSRS
• 
  SSIS + CDC = SCD -- A PASS webinar on 20th December by Patrick LeBlanc

  I got interested in the title of this webinar and hence thought that all of you might be interested in this webinar event as well. Below are the details Date / Time Date: 12/20/2010 Start Time: 12:00:00 PM End Time: 1:00:00 PM Timezone: (GMT-05:00) Easter

  Author:  indupriya     Date: 12/16/2010     Section: Blog

  tags : Change Data Capture, SSIS webinar, webinar, Slowly Changing Dimensions
• 
  Estimated Completion Time for Backups and Restores

  I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show estimated time of completion for a database restore in progress on SQL Server. The script will also show you estimated time for database

  Author:  sqlchicken     Date: 12/30/2011     Section: Blog

  tags : administration, Backups, DBA, Restores
• 
  Chart synced with other data

  SSRS 2008 r2 I have 2 datasources, 2 datasets and 2 objects on the report. 1st object is a chart, 2nd object is a tablix Chart gets data from 1st dataset, x axis is time Tablix has some other data from 2nd dataset that I want to filter dependent on time p

  Author:  syale     Date: 4/9/2012     Section: Forum

  tags : parameters, syncs, tablix
• 
  EPM Framework and SQL Server 2008 R2

  This weekend at SQLSaturday 62 in Tampa, I presented my policy-based management presentation. During my presentation one of the cool things I cover is how policy-based management can be extended utilizing Reporting Services and PowerShell through the use

  Author:  sqlchicken     Date: 1/17/2011     Section: Blog

  tags : epm framework, epmf, framework, pbm, policy-based management, administration
• 
  Expression Based Interactive Sorting using Reporting Services 2008 – Part 2 Dynamic Sort By

  In a previous blog written back in June, I showed you how to use the interactive sort option on a table header text box using values returned from a data set. I also wrote this back in June, but it got lost in my “blogpile”. J At any rate, in this blog, I

  Author:  briankmcdonald     Date: 11/4/2010     Section: Blog

  tags : Brian K. McDonald, Expression Based Interactive Sorting, Reporting Services, SSRS
• 
  Awesome Reports Webinar Tomorrow at 11AM

  Here at Pragmatic Works, we enjoy putting on a show for the community. As can be seen by Training on the T’s (Tuesday’s and Thursday’s that is)! Tomorrow should be one of the most enjoyable Reporting Services webinars that you can learn some good tips usi

  Author:  briankmcdonald     Date: 6/30/2011     Section: Blog

  tags : Awesome Reports, brian k mcdonald, Sherri L McDonald, Sherri McDonald, sq, SSRS, Training on the t's
• 
  Two Digit Year Cutoff

  I couldn't sleep this morning and decided to wake up and catch up on my email when I noticed a video link from SQL Share regarding converting and the two digit year cutoff . It has been a long time since I had heard about this potentially critical issue w

  Author:  briankmcdonald     Date: 12/15/2010     Section: Blog

  tags : Andy Warren, Brian K McDonald, sp_configure, SQL Share, Converting Two Digit Year
• 
  Be the Master of your Data Warehouse Universe at SQLRally!

  Do you have a data warehouse initiative in your current organization and looking for a way to learn how to properly build and support it? Would you like to learn how to do this straight from the Masters of the BIverse themselves? Well you're in luck! Next

  Author:  sqlchicken     Date: 4/14/2011     Section: Blog

  tags : business intelligence, conference, data wareho, data warehousing, event, pre-con, training, sqlrally
• 
  fact table design questions

  What if you use something similar to type 2 dimension? As Mike says, you dont need to insert a row unless data gets changed. I would recommend you to add a start and end column. first time insertion: participationid isrolled start time end time 123 1 1/1/

  Author:  marcoadf     Date: 2/9/2011     Section: Forum

  tags : scd, type 2 dimension, SCD
• 
  Dealing with time duplicates

  I know I'm "late to the party" with this reply - and you may have already found a solution to this with DustinRyan's help. But if you haven't yet - a few things come to mind when I read your post. According to http://msdn.microsoft.com/en-us/library/ms187

  Author:  KeithHyer     Date: 7/21/2011     Section: Forum

  tags : conversion, datetime, lookup, redirect rows, smalldatetime
• 
  Pragmatic Tools Week: BIxPress

  Much like Tim "The Toolman" Taylor had his themed weeks, we’re going to do something similar. This week we salute: (play fanfare music here) the Pragmatic Works BI toolset . Today we're going to talk about BIxPress . I've previously posted on BIxPress and

  Author:  sqlchicken     Date: 5/9/2011     Section: Blog

  tags : software, tools, BIxpress
• 
  SQL Server 2011 (Denali) CTP3 Released!

  I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that I should probably wait until it is released…Hit the forward button…check…Make some modifications to blog…check… It is July 12 th , 2011 and finally…After m

  Author:  briankmcdonald     Date: 7/12/2011     Section: Blog

  tags : brian k mcdonald, SQL Server 2011 CTP3, sqlbigeek, Denali CTP3
• 
  Using SSIS and WinRAR to Zip Files in a Folder

  In this article, Brian will walk you through step by step instructions on how to create a package that will utilize the SSIS Execute Process Task to run WinRAR in order to zip up the files in a folder.

  Author:  briankmcdonald     Date: 6/17/2010     Section: Article

  tags : Execute Process Task, WinRAR, Zip Files, SSIS
• 
  SSAS customized error processing

  Sometime you want to load cube data irrespective of referential integrity issues. Suppose you are processing measure group data before corresponding dimensions then SSAS will throw error "The attribute key cannot be found" so question arises that in this

  Author:  sirfnet     Date: 1/11/2011     Section: Blog

  tags : custom error, SSAS error processing, SSAS tutorial, 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
• 
  SSAS lazy processing

  When we reprocess SSAS cube then it actually bring new/changed relational data into SSAS cube by reprocessing dimensions and measures. Partition indexes and aggregations might be dropped due to changes in related dimensions data so aggregations and partit

  Author:  sirfnet     Date: 1/12/2011     Section: Blog

  tags : Analysis services tutorial, Lazy processing, SSAS tutorial, SSAS
• 
  Limiting Table Access for Reporting Part 2

  In the first blog post of this series, I showed you how to create a database schema and how to create a view. In this post, I will wrap it all up and show you how to create a SQL Server login account. I will also show you how to give them access to the vi

  Author:  briankmcdonald     Date: 7/29/2010     Section: Blog

  tags : Locking users down, Permissions, Views, Brian K. McDonald, SQL Server
• 
  Un-SQL Friday: Branding

  So looks like we have another blog party on our hands, this time courtesy of Jen McCown ( Blog | Twitter ), one half of the MidnightDBA brand ! This is such a great topic especially coming from a couple who have built up quite a successful brand for thems

  Author:  sqlchicken     Date: 11/22/2010     Section: Blog

  tags : profdev, professional development, branding, unsql, unsql-friday
• 
  URL Based Images using SSRS

  For header images, I typically embed an image into the report. However, there may be times when you need to create a report that makes use images from an external location. In this quick and simple post, I am going to show you how to point to an image tha

  Author:  briankmcdonald     Date: 12/13/2010     Section: Blog

  tags : Brian K McDonald, External Images, SSRS, Reporting Services