| migrate discoverer reports to powerbi [message #672328] |
Thu, 11 October 2018 08:31  |
desmond30
Messages: 41
Registered: November 2009
|
Member |
|
|
I am being assigned the task of migrating set of existing discoverer reports to micrsoft powerbi
My question is this:
1. Is it as simple of extracting the sql from the discoverer files and using those sql in the powerbi (or whichever tool I am migrating the reporting to ?)
2. During this migration, does the "EUL Layer" play any role at all, or can I totally ignore that layer and just use the extracted sql from existing discoverer ?
|
|
|
|
|
|
|
|
|
|
|
|
| Re: migrate discoverer reports to powerbi [message #672342 is a reply to message #672328] |
Fri, 12 October 2018 01:22  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Are you familiar with Discoverer? What the End User Layer is, and how it is generated? You can be reasonably certain that Power BI will not have any facilities for maintaining it. I would suspect (knowing nothing about the product) that Power BI has its own similar function: a means of generating a set of views that will present data to users in a meaningful fashion.
I would guess (and it is only a guess) that you will need to design your Power BI environment from the the beginning, discarding the Discoverer configuration.
|
|
|
|
|
|
| Re: migrate discoverer reports to powerbi [message #672349 is a reply to message #672346] |
Fri, 12 October 2018 03:33 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
Yes, that is all it is: views in a schema that anything can query. But Uncle Oracle has (of course!) wrapped it up in massive administration structure, and I really wouldn't want to query the views directly. There is too much chance of mis-interpreting data. For example, if rows are never deleted but rather flagged as "inactive", will the views include or exclude them? Power BI will not know, Discoverer would. That sort of thing would make me inclined to start again with a new tool.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
