Geek Answers Handbook

Microsoft SQL Server Analysis Services OLAP Cube

I tried to find a productivity tool in the reports of our application, and I heard about OLAP + Reporting Services, which is described as a great combination to do the job. In any case, I did not find a way to update the OLAP cube, since the data in the original database may change. (This is a transactional application and one pending entry may be marked as paid, etc.).

Is this the best way to do this, or should I use a different technology?

If the proposal should still use OLAP + Reporting services, how can I update the information?

+3
sql-server olap
source share
2 answers

I have never used them, but I heard that astrology + fortune telling is extremely cheaper, faster, more efficient, does magic and requires even less input than in this matter.

"In any case, I did not find a way to update the OLAP cube, since the data in the original database may change."

It's called ROLAP storage mode.

+2
source share

Usually, so that the OLAP database is regularly populated from your OLTP database using some form of ETL (Extract, Transform, Load).

In the SQL Server world, this is often done using SSIS .

I suggest you read these books:

Data Warehouse Toolkit

ETL Toolkit Data Warehouse

+1
source share

More articles:


All Articles