“Business Development Researcher baed Frequently Asked Questions by expert members with experience in Researcher Business Development. These questions and answers will help you strengthen your technical skills, prepare for the new job test and quickly revise the concepts”
There is no such tool available yet for comparing Universes/Reports. The best way to compare Universes is to do check intergity constraints & the compare the outputs.
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.
1. Motivation factor
2. Team leader quality
3. Risk handler
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.
ex:
Give me the set of sales people who make the top 3 salaries - that is, find the set of distinct salary amounts, sort them, take the largest three, and give me everyone who makes one of those values.
SELECT * FROM (
SELECT deptno, ename, sal,
DENSE_RANK()
OVER (
PARTITION BY deptno ORDER BY sal desc
) TopN FROM emp
)
WHERE TopN <= 3
ORDER BY deptno, sal DESC
/
DEPTNO ENAME SAL TOPN
---------- ---------- ---------- ----------
10 KING 5000 1
CLARK 2450 2
MILLER 1300 3
20 SCOTT 3000 1 <--- ! (in case of rank JONES will have 3 and dense rank will have 2)
FORD 3000 1 <--- !
JONES 2975 2
ADAMS 1100 3
30 BLAKE 2850 1
ALLEN 1600 2
30 TURNER 1500 3
As far as i know we schedule the reports through broadcast agent.
To get good name , fame n earn well amt is top business.
Bo XI R2 versions is used in the BO dashboard work.
We can do this in three ways:
1.alphabetical order-prompts will appear in alphabetical order
2.numeric order-prefix number and they will appear in numeric order
3.date order-prompts will appear date wise
it depends on the type we choose in prompt syntax
Cartesian product is getting incorrect results.
for instance if we have a cham trap or a fan trap n we din't solve them after checking the integrity also we get duplicate results of the same record ie nothing but cartesian product.
ex:-
we have customer,orders,loans classes
orders for one product if the product_price is 150$ it will appear twice in the report due to traps bcoz of the cartesian product thats why to solve the cham trap we create context and in order to solve fan trap we create alias table.
ZABO is zero administrator businessobjects , which will be installed on your local m/c when any full client report in opened/edited from infoview . For this you don't require any BO mainkey , key will be installed from BO server.Webi is also called as thin client , where -in you are create BO reports on web browser . Reports are only based on Universe.
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 devaelopment of display & structure format, for multiple reports use. i.e. Time Saving. No need of formatting for all standard reports.
Repository means set of database tables, Business object store security information e.g user, group, access permission, user type etc. , universe information e.g. objects, classes, table name, column name, relation ship etc.and document information
it is centralized and set of data structure that can be stored in databases.basically repository can be made up by 3 domains.
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.
★ Ao 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.
You can do Load testing for Webi Reports using Load runner tool.
1) Install loadrunner in your system. ( to use loadrunner you need admin rights).
2) Generate loadrunner scripts.
3) Use controller(which is present in loadrunner) to get the results.
Using loadrunner tool you will get these results:
a) Maximum Running Vusers: 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.
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.
Alerts means highlights the data.
1. select the cloumn/row
2. apply the alert that is available in tool bar
3. provide the necessary condition
4. Apply it
Tx
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 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 it?s own reporting toos where as XI uses crystal reports as it?s 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
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
Webi rich client is basicaly use as a windows application (Online as well as Offline)..Here No need for web connection.But
InfoView is a web portal of BusinessObjects where we can create reports in connected mode.It need web connection to run the reports.
SUPERVISOR offers various types of users of Business Objects products. The user profile determines by default what products a user can use. User profiles can be customized to reflect the needs of the users.
User (all products but DESIGNER and SUPERVISOR)
Versatile (configurable)
USERs use the Business Objects end-user products to query, report, and analyze data. They may also use the optional REPORTER and EXPLORER modules for multidimensional analysis. End users can produce documents containing data from one or more data sources.
A versatile user is a customized user who may be given access by a supervisor to any combination of Business Objects products.
Yes both can exist on the same tier because Datamart is a subset of data warehouse and it supports a particular region, business unit or business function.
The data in the Datamart and DWH is Denormalized and optimized for OLAP systems.
Think this should be in the Reporter Forum but, a local filter would apply to just a single block (table, cross tab or chart) within your report.
A global filter would apply to all blocks in your report, so if you had many tables the filter would apply to all of them.
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
