But I’m designing reports through WebIntelligence. With my little understanding, WebI does not allow editing of SQL, then how this will be modified. Is there any way to write equivalent SQL in WebIntelligence reporter?
WebI uses universes as does Business Objects Full Client or ZABO.
If you modfiy the universe via Business Objects Designer as suggested in the link I provided you should be ready to go.