- 6.4k
SSAS OLAP is returning wrong results
Like the title says; my SSAS OLAP cube (SQL 2008R2) was giving me wrong results when selecting a combination of a measure and a fact. I was struggling for days with this issue. I called old ...
- 539.9k
How to implement Dimension Security in SSAS
I know it was not difficult to implement dimension security in Analysis Services. While it's not difficult, why did it cost me a lot of days to get this to work? Well, its because you have to do a ...
- 11.7k
Prevent Divide by Zero in SSRS
In a previous post , I wrote about how to prevent the divide by zero issues in Reporting Services. The problem with the custom code I used was that the code returned the value 0 when one of the ...
- 5.7k
Calculate Lost Customers using T-SQL
A common question in the Business Intelligence world from customers is "how many customers did we lose this year" ? Businesses wants to know this so they can act faster to keep customers doing ...
- 4.4k
How To Find the slowest SQL Queries
This stored procedure displays the top worst performing queries based on CPU, Execution Count, I/O and Elapsed_Time as identified using DMV information. This can be display the worst performing ...
- 4.1k
Interesting Course about data visualisation from Google
Do you work with surveys, demographic information, evaluation data, test scores, or observation data? Are you interested in making the data you collect more useful by organizing it, analyzing it, and ...
- 49.1k
How to Refresh Reporting Services Cache?
I am working for a client which uses a Datawarehouse in which the data is loaded once a day during the night. During the rest of the day, nothing changes in the datawarehouse. After a couple of ...
- 6.3k
Calculate time in hours and minutes between two dates
Sounds easy right? I want to calculate the difference in hours and minutes between two dates. A good readable notition for my report. I want a format like this: 00:36:53 OR 02:13:45 This can easy be ...
- 11.9k
SSAS: How to format a dimension attribute?
I was looking for a method of formatting a dimension attrbibute in SSAS2008R2 to, for example a currency symbol €. In search of this question, I found out this is not possible within the default SSAS ...
- 4.7k
Powerpivot architecture
Today I came across a nice page on the Microsoft site about the architecture of Microsoft Powerpivot.
- 3.8k
SSRS2008R2 - Keep Header Visible While Scrolling
When you build a report in SSRS2008R2 and you want the top header to stay in place while you scroll down, you would normally expect the option "Keep header Visible While ...
- 4.1k
Wrong dot and comma in SSRS
In SSRS you can set in a cell how the value should be displayed. This can cause some problems if you do not know how to change certain settings. The dot and comma can be displayed ...
- 4k
SSRS Sparkline: NOW and TREND
The SSRS sparkline is a powerful little chart that shows a trend at a glance. Google Finance, for example, uses the sparkline to show the price of a share over the day, while ...
- 4.2k
After update trigger
Sometimes it is useful to keep track of a modification date or modification user in a field, especially in a master data environment. You can use a trigger on a table for this. It must work both ...
- 4.7k
Calculate the nearest working day
Last week I had a nice challenge. In the KPI table I use for certain reports, only the normal working days are calculated, Monday to Friday. Public holidays are in there too. The ...
- 6.8k
Dutch public holidays in SQL Server
Sadly there is no standard function in SQL Server to check whether a date is a public holiday. To find out, it helps to use a date dimension as explained here ...
- 4.9k
Target line/StripLine in Reporting Services
In SSRS 2008 R2 you can add a target line to a chart. This is useful to show, for example, what the target is, so you can quickly see which values go over the target.
- 4.3k
Publish an Excel Pivot online
Today I found a nice article about publishing an Excel Pivot sheet online. I have not tested it myself yet, but I will definitely try it soon! ...
- 6.7k
SQL output in Excel shows millions
You will often want to copy the result of an SQL query to Excel and send it on, for example so someone can check the figures, or just as a simple list. You will then ...
- 5.1k
PowerPivot Format Percentage
In MS PowerPivot for Excel you can add your own calculations to your pivot table. A useful trick is to add the formatting you want straight into the formula. If you use a ...
- 12.5k
Calculate DateDiff With Only WeekDays or Workdays
Today, I was working on a fact table for my datawarehouse. I was looking for a function to calculate the number of " normal weekdays " between two given dates I had a record in my Dwh from a HR ...
- 5.7k
Centralizing KPIs in your data warehouse
You build brilliant reports with the best figures, revenue, productivity and KPIs. Over time more and more reports appear within the organization. Until someone suddenly notices that the ...
- 4k
Reset Ident Column in Database
This is a very handy little script to generate a script to reset the ident column of all your database tables. This can be handy after filling and truncating tables. This script uses a schema "ps". ...
- 4.2k
Script to count nr of rows in all tables
This script can be used as a view to count the number of rows in all SQL tables in your database. This can be very usefull.
- 50.2k
Calculate Weeks Between Two Dates using DateDiff
In SQL Server, there's a buildin function to calculate the number of weeks between two dates. This function is called "DateDiff". The problem with this function is that Sql Server thinks the week ...
(25 rows affected)
Completion time: