Fsldiscover
Member
Hi I am very new in JDE. sorry if I ask dump question.
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
My question is
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
- [FONT=Lato, sans-serif]Create the database view TEST.FD55134[/FONT]
- [FONT=Lato, sans-serif][/FONT][FONT=Lato, sans-serif]Grant all on TEST.FD55134[/FONT] 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?