what is the diference between ReportNet and PowerPlay?
RN is ROLAP and Powerplay is MOLAP..
Srik
thanks for reply.
Could you be more spesific? I am not very familiar with ROLAP and MOLAP.
they both are used for developing reports.
ROLAP = Relational Online Analytical Processing (Transaction-type environment)
MOLAP = Multidimensional Online Analytical Processing (rolled-up and summarized by dimensions)
Although I believe that ReportNet can cater to both environments, PowerPlay is better suited for MOLAP reporting.
ReportNet:
- Metadata modeling -> you don't change the actual data, all data remains in your transactional database or DWH, CRN just makes realy complicated queries.
- More intended for reporting (a lot more people just look at the reports without adjusting them)
- Better for layout
- Slow and bad preformance (comparred with PowerPlay)
- if your data changes, the reports change to (interactive html ofcourse)
- 'easy'
Powerplay:
- Dimensional modeling -> you pull the data from the datasources and put them in a cube
- More intended for analysis (more people adjust the reports than just looking at them)
- More advanced features
- More powerful
- Faster (doesn't depend on slow datasources)
- Almost no layout possibilities
- 'harder'