Page7
1.What is difference between custom hierarchy and report based hierarchy?
By default one class having one hierarchy i.e. called report hierarchy. Custom hierarchy we can create in designer according our req.
2.Can we apply Rank and Sort at a time on a single report?
No we can’t apply rank and sort at a time on one object in one single report. If we try to apply, BO asks if you want to over write the previous condition.
3.What is meant by Object Stores?
Answer Object store is nothing but the container of object which is created after rpt file run once.
4.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.
5.Can a universe be connected to different databases...
A)NO a universe can not take the data from more that one database ,if ever we want data from another database we have to create another universe or use different data provider while report creation
B)yes, a universe can be connected to different database. However to do so, we have to link two universes which are on different database.
however if we consider, unlink universe(or only one universe), then it is not possible to have a universe that is connected to different database as in a universe we have only one connection at a time.
C)NO. A universe cannot connect to more than one database at the same time. But in Report we can use multiple data providers which internally two different universe and 2 different database.
D)Yes, You can do using multiple data providers
6.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
7.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.
8.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.
9.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.......
10. 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.
11. 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.
12. What is the difference between master-detail and Breaks?
In break common fields are deleted (here in this case the table format is not changed) whereas in master-detail , we declare certain entity as a master to get the detailed information or report in this case the table format is changed.
13. What is the difference between break and section I...
The major difference between these 2 are
It breaks up the data in a table or crosstab by grouping the data according to a selected value and it allows you to display all the data for each value of a dimension variable together mainly it displays SUBTOTALS. COLUMN BREAK's are used to avoid the repetitive value occurrences
Section is obtained in the Master/detail reports which enable you to split large blocks of data into sections. This type of presentation allows you to minimize repeating values and to display subtotals.
14. What is the difference between break and section I...
Here is the difference
Ex: Creating a Break and a Section
When you create a break on Year, the data remains as one block. The year values are repeated for each corresponding value of State and Sales Revenue.
When you create a section on Year, the data is no longer contained in one block, but divided into sections. One section for each value of Year. Each section is a separate block
15. What are the requirements for cube creation in bus...
You should have a "Universe" with proper star or snowflake schema(Dimension and Fact) .Call this Universe in the "infoview" to create a web intelligent analysis(OLAP) report.
16. Business objects is which type of the OLAP Tool?
BO is ROLAP Tool
The functionality and feature sets are significantly different and so are the costs. Generally speaking, BI tools are categorized by a) their architecture (i.e., ROLAP, MOLAP, HOLAP, DOLAP, etc.) and b) their cost (i.e., high end or low end) which is usually related to the size of their feature set. For example, DOLAP solutions would include Cognos and Crystal, MOLAP solutions would include Essbase, SAS and Oracle Express, ROLAP solutions would include Business Objects, Informatica and Microstrategy and so on. Similarly, Cognos, Brio, Crystal and Microsoft OLAP are considered low-end solutions, while Business Objects, Microstrategy, Essbase and Informatica are considered high- end solutions.
17. How does the hierarchy and scope of analysis help...
Hierarchy is about the levelsorder of the objects in the classes. E.g. Time hierarchy in a time class will be Year, Quarter, Month, Week, Day, Hour, Minute, Second
By defining a scope of analysis during drilling you are specifying up to what level in the hierarchy you want to drill. if you set scope of analysis as 2, the data will be drilled to Year, quarter. 3 will include month as well as so on.
18. How do you Find the average of an object with out using the Average Function and by using only sum,average,max,min?
Use Sum() and Count() function like Sum() / Count() you will get your average value.
19. What is difference between datamart and datawarehou...
Data marts, simply defined, are smaller data warehouses that can function independently or can be interconnected to form a global integrated data warehouse
20. How many tabs can be added in a report i.e. how ma...
It depends on the hierarchy of the class.. but still w can define in slice and dice panel.. that is up to 2 times or 3 times... like that
21. What is the maximum limit of the data providers in...
There does not seem to be any limit however the documents say that you can have maximum of 15, but I have seen close to 50 dataproviders in a report.
22. How do you check whether the data in the rep...
We can copy the SQL Generated in the Query panel and run that SQL in the Database.
23. Clearly explain the difference between union and group
A)The difference between union and group is as follows:
take two tables t1 and t2.
in t1 we have columns like a,b,c,d. and t2 has a,d,e,f.
so union means t1 union t2 i.e. getting result from both tables i.e. a,b,c,d,e.,f
where as group performs on a individual column in a particular table.
August 12, 2006 08:16:20 #2
Venkatachalam Member Since: Visitor Total Comments: N/A
Clearly explain the group with one example
B)If a table has 2 columns Gender and Name
Gender Name
Male Tom
Male James
Male Harry
Female Jenny
Female Fern
Tom, James and Harry belong to Group Male.
C)union operation can be performed on basic cubes, remote cubes, ods objects, master data objects,infosets. i.e. u can form union operation simultaneously on cubes, ods, master data objects, infosets. Multi provider does union operation.union operation can be performed on multi dimensional objects.
But join operation is performed only on master data objects and Ods objects which are 2 dimensional. Infosets perform join operation.
24. State the difference between WebI and Infoview
A)In infoview you can create a WebI documents i.e. wid documents, you can open, schedule, save it as an excel or pdf or business objects document(.rep).
WebI is a part of Infoview
B)Infoview is the portal to the BO's business intelligence solution and infoview also allows the third party documents and It contains document lists that give an instant overview of all the documents generated from corporate data storage and made availabe to users
C)Web Intelligence is a leading web-based query,analysis and reporting tool and this provides a thin-client interface for powerful adhoc queries and simple analysis. It allows users to access, analyze and share corporate data over intranet, extranets for both RDBMS dbs and OLAP servers
D)WebIntelligence is the 'thin-client' (or server version) of Business Objects Reporter. It is used to create report documents. It does not reside on the users computer, but on a server.
InfoView is what the user logs into, sees, and uses in their Internet Browser that allows the user to access and create Business Objects reports via the web without having to install the 'Full (or 'Thick') client Business Objects Reporter on their computer.
The user can only get to WebI through InfoView. It does not reside on the users computer, but on a server.
25. What is the difference between detect alias and de...
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