BI4ALL

BI4ALL relaunches Analytics & Big Data Forum

In this great event, several testimonials from experts have demonstrated how they implement strategies that allow us to innovate, compete and capture value in this competitive market.

Blog

Query optimization – Scalar vs Table Valued Functions

Recently we were given the task to optimize an ETL batch load in order to reduce its execution time and fulfil the ETL load window.

Blog

Implementing Analysis Services “Process Add” Functionality – A Simple Approach

I was given the task of improving a 60GB SSAS (SQL Server 2008 R2) database process time. Applying a Full Process to this database takes about 1h and the end user needs a data refreshment every 3 days (on average). But is "Full Process" really necessary?

Blog

SSAS Dynamic Security Roles with MDX ERROR

These days the standard way to implement the dynamic security requirement in SSAS requires you to build a User Dimension to store all the UserNames that will have permissions and a Bridge table that relates the User Dimension to Dimension X (the one we want to secure the Members), but when someone complains that it cannot see something, how can we debug the issue?

Blog

SQL Reporting – Custom Permissions versus Linked Reports

«For that same report, I need that the group of users “X” sees only Data “X” for input-parameter named “param1” and that group “Y” sees only Data “Y” and “Z” in that same input-parameter. And the data in the report table must be filtered for group “Y”» Well, it seems that we have to conditionate the user-input with the user who tries to access the report… How ?!

Blog

Usefull Tips in SSIS (Part I)

How many times do we need to create several “Execute Package Task”, and need to create several components, for example in an extraction package?

Blog

How to develop a Many to Many SSAS Multidimensional Database

Imagine that we are developing a DW solution for a business that has the following concepts:

1 … 23 24 25 26