|
|
-
|
|
I recently had a need to use recursive Common Table Expression (CTE) query to meet a real business requirement.
Before I get into my real business situation, I want to blog about a couple of simple examples of using recursive CTE I found on beyondrelational.com (Google tsql challenges). I don&rsqu......
|
|
-
|
|
In my SSRS #42 post, I blogged about how you can kick off a timed subscription at the end of your ETL process.
Before you go off to implement this for your reports, I want to blog an issue with the SQL procedure AddEvent, which I used to trigger the timed subscription in the SSRS report.
Apparentl......
|
|
-
|
|
I haven’t blogged for more than a week now. That’s a little unusual for me. It was not because I had too much to do at work, it’s because I took on too much responsibilities (trust me there is difference between these two statements). I say yes to almost everything that business us......
|
|
-
|
|
Here is a nice article about AutoSys job scheduler.
AutoSys is used for defining, scheduling and monitoring jobs. These jobs can be a UNIX script, java program or any other program which can be invoked from shell.
As a BI developer, it’s important to understand how AutoSys works at high leve......
|
|
-
|
|
You have your SSRS report online, but business users want to receive the report as Excel file attachment in an email as early as possible in the morning.
Creating the Timed Subscription on the reporting server is simple. Even if you’ve never done it before, it’s simple enough that you d......
|
|
-
|
|
I’ve written three posts about how to create a drill down report that allows users start from a summary level and drill down to account details on the same report, without creating separate reports for summary and account level detail.
SSRS – How to toggle the details with Invisibility ......
|
|
-
|
|
I recently had a need to show three different view in a employee productivity report with the same data set, two summary views and one account level detail view.
For the two summary views, employees are listed regardless they have data or not in the date range. This will allow the report to do &ldq......
|
|
-
|
|
I’ve done ETL design and development in both integration projects and in reporting environment.
In master data integration projects, it’s not hard to distinguish staging area from the target area. In the staging area, truncating tables with old data and loading new data is a pretty comm......
|
|
-
|
|
Chapter 4 “Cleaning and Conforming” from Kimball’s The Data Warehouse ETL Toolkit takes about 50 pages, not an extremely long chapter. Here is a warning from the beginning of the chapter.
Please stay with us in this chapter. It is enormously important. This chapter
makes a serio......
|
|
-
|
|
I’ve written a post SSIS – Use “Foreach Loop Container” and pass a variable to a OLE DB Source in a Data Flow. I have to confess that I don’t use Foreach loop container very often. Actually I’ve only used it once in my entire SQL development life. I know how wonde......
|
|