Business Intelligence & Data Warehousing

All blogs, page 6

Practical blogs about SQL Server, data warehousing, Power BI and reporting. With the code.

SELECT*FROMsqlblog.blogsORDER BYdateDESCOFFSET125;

  • 134blogs
  • 1,673,558reads
  • 72comments
  • 2008first blog

  1. Recursive Query with CTE I

    I recently ran into a problem that I found interesting enough to put on my blog. It covers a common situation where you use a dataset several times, also called a ...

    SQL Server7 Nov 2008 · 4.7k reads
    4.7k

  2. Passing a multi-value parameter to a drillthrough report

    This article describes how to pass a multi-value parameter from report A to report B the easy way. I fiddled around with it for a long time myself to get it working. The ...

    Power BI3 Nov 2008 · 3.3k reads
    3.3k

  3. Parameter security when exporting to Excel

    Parameter security In our environment we use an ASP.NET web portal to offer reports, which are all made in Reporting Services 2005. The security with regard ...

    SQL Server17 Sep 2008 · 3.3k reads
    3.3k

  4. Divide by zero SSRS / division by 0 #error

    Division by 0 is not allowed in Reporting Services/SQL Server. With this simple formula you can prevent division by 0, so the #Error message no longer appears in your report. This formula ...

    Power BI12 Aug 2008 · 5.5k reads
    5.5k

  5. 'Show All' in a parameter box

    Say you want to use a parameter in your report with, for example, the names of the countries where you have customers. You will often want a choice in your ...

    Power BI3 Aug 2008 · 3.3k reads
    3.3k

  6. Convert a date to an integer

    In data warehouse land we use integers as primary keys for the date in our date dimension. So we store the date "2008-12-01 00:00:00.000" as "20081201". This lets you ...

    SQL Server26 Feb 2008 · 7.4k reads
    7.4k

  7. The 3 best ways - Find a column in a SQL database

    You want to find a column in one of the tables in your SQL Server database. Your database has a few hundred tables. Expanding all the tables to look for the column can be a time-consuming job ...

    SQL Server23 Jan 2008 · 18.6k reads
    18.6k

  8. Hierarchies in Analysis Services 2005

    Everyone knows them: hierarchies in Analysis Services 2005. With a hierarchy you can show certain data to the end user at different levels. A well-known example is: Year -> Quarter -> ...

    Data Warehousing21 Jan 2008 · 3.9k reads
    3.9k

  9. SSIS error reporting with Event Handlers

    When an error occurs in your ETL package, as a data warehouse administrator you also want to know what went wrong and when. When you use an event handler, an e-mail can for example ...

    Data Warehousing3 Jan 2008 · 3.4k reads
    3.4k
(9 rows affected)sqlblog.nl