I am currently working on budget reports through xi r2 Business objects. It is an initial phase of our development cycle, but I do have a print out of SQR scropt of the old report which I need to convert into free hand sql to generate bo report. Does anyone familiar with SQR reporting would like to share any ideas of this report conversoin. We are also starting to build a universe mapping on our new oracle environment to accomplish various budget reporting requirement. I will appreciate any insight and experience on this subject from our board members
Hi Nick,
I am also working on similar kind of reports.
Our client have People soft reports which are need to be converted into Webi Reports.
They have provided us with the sample report and the SQR code for that report.
We need to go through that SQR Code and understand the logic behind that report.
For instance if we are placing Section or Break in Webi,there in SQR code they say it BREAK while selecting the fields.
So you need to first get some idea of the SQR keywords,functions and then start understand the logic behind the report.
Then we developed a report template which list details of the report like
Tables being used
Formatting of the Heading,Footer,Column,etc…
Sections
Prompts
Variables
Mock up of report.
This way you have all the details you need to develop a report in Webi.