Page8
1.What is all difference between business objects 6...
I have found some differences b/w BO and XI and only the last is specific to XIR2
Difference between BO and XI
BO uses classic BO Architecture and XI uses crystal classic Architecture
BO uses 57 tables for BO repo and 8 tables for auditor where as XI uses 8 tables for CMS and 6 tables for auditor
BO has different security domains where as XI doesn’t has no different security domains
BO, all objects are stored in repository where as in XI Objects are physically stored in Input FRS and instances in output FRS
In BO after installing we have configure, create BO mainkey where as in XI it is install and start working
In BO classic key is an xml file and it has to be placed in relevant location where as in XI a key code is there
In BO if you want to save a report to repository you have to publish that report where as in XI if you click save as and select Enterprise
IN BO, BCA and supervision are entirely separate but in XI there are merged into CMC
IN XI there is no separate auditor is there but there is an auditor database where we can create tables based on that
BO has its own reporting tools where as XI uses crystal reports as its reporting tool
BO is user centric – means rights are assigned to user where as XI is object centric – means rights are assigned on objects level not user level
BO – all reports are stored in categories, in XI infoview there is folder and categories but all main storage is in folders
In XI R1 there was no concept of full client but that concept is introduced in XI R2
2.Kindly number what are the steps to be taken to schedule the report?
You can schedule any report using Business Objects (reporter) .1) Open report in BO2) Select option “File->Send to- BCA"3) Select the BCA name to which report has to be scheduled4) Set other options for report scheduling like time, any macro, user etc.
3. What is aggregate awareness and how can we use it?
Aggregate awareness function is used to aggregate the values present in the classes in descending order.
For instance we have year, quarter, month, week tables
Then we sum the year, sum (quarter), sum (month), sum (week) in descending order respectively.
We also select the compatible as well as incompatible objects through aggregate navigation so that it improves the performance of the system in generating the report.
4.RE: What is aggregate awareness and how can we use it?
You can use features in Designer to allow you to define the Select statement for an object to run a query against aggregate tables in the database instead of the base tables. You can set conditions so that a query will be run against aggregate tables when it optimizes the query, and if not, then the query will be run against the base tables. This ability of an object to use aggregate tables to optimize a query is called aggregate awareness.
5.What if a Cartesian product pop up block appears w...?
Cartesian product is getting incorrect results.
for instance if we have a chasm trap or a fan trap n we don’t solve them after checking the integrity also we get duplicate results of the same record i.e. nothing but Cartesian product.
Ex:-we have customer, orders, and loans classes
orders for one product if the product_price is 150$ it will appear twice in the report due to traps becoz of the Cartesian product that’s why to solve the chasm trap we create context and in order to solve fan trap we create alias table.
6.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.
7.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.......
8.What is a derived table in data warehousing?
It is similar to views; it is mainly used to restrict the data
9.How to execute the plsql procedure from the report...
We can select either tables or procedures or views as our data to generate our reports. In the designer in bo's we can select tab "insert" n select the particular data source for generating the report through mouse click.
10. How Do U Create Report in BO, if given fixed length...
To create a report using notepad (.txt files):
1. Open BusinessObjects --> new report
2. 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.
11. Can someone please give some information on REPORT...?
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.
12. Can someone please let me know the things we can d...
1) 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\addins but I am not sure whether we can do the same in WebI or not.
-In addition to those in my previous mail,
1) We can edit SQL in Full client but not in WebI
2) We can apply Rank in Full client but not in WebI
3) Better formatting facilities in Full client wrt WebI
-Difference between Thin and Fat installations
Feature
BO
WebI
Data Access Via,
Stored Procedures, Free hand SQL, Personal Data files (.txt, .xls, .wk, .prn, .asc)
Yes
No
Ability to access multiple sources in a single report
Yes
No
Can access other OLAP server (Microsoft OLAP, DB2 OLAP and Oracle Express)
Yes
No
Ability to use report templates
Yes
No
Ability to create more than one report in a single Business Objects document
Yes
No
Multiple views of the same data in a single report (pie chart, tabular, cross tab, etc)
Yes
No
Ability to analyze Business Objects report data with Data mining product “Business Miner”
Yes
No
Ability to create “Variables” in document level.
Yes
No
Ability to send Business Objects report via Microsoft mail
Yes
No
Ability to compare an object with
Another object, Sub Query, Calculation
In condition (“Where” Clause)
Yes
No
Ability to display only the top and bottom values by a another variable
Yes (By Ranking)
No
Ability to build two or more queries in the Query Panel and to combine these queries by using an operator (UNION, INTERSECT, or MINUS)
Yes
No
Ability to use BusinessObjects own build-in functions in report.
Yes
No
13. How to break a Date field into Year, month, week, date
Create objects in your universe with date functions.
Let's say your DB is Oracle. In your "Select" statement of new object called year, try
to_char(INVOICE_DATE, 'YYYY') similarly for month create object called month & repeat process, simply replace'YYYY' with 'MM' of 'MMM' in the select statement. & so on.
14. What is the difference between slice and dice and cross tab report?
Slice and Dice: Arrangement of Data Crosstab report is for Comparison.
15. What is the difference between slice and dice and...
Cross tab report is like at the intersection of 2 dimensions measure is displayed. Like if we have two dimensions year and product and a measure revenu, revenue is displayed at the intersection of year and product.
A standard report can be sliced and diced but not the crosstabed one
Slice and dice is you are going to analyze the data in different angle, but drill through is like using a single value you are going to grain the data.
Slice and dice means change the position of the data like move the data from rows to columns
Drill mode means allow u to analyze the data in different angles and different levels of details.
In drill mode different types of analysis's are there like drill up, drill down, drill across, drill through.
Drill through means option to select any step or level directly from the current level...
These are the main difference between slice and dice and drill through
16. My query takes 30 min to refresh ...there is any p...
- make sure to have the right context
- apply right indexes on the tables
17. What is the difference between tabular report& crosstab...?
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)
18. What is the multi value error? Is there any...
Yes, #MULTIVALUE error is there in BO. It’s common when u r trying to use multi valued multiple objects in section.
Go through error documentation for further details...
What is the multi value error? Is there any...
You will get the Multi Value Error when you are trying to retrieve multiple values into the cell.
Ex: When u r tying to Insert cell into report and trying to assign a column to it which will have multiple values in it. (In A single cell you can’t show multiple values)
19. What is difference between custom hierarchy and re...?
By default one class having one hierarchy i.e. called report hierarchy. Custom hierarchy we can create in designer according our req.
20. I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
The Prompts will appear in the alphabetical order.
To make them appear in the order of our requirement, need to prefix a numerical with the prompt
21. Give the notes and functionalities of cascading pr...
Cascading prompts: cascading prompts means one prompt depends on another prompt... if suppose u wants select one district.its depends on state. then it depends on country...so one prompt depends on another. Its work as first come the prompt of district when ever we going select value. Automatically coming the state prompt. Then country prompt. When ever we select the country it goes to state then district...
@script: its belongs to vba application
22. Give the notes and functionalities of cascading pr...
Syntax
@Prompt ('message', ['type'], [lov], [MONO|MULTI], [FREE|CONSTRAINED])
Where
Message is the text of a message within single quotes.
Type can be one of the following: 'A' for alphanumeric, 'N' for number, or 'D' for date.
Lov can be either a list of values enclosed in brackets (each value must be within single quotes and separated by commas) or the name of a class and object separated by a backslash and within single quotes.
MONO means that the prompt accepts only one value. MULTI means that the prompt can accept several values.
FREE refers to free input as opposed to CONSTRAINED, which means that the end user must choose a value suggested by the prompt.
Description:
Is used to create an interactive object. In the Query Panel, this type of object causes a message to appear. This message prompts the end user to enter a specific value.
Note: The last four arguments are optional; however, if you omit an argument you must still enter the commas as separators.
Example:
In Where Clause:
City. city IN @Prompt ('Choose City', 'A', {'Chicago', 'Boston', 'New York'}, MULTI, FREE)
In the Query Panel, the object prompts the end user to choose a city.
23. What is the concept of Micro Cube in Business Objects and explain business reason for the usage.
Micro -cube is a local structure in Bo that stores the result of your query A before generating report
24. What is the concept of micro cube in business objects and explain business reason for the usage.
Micro -cube is a local structure in Bo that stores the result of your query a before generating report
We should use Detect Aliases and Detect Contexts to formally identify and resolve loops.
I.e. if a loop contains only one lookup table then the loop can be resolved by detecting the alias.
If a loop is having 2 or more fact tables (multiple fact tables) then the loop can be resolved by detecting context