Dt: 10 Mar 2013.
Have you ever tried real time reporting using OBIEE.When I say realtime reporting I mean using the OLTP rather than OLAP databases for reporting.
We are designing a solution where in we are trying to replicate a OBIEE report from OLAP to a realtime report in OBIEE ,effectively trying out to remove ETL from the equation.
This is very much possible and we were able to replicate most of the functionalities.But even as we were creating the report we came to know about why OLAP is preferred for reporting and what advantages it provides.
For starters the zero wid dimensional record helps in accomodating those records in the fact which do not have reference to a particular dimension.This is difficult to replicate in realtime reports withou adding a view to the source table adding a zero reference record.
Also we faced considerable challenges in drilling from a realtime report to a transactional report in OLAP.This is all the more difficult as OBIEE drill down works in a very rigid manner requesting the prompted columns on which the drills are developed to have the same column names in both subject areas.
We are putting in a effort to resolve this .In the meantime if anyone of you out there has attempted it then please share your findings.Real time reports can be a boon to clients ,especially in business where the transactional database is not too busy and can accept reporting queries without affecting transaction speeds.
Have you ever tried real time reporting using OBIEE.When I say realtime reporting I mean using the OLTP rather than OLAP databases for reporting.
We are designing a solution where in we are trying to replicate a OBIEE report from OLAP to a realtime report in OBIEE ,effectively trying out to remove ETL from the equation.
This is very much possible and we were able to replicate most of the functionalities.But even as we were creating the report we came to know about why OLAP is preferred for reporting and what advantages it provides.
For starters the zero wid dimensional record helps in accomodating those records in the fact which do not have reference to a particular dimension.This is difficult to replicate in realtime reports withou adding a view to the source table adding a zero reference record.
Also we faced considerable challenges in drilling from a realtime report to a transactional report in OLAP.This is all the more difficult as OBIEE drill down works in a very rigid manner requesting the prompted columns on which the drills are developed to have the same column names in both subject areas.
We are putting in a effort to resolve this .In the meantime if anyone of you out there has attempted it then please share your findings.Real time reports can be a boon to clients ,especially in business where the transactional database is not too busy and can accept reporting queries without affecting transaction speeds.
Thanks for the post. Can you please share me your email id or add me ajay.vaddepelli@gmail.com
ReplyDelete