Explain detail objects?
Detail objects are attached to dimensions; one cannot drill on details or link on details when linking multiple data providers. While Customer ID would be a dimension, customer name, address, phone and soon should be details.
What is BO Main Key?
Bo Main Key file contains the information about the repository site i.e. it contains the address of the repository security domain.
What is Business objects Repository?
It is nothing but metadata.
What is domain? How many are there in a basic setup? What are they?
Domain is nothing but logical grouping of system tables, there are three domains usually in a basic setup, and they are Secure, Universe, and Document. Business objects are sometimes called domain objects (where the word domain means the business), and a domain model represents the set of domain objects and the relationships between them.
When is the Repository created?
In 5i/6i versions after installing the software, whereas in Xi version a repository is created at the time of installation.
Can we have multiple domains?
Yes. (Security domain can not be multiple).
How do you restrict access to rows of a database?
In XI version it can be done by using row-level security in designer module whereas in 5i/6i it is done by supervisor.
What is a category?
It is nothing but grouping of certain entities.
What is a Universe?
It is a semantic layer between Database and the designer used to create objects and classes. (It maps to data in Database).
What is an Object?
It is an instance of class, its nothing but an entity.
What do you mean by Object qualification?
Object qualification represents what kind of object is that, usually we have three types of object qualifiers they are measure, dimension, detailed.
What is the size of data base?
In general it will be anything between 4-8 Terabytes.
What is a loop? How can we overcome?
Loop is nothing but a closed circular flow; it can be overcome by making use of Alias and Context.
What is a join? Explain different types of joins?
Join is used to link to tables depending upon the data requested by the user, Usually we have Inner Join, Outer Join, Left Join, Right Join, Full Outer join.
What are Linked Universes?
If the data provided is from two different data providers then we can link those two universes, such type of universe is called Linked Universe.
What are Alerter, Filters, Breaks and Conditions?
Alters are nothing but they are used to draw attention to a block of data by highlighting. Breaks are nothing but grouping the data without any change in the format. Condition is used to retrieve data which meets certain criteria. Filters are used to get necessary data.
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.
What is metrics?
Metrics are a system of parameters or ways of quantitative and periodic assessment of a process that is to be measured; these are used to track trends, productivity.
What is a Set?
Its nothing but grouping of users.
What is the use of AFD? Where it can be stored?
Used to create dashboards. It can be stored in repository, corporate or personal.
What is the source for metrics?
Measure objects.
Why do we need metrics and sets?
Metrics are used for analysis and Sets are used for grouping.
Is there any bug in 6.x?
In earlier version of 6.0 they had, but 6.5 is the best version with out any bugs.
What are the general issues in migration process?
Alignment, performance.
What is the use of BO SDK?
Bo SDK main use is to suppress “no data to fetch” using Macros.
How can we improve performance?
By making use of Aggregate tables.
Analysis in BO?
Slice-Dice and Drill analysis.
How can you check the integrity?
By making use of Check integrity button.
What are Universe parameters?
Name of the universe, description and RDBMS connection, size and rights.
Types of Universes?
Simple and Complex.
What is the use of BCA?
BCA is used to refresh and schedule and export and save as.html, .rtf, .xls, .PDF.
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.
Difference between ZABO and Webi
ZABO is zero administrator business objects, which will be installed on your local m/c when any full client report in opened/edited from info view. For this you don’t require any BO main key , 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.
Explain the difference between union and group
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.
Are Data mart and DWH normalized or demoralized? Do both of them exist in the same tier?
Yes both can exist on the same tier because Data mart is a subset of data warehouse and it supports a particular region, business unit or business function. The data in the Data mart and DWH is Demoralized and optimized for OLAP systems.
What is a Data Cube? What is its use?
Data cube will present in BO tool. Data cube is used for storing the data values which we are using in the documents. We can clear the data cube by using purge command. Data provider is used to retrieve the dates from data cube to documents.
What all will be exported to the repository, when we export a universe?
When we export a universe first time, a unique identifier is allocated to the universe and his identifier is updated on the local version of the universe in the universe domain. If we export the universe to a diff, domain and now the universe has an identifier for diff-domain (EX: exporting a universe from a development domain to a production domain)
when a designer exports the universe to the Repository (universe domain) they must export all the related LOV files (which contains the data values associated with an object) to the document domain.
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.
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.
What’s universal join in BO?
The level of join between two universes with a matching column.
What are the user requirements in a universe?
Database connections, key column, join and check for loop if you need measures, metrics,
When to use local filter and when to use global Filter?
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
Give the notes and functionalities of cascading prompts, @ script in business objects
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.
How many ways we test the universe & Report?
By doing integrity check we can test universe & By coping report query and run in backend(oracle, sql server...) we can test the data by comparing both.
How we drill up week to Month?
In data Warehouse when u changes + symbol to - , u would c all the aggregation level in that + this is called rolling down. So if u again click over that - it would again compressed back to +. This is call drill up. Your Aggregation levels would b like
Year>Month>Week>Day>Hour>Minutes>Seconds.
So by changing the symbol from - to + at month aggregation level u can drill up.
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 Veers: 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.
How to filter repetitive values in the report to get distinct values.
Example: In any database we can use distinct command but My Report source is flat file. Therefore I can’t manipulate source system.
Is there any command or function to filter repeating records/values in the report?
Using the eliminate duplicates option is one way.
In a lightly different scenario, duplicates could come up due to the design structure of the report. E.g. in some specific cases, one may want to display a value in one field (say in a folded report) but multiple values come up (which could give you a COMPUTATION ERROR). To avoid such situation, one can define a variable which would e the max of the
Original field required. That ways the same value is fetched and also only one value is returned