User talk:Santoshjeerlapally

Santosh Business Objects
Hi Hello i wanted to share little knowledge that i have with Business Objects tool, I have 7 years of Experience with Business Objects, I am currently working as a Business Objects SME/ architect in washington DC. My Name: Santosh Jeerlapally My website: http://www.santosh4bo.com

Please go to this website there you can find a link to my forum, there you have lot of information about business objects.

I am going to post some of the topics that are useful for a business objects developer. 1) Web Intelligence 2) Crystal Reports 3) CMC 4) CCM 5) Clustering

I am going to speak about the above mentioned topics in detail..

Day1) Web Intelligence: Web Intelligence is a report module where users can create reports based on Universe, this a web based reporting module, thats why it is called as web intelligence, The only source to create these reports are either using Universe or OLAP Data sources.

How to create a Master Detail Report in Webi: 1) Logon to Infoview, click new report and select universe then, you will get a java based gui which is nothing but webi reporting panel, that contains query panel, conditions/filters, on the LHS, you can see all the objects and classes from the universe. Typically an object is nothing but the columns in the database whereas classes are nothing but the tables from database.

2) Select the required objects on to the query panel top right hand side, either by drag and drop or by double clicking then use the button RUN QUERY on the top right hand side, you will see the report with the select objects.

3) In order to create a Section on a report, select the object that you want and right click and select the option set as section, then that object will become section and related date will be displayed under that object. Say for eg: you want to see the sales revenue of all the states with the cities. then what you have to do is right click on the state column in the report and say set as section: so the data will be displayed as:

CALIFORNIA SANFRANCISO $23000 LOS ANGELES $45000 VIRGINIA FAIRFAX     $35000 MCLEAN      $54000 SO ON, this is the use of section( its also called as master detail report)