on 04-01-2014 11:20 AM
While converting a Free Hand SQL report from Desktop Intelligence to Web Intelligence report in BI XI 3.1, I am faced with the problem
Not Converted : <REPNAME> - Free-hand SQL connection problem
It is be noted that there are some other Free Hand SQL Reports, that go converted and published without any error. The subject report has two Data Providers; one referring to the Universe and other from the Free Hand SQL tagged to a DB Connection
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajeswarudu,
As far as I know when a Deski report with Free hand SQL is converted into Webi, a universe is created with the SQL.
Which exact BO version are you using?
Is it happening with Deski reports which only have Free Hand SQL data provider and no universe data providers?
How many reports are giving this issue?
If you remove the universe data provider from the report (mentioned in the description) and try to convert it into Webi, does it work?
Regards,
Yuvraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Yuvraj
The version we are dealing with is BO XI 3.1 to BI 4.1. The RCT was initially done in 3.1 and we are experiencing problems in this version itself. RCT from BO XI 3.1 to BI 4.1 is a different ball game with it's own set of issues and hit a road block.
In the 3.1 RCT, we had converted bulk DeskI reports to WebI. We observed that every alternate report failed to convert. There are about 60 of them. The Report canvas, the data providers of standard universe, the FHSQL are almost the same between a pair of converted and non-converted reports. Only difference are Minor changes in the SQL SELECT, WHERE clauses and field selected from standard universe.
After lot of research and experimentation, I stumbled upon this blog http://scn.sap.com/docs/DOC-46238 and converted 18 reports using this technique.
Raj,
Conversion of free-hand SQL is NOT support at this time. There is NO assurance if free-hand SQL will convert.
Have at look at article that talks more about what is supported in conversion from DeskI to WebI
Regards,
Ajay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ajay,
Some more points that can be of consideration to you to help understand my problems.
Coming back to our issue, further probing into this aspect I stumbled upon this link meant for RCT for BI 4.0 version
where in Section 3.4.9, there is a mention of the limitation in conversion as under
I want to how the secured connection to the database in REPNAME2 is different from the subject report REPNAME1 as REPNAME2 got partially converted. The error reported for Subject report is "Free Hand SQL Connection Problem" and not conversion problem which can occur after the connection is established.
I did check the security properties of various FHSQL connections in the CMC and all of them are identical in nature.
Please advise
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.