search

t27duck / active_reporting

OLAP-like DSL for ActiveRecord-based reporting
MIT License
136 stars 19 forks source link

[FAQ] has_many relationships do not work #6

Closed kirantpatil closed 7 years ago

kirantpatil commented 7 years ago

Hi,

You made changes to README file 4 months ago.

Does has_many relationships still not supported ?

Thanks.

t27duck commented 7 years ago

That is correct. The nature of ROLAP commonly does not work with has_many relationships. There's not really much one can do to "support" a one to many relationship for reporting.

The only real option would be to implement, on the database side, what is called a "bridge table" or an "intermediate table". There are many examples and tutorials regarding this pattern for BI / ROLAP.

kirantpatil commented 7 years ago

Thanks.