Blog Archives

I’ve consolidated my blogs into a single one under From now on I will publish new content only on this new blog under the Business Intelligence category. Please follow me in that new blog… Soon I will start publishing

Posted in Uncategorized

New Year… New life… New architecture

The new year is bringing big changes for me. Even though I’m still in the same company we have decided to bring a totally new BI platform, the good old SAP BW plus his companion the BO Suite. As I’m

Posted in Architecture, SAP

Excel 2013 Macro to set a filter

Recently I’ve been updated to Office 2013. Everything looks like is working smooth as always and even now Excel 2013 has a nice smooth effect when new data is displayed. While I was working on a new report I had

Tagged with: ,
Posted in Excel

Fact Tables with Multiple Dates

Tricky issue… You have a fact table that has more than one date. In our example the FactPurchaseDocument table. Each Purchase Document (PD onwards) has two important dates, Creation Date and Document Date (a.k.a Posting Date). Users some times want

Tagged with:
Posted in SSAS

Because is better to have a map…

… than to wander around with no clue where are you heading. Specially if you are in the middle of the SAP tables jungle. Download the SAP Tables Map: SAP Tables Relation Diagram

Posted in SAP

Memory monster SSIS Sort transformation

For a while I had an SSIS package being unable to complete in the production environment but which worked perfectly in development. To make matters more interesting the package will not always fail… oh! “Welcome back!” That was what I

Tagged with: , ,
Posted in Errors, SSIS

Use MDX in PPS KPIs before it is too late

We don’t like MDX… well I don’t. It is complicated, long and there are many ways to go around it to bother to learn it. But every now and then MDX is useful and with PerformancePoint Server I’ve found where

Posted in PPS

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 24 other followers