When we use aggregate awareness function in designer?
In order to solve fan trap in business objects we either create alias table or aggregate awareness function Through aggregate navigation we can also select the compatible as well as incompatible objects
Ex:-year, quarter, month, week, and day
Year:-quarter, month, week, and day are compatible objects
Quarter:-year  class is incompatible and month, week, day is compatible. We specify the objects in descending order
Which versions are used in the BO dashboard work?
Latest version
How do we test the reports in the business objects? How to create the tabs in the reports?
In the central management consol one can test the report. Just go to the link http://ipadress:port no/businessobjects/enterprise11/admin/en/admin.cwr .every thing can chk from the Bo.
What are the steps to do to use Alerts in BO?
Alerts are used to alert some part of the data if any change occurs. select the part of the data in the report where u want to keep alerts n just click on alerts in the tool bar which is present in the third line from menu bar besides rank then a window pops up n we ca n give some condition where in if it crosses that an alert is sent.
How do you design a universe?
The design method consists of two major phases.
During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins by which they are linked. You may need to resolve loops which occur in the joins using aliases or contexts. You can conclude this phase by testing the integrity of the overall structure.
During the second phase, you can proceed to enhance the components of your universe. You can also prepare certain objects for multidimensional analysis. As with the first phase, you should test the integrity of your universe structure. You may also wish to perform tests on the universes you create from the Business Objects User module. Finally, you can distribute your universes to users by exporting them to the repository or via your file system.
For a universe based on a simple relational schema, Designer provides Quick Design, a wizard for creating a basic yet complete universe. You can use the resulting universe immediately, or you can modify the objects and create complex new ones. In this way, you can gradually refine the quality and structure of your universe
What is Thumbnail?
Business Objects Enterprise lets you preview a report using thumbnails. You can request the server to take a snapshot of the first page of the report and return it to the browser as an image file. This image can then be displayed as part of the Report Details page. To retrieve a thumbnail, a separate page needs to be created because the code that writes an image to the screen erases any text that may have previously been there.
What is the dense rank?
The DENSE_RANK function computes the rank of a row in an ordered group of rows. The ranks are consecutive integers beginning with 1. The largest rank value is the number of unique values returned by the query. Rank values are not skipped in the event of ties. Rows with equal values for the ranking criteria receive the same rank.
The DENSE_RANK function does not skip numbers and will assign the same number to those rows with the same value. Hence, after the result set is built in the inline view, we can simply select all of the rows with a dense rank of three or less, this gives us everyone who makes the top three salaries by department number.
What we can do in Webi and cannot do it in FULL CLIENT and vice versa for BO6.5
We can create\edit Universe in the full client but not in Webi
2) Webi has comparatively less functions to use than in Full client
3) In Full Client we can write macros\ad dins but I am not sure whether we can do the same in Webi or not.
Difference between compatible and incompatible objects?
We can select or choose compatible n incompatible objects through aggregator navigation in the designer. With this method the performance increases tremendously. Instead of checking for each n every object only the compatible objects are only looked for aggregate awareness. Year:-month, quarter, week, day are compatible but customer class is incompatible
what is REPORT BURSTING and how to do it in BCA as i have to split the report and send diff reports to diff people
If some part of the data in your report is sensitive, you can't risk sending the whole report to everybody, even to those who need to see the least sensitive part of report!
Solution is Report Bursting. You can send reports to BCA for scheduled processing & distribution to users based on THEIR profiles (profile = user rights) & not based on your profile! BO 5 & Webi 2.5 procedure to do this:
Open the document, click "Send to Broadcast Agent" on Doc Exchange toolbar.
In Actions tab select "Refresh with the Profile of Each Recipient"
In the Distributions tab select "Distribute via the Business Objects Repository. (only option to enable you for Report Bursting)
click To, select recipients,
Schedule it & OK.
In Webi 2.5...........
In Refresh options Select Scheduled Refresh & click send
On Scheduling Options, Set "Refresh According to the profile of each recipient" to Yes & OK.
What is Nested prompt and how to create this prompt?
Nested prompts are called "Cascading Prompts" in Business Objects environment. Try searching for this keyword. To create cascading prompts, you need to edit the properties of an object & impose another prompt as a condition.
How Do U Create Report in BO, if given fixed length file (Notepad) as source?
1. Open Business Objects --> new report
select data provider as Others instead of universe, from "Others" drop down list, select "Personal Data Files", File selection box appears, specify the location of your text file,
if you have separated data by tabs in text file select "Tabulation" if by comma then "Comma Separated" (I don’t remember the exact caption for this option) & if space separated then select "Characters"(I don’t remember the exact caption for this option)
if you have specified column names in your text file, check the box "First Row contains Column names" Run the report
In the BO universe, how to link two universe, like i have one universe in sales. uni and another is marketing.uni
In BO Designer, from File Menu -> Parameters -> Links tab on Universe Parameters box. Click Add link to link the universe. The linking universe should be exported and imported from repository before linking.
How to select different data providers in business objects?
Once you have your report generated, right click in the left window (your variables) click on "New Data Provider" follow the wizard. & you are done. If trying to use diff. data provider for different reports, after creating 1 report, right click on the Report1 tab located at the bottom, click insert new then the procedure is same to add data provider.
How to execute the plsql procedure from the report by clicking with mouse
We can select either tables or procedures or views as our data to generate our reports. In the designer in Bo we can select tab "insert" n select the particular data source for generating the report through mouse click.
How to generate the report from excel sheet?
Start BO,
Select "Others" on Data Providers wizard page,
From drop down menu, select "Personal data files",
Specify file location & check the box "First Row contains Column names" this will help you in creating Objects.
Click Ok.
Start building your reports.......
How many universes can be created in a project
We can create any number of universes, but at a time we can open only one universe, generally number of universes should be equal to number of sub-domains.
How to schedule the report in B.O?
We can schedule the reports through broadcast agent.
What is report template in B.O?
Report Template is a specimen for your future reports. You create a report from scratch, say make it Master-Detail Report with charts, put your company logo, add some default colors(something like same colors your company uses for its documents, WebPages etc.) & then save it as BO Report Template file. Next time when you are creating new reports, & select use Templates option, your report saved as template will be listed in the box. If you select it, your new report will automatically use all color formats, & table-chart structures, logo....whatever you used in your template report file. Advantage : 1 time development of display & structure format, for multiple reports use. i.e. Time Saving. No need of formatting for all standard reports
what is the difference between slice and dice & drill through
Slice and dice allows us to show and hide the objects Where as drill allows us to drill the data like drill up, drill down, drill through depending upon the user requirements.
What is the difference between slice and dice and cross tab report?
Slice and Dice: Arrangement of Data Crosstab report is for Comparison.
What is the difference between condition & filter?
Condition allows us to limit the data displayed from the database and Filter allows us to hide the data which is already generated in the report.
How to filter repetitive values in the report to get distinct values ?
In the Query panel we have tab "Options” Click there to get "eliminate duplicate enable this options.
Can you add the Cascading prompts in Business Objects?
If you select one prompt value based on that prompt value gives other lov (that lov value is have relate that 1st prompt value) you can select one or more from that value.
South (region) > TN, AP, kr, kl (state)
North (region) > nd, jk, hr, up (state)
If I select region south I can see only south region state. (This is cascading prompt)
It should create universe level.
Double click state object >
Edit properties > properties > edit
You can see the query pan, there pull down that region object and use that prompt conditions and save that
Now you click display button you can see how that prompts are working.
How can we do load testing for Webi Reports? (Example if I have to test one Webi report for Concurrent users refreshing report at one time
You can do Load testing for Webi Reports using Load runner tool.
1) Install load runner in your system. (To use load runner you need admin rights).
2) Generate load runner scripts.
3) Use controller (which is present in load runner) to get the results.
Using load runner tool you will get these results:
a) Maximum Running Users: 50 (Given by the testing person, you can increase virtual users if you want)
b) Hits per second.
c) Average response time for every transaction like login, click on the particular link, logout etc.,
d) Errors per second.
e) Connections per second.
what is a derived table in data warehousing
Derived tables are not real tables at the Database level, but are the selection of few columns in the Table with some aggregations, specific to the report.
This feature is available in BO 6.5 and later versions.
Sel a1, a2, a3, max (a4)
From a ,
(Sel b1, b2, max (b3) as B3, Min (B4) as B4 from B group by b1, b2) as BX
where BX.B1= a.a1
group by a1,a2,a3
order by a1,a2,a3
The (Sel b1, b2, max(b3) as B3, Min(B4) as B4 from B group by b1,b2)Â in the above query is a derived table.
The same definition has to be added in the Universe - by going into Insert >> Derived Tables.
Type the Query - parse it and the new table inserted can be used to any type of join / Contexts etc in the Universe.
What is the difference between tabular report& cross tab report ?
Tabular reports are a 2D format and Cross tab reports is a 3D format. Most of the operational/formatted reports will be created in tabular form and most of the analytical reports are created in the cross tab report form (Product VS Year VS Sales amount)
How achieve the many to much relation ship in Business Objects?
Create an intermediate table with 2 keys. i.e., the primary keys of both tables. Join each table to its primary key in the intermediate table.
What is a fan trap in Business Objects?
Actually FAN TRAP is a problem that occurs in Universe Level. Loop occurs while we design the universe. Two Types of Loop Problem:
1) FANTRAP PROBLEM solved by ALIAS METHOD:
Definition: Two One-to-many table link each other is in turn linked another one-to-many table.
2) CHASM TRAPS PROBLEM solved by CONTEXT METHOD:
Definition: Two Many-to-one table converges on one single lookup table.
Loop can be detected while INTEGRITY CHECK is done. An option is there as "Check for LOOPS" available. By "Detect Loop" we can choose what to be applied for solving the loop.
Â
When there is a series of one to many join in the tables, a Fan trap is resulted.
This may cause incorrect results to be returned when a query includes objects based on both tables.
For example: Associate, A Project, Â Dept tables.
One associate may work for N Projects, and those N projects may be Executed by N Dept....The report executed with the Associate table and the Dept table objects may produce that One Associate belongs to many departments.
To avoid this
Create a Alias table for Project A , which is A joined to the Associate as One to one mapping table.
Create a Alias table for Dept, which is A joined to the Project as One to one mapping table.
That means one associate, will be shown working for one project, and one project belongs to one dept.
Which will now result in One associate working for one Dept.
Â
There are many other methods to solve Fan trap !!
Creating Manual Context , Using @ Aggregate Awareness Etc - based on the Business scenario these can be used
36i have some queries that i have one project in business objects, like computer peripheral(nrps) for sales, in that i have face question like what is the main objectives of ur projects