ReportNet and PowerPlay

[otsizh]

what is the diference between ReportNet and PowerPlay?

[BIsrik]

RN is ROLAP and Powerplay is MOLAP..

Srik

[otsizh]

thanks for reply.
Could you be more spesific? I am not very familiar with ROLAP and MOLAP.
they both are used for developing reports.

[bdybldr]

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.

[MrO]

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'