Fsldiscover
Member
I was given a SQL ( select statement with outter join, left join, right join on 7 table). I need to write a report and csv file base on all the column from this SQL . I found this ( ID 640352.1 ) from my oracle support.
It said that is possible by doing this
Create the database view TEST.FD55134
Grant all on TEST.FD55134 to public;
create E1 table with same name FD55134, save and close the table design Aid
now the E1 table is the database view
now you create E1 Business views on this E1 table. To further create reports..
My question is
What if I have to modify the database view after the report is created using this view ( through business view )? The change could be update / remove condition in the view .. or adding new column, join new table...etc Will my report still work without doing anything? or I need to re-create the report from ground zero? or????
As usual, we have DEV, TEST and PROD environment. As I can image, the database view and Grant should be run for all three enviornment like DEV.FD55134, TEST.FD55134 and PROD.FD55143. How about the business view and report? I don't think I have to worry about this right?
It said that is possible by doing this
Create the database view TEST.FD55134
Grant all on TEST.FD55134 to public;
create E1 table with same name FD55134, save and close the table design Aid
now the E1 table is the database view
now you create E1 Business views on this E1 table. To further create reports..
My question is
What if I have to modify the database view after the report is created using this view ( through business view )? The change could be update / remove condition in the view .. or adding new column, join new table...etc Will my report still work without doing anything? or I need to re-create the report from ground zero? or????
As usual, we have DEV, TEST and PROD environment. As I can image, the database view and Grant should be run for all three enviornment like DEV.FD55134, TEST.FD55134 and PROD.FD55143. How about the business view and report? I don't think I have to worry about this right?