Rebuilt OBIEE DDR Reports to POWER BI

IM_1690 — Wed, 19 Feb 2020 06:28:00 GMT

Hi,

We have 100 OBIEE DDR Queries, we are replacing OBIEE reporting tool to Power Bi and Oracle database to vertica. As per my understanding we need to rebuild the reports in power bi.

OBIEE DDR Queries are long SQL Quires with multiple joins and where clauses, i wanted to know what the best practice will be to use these SQL Queries. Do I need to create 100 views at the backend (Vertica) to run these reports or there is any other ways to write the SQL quires directly on power BI.

We would be using the direct Query method as data size is huge.

Thanks

Sadapa07 if you can help me here as i find a simlar post of yours where you are migrating OBIEE to Power bi.

topic Rebuilt OBIEE DDR Reports to POWER BI in Developer

Rebuilt OBIEE DDR Reports to POWER BI