On-Line Analytical Processing, a class of systems designed for fast calculation, reporting and analysis of aggregate figures.

learn more… | top users | synonyms

2
votes
1answer
66 views

Update Cube data

We are using OLAP in our Project. We are facing a scenario where we need to update the cube with real time data on daily basis. I need some suggestions about an optimal way for updating the data in ...
1
vote
1answer
54 views

Having Non-Numeric values as measures in Fact table

According to my research regarding having non-numeric value as measures, I found that having non-numeric won't be an optimal one. So I planned to maintain numeric values. My scenario was "Employee's ...
0
votes
0answers
55 views

CREATE OLAP server

I have a MySQL database server along with replication server, i.e. OLTP system altogether. As I have very heavy data fetching queries for the decision making reports. I need to create data-ware house ...
0
votes
1answer
116 views

How to change a web application that now needs to become OLTP and OLAP application?

Previously, I did a simple web application for an enterprise client using PHP and MySQL. After some time, it has grown to a point where I realized after talking with people here that I need to treat ...