Business intelligence

What is staging area?

Posted on 12 February 2010

Staging area is place where we hold temporary tables on data warehouse server.  We need staging area to hold the data , before loading the data into warehouse. For example if we collect data from 3 different sources we can store in staging area data from 2 databases and wait for data from third source. Continue Reading

Comments (0)

On Serbian language

Distinct count – problem sa performansama

Posted on 24 January 2010

Ako imate fact tabelu sa velikim brojem slogova (reda 100 miliona) moze vam se desiti da vam se sql server 2008 zaglupi prilikom procesiranja kocke. Distinct count je veoma zahtevna operacija koja postavlja select upit nad fact tabelom i koja na kraju radi order by. Kada pravimo distinct count meru najbolje je da nju stavimo [...] Continue Reading

Comments (1)

Business intelligence

Distinct count bk from dimension table type scd2

Posted on 21 January 2010

Sometimes we need to count distinct number of bk values from dimension table in some period in fact table. One of possible solutions is to put that bk value from dimension table directly to fact table as a new measure in new column. Then make new distinct count measure from it. Continue Reading

Comments (0)

On Serbian language

Distinct count bk-a u dimenziji tipa scd2

Posted on 21 January 2010

Verovatno ste do sada imali slucaj kada ste trebali da prebrojite broj razlicitih proizvoda u fact tabeli za odredjeni vremenski period. Ovde se javlja problem kod dimenzija scd2 tipa. Uzmimo dimenziju DimProizvod kao primer. Ona ima svoj key i bk. Key kolona spusta kljuc na fact tabelu. Nama treba broj bk-ova (distinct count) proizvoda iz [...] Continue Reading

Comments (0)

Business intelligence

When to use indexes in data warehouse

Posted on 24 December 2009

In this post I will write about my experience with indexes performance on data warehouse database. Question is quite simple. When, where and on which columns to create indexes on dimension and fact tables to speed up performance? I make several tests with my friends, and conclusion is next (continue to read). On every dimension table put index [...] Continue Reading

Comments (0)

Business intelligence

How to calculate distinct count where value is not zero

Posted on 22 December 2009

With this simple calculated member you can calculate distinct count of something where value is not zero. DISTINCTCOUNT(filter([Something].[Something].members, [Measures].[Value]<>0)) Continue Reading

Comments (0)

SEE MORE ARTICLES IN THE ARCHIVE

Advertise Here
average calculated member bad excel 2007 performance with olap cube basic navigating hierarchies best data warehouse best practice data warehouse best practices for large data warehouse bi cemu to sluzi bi project and visual studio 2008 freezes brojanje dimenzije kroz drugu dimenzionu tabelu database tools distinct count bk scd2 distinct count problem sa performansama eipix help indexes on data warehouse loše performanse parent child dimenzije matic aleksandar game mini dimenzija multiselect u excelu kod kalkulisanih membera navigating hierarchies osnove business inteligence parent child dimension parent child scd2 type poor performance with parent child dimension prelazak sa parent-child na redovne dimenzije problem scd2 parent child dimenzije problem with excel 2007 projektovati dimenziju recursion in calculated members rekurzija kalkulisanog membera relationships between members scd2 dimenzija sp2 for excel 207 Speed up you fact table performance staging area starcharger starcharger game postmortem uspesna dimenziona tabela uvod u business inteligence visual studio 2008 freezes when the procedure was last changed Windows 7 and MS SQL 2008 problem windows 7 i MS SQL 2008 ne radi
Advertise Here

Tags

average calculated member bad excel 2007 performance with olap cube basic navigating hierarchies best data warehouse best practice data warehouse best practices for large data warehouse bi cemu to sluzi bi project and visual studio 2008 freezes brojanje dimenzije kroz drugu dimenzionu tabelu database tools distinct count bk scd2 distinct count problem sa performansama eipix help indexes on data warehouse loše performanse parent child dimenzije matic aleksandar game mini dimenzija multiselect u excelu kod kalkulisanih membera navigating hierarchies osnove business inteligence parent child dimension parent child scd2 type poor performance with parent child dimension prelazak sa parent-child na redovne dimenzije problem scd2 parent child dimenzije problem with excel 2007 projektovati dimenziju recursion in calculated members rekurzija kalkulisanog membera relationships between members scd2 dimenzija sp2 for excel 207 Speed up you fact table performance staging area starcharger starcharger game postmortem uspesna dimenziona tabela uvod u business inteligence visual studio 2008 freezes when the procedure was last changed Windows 7 and MS SQL 2008 problem windows 7 i MS SQL 2008 ne radi

Recent Posts

Get Adobe Flash playerPlugin by wpburn.com wordpress themes