Hi Sundar,
Background information
I don't know your geographic location or background. But I'm employed by a small to medium-sized consultancy company in the Netherlands (Odysseus -
http://www.odysseusnl.com). I'm a developer and our team has experience with regards to: Clarity v7.5 - v12.0.4 portlets, interfaces, Actuate/BusinessObjects reports, PL/SQL, etc.etc.
On-topic
If any issues in BO CA will not support more than certain level (we need to check SAP support site.) The same thing happened when we got
issues 4 yrs back in actuate.No help.i explored a lot and in pain & vain developed / fixed the issues in reports.
That's exactly the reason why we introduced third-line support (3LO) for our clients.
i have serious doubts whether we move to Business Objects in v12 now or stay with actuate 9 for time being.
The reason being we have developed 12 custom reports in actuate,can we develop
the same in BO in a short time.(5 months for upgrade) as we don't have the expertise in BO Web Intelligence and crystal reports.In actuate we will call the custom procedure and pass the paramaters, but can the same can be done in the current version supported by CA? .
I'm more than familiar with your 'reserved hesitation' regarding the transition of Actuate to BO. Many of our clients do have and have had the same reservation. As of this moment most of our clients stay with Actuate (and the financial crisis didn't help much either).
Although I have to admit a BO report can be less complex than Actuate and thus easier to develop. But do not underestimate the construction of the underlying BO universe. In my experience the universe is far more complex and time-consuming to develop (due to business-logic) then to develop the BO reports. My advice
Start a proof of concept. Set up a (virtualized) development or sandbox environment with an upgraded Clarity to v12. Start constructing the BO universe based on one or two most complex high-profile reports that you have. Most likely the other reports will share a fare amount of attributes, they are now contained in the universe. The other BO reports are most likely quicker to develop.
Work in short and clear concise phases with go and no-go moments. Involve key "report" persons during these phases. Let them also decide if BO for now is the way they want to go. Think about ad-hoc reporting.
And in my honest opinion don't count on SAP support site. You require in-depth knowlegde of the Clarity datamodel, the tools are less relevant in this respect.
If you need support/help/advice, consult a company that is specialized with Clarity PPM and Business Intelligence solutions. CA should know them for your geographic location (for example Xinify in North AMerica, Odysseus in the Benelux). Cheers (please keep this post updated so that I can follow your upgrade process),Remko Lems