bad example of OLAP
One customer uses reports generated by OLAP but as I understand more about it, they do not have any reason to do this reporting by OLAP.
- Multi-dimentional analysis is not required for the customer (at least for now).
- But report generation takes so much time using OLAP.
- Transactions which fails to be linked in the fact table are very difficult to show in the final report output.
We've had so many problems with OLAP and I've had to do a lot of shirinugui. It's a pain but I need to find a way out of this situation.