-
A Business Objects Universe consists of classes, within each class are objects, name and describe the three types of objects.
wadate
- May 14th, 2011
There are three types of an objects: 1:-Dimension Object: An object being tracked in multidimensional analysis; the subject of the analysis. Dimensions are organized into hierarchies. 2: Det...
lionskashif
- Feb 1st, 2011
OBJECT: An object is a named component that map to data in the database.DETAIL: Provides descriptive data about dimention. A detail is always attached to a dimention.MEASURE: contains aggregate functions that map to statistics in the database.
-
What are all difference between business objects 6.5 and XI R2
nameer.pmp
- May 10th, 2011
BO 6.5:1. 3 tier architecture2. Supervisor is?used as administration console3. Security - Object level and Row level4. Only universe is used as the data provider5. Central configuration manager to ma...
-
Generate DeskI and WebI Combined Query
How to generate combine query in DeskI and WebI ?What are the steps to generate combine query in Deski and WebI? Give answer with example.
-
Crystal Report Performance
What could be the possible problem if the report keeps on running without responding even before prompt comes up?
sreenu435
- Mar 10th, 2011
If it is before prompts then problem with paramenters passing or server problem, not db problem. After prompts report tries to connect to db so it could be problem in passing paramenters.
prakharrajsingh
- Sep 19th, 2009
If all CR (with or without prompt) behave in same way then something is wrong with your CRPE.Otherwise, there is some problem with prompts.Try changing the viewer for CR and it may run fine.Cheers.
-
Rename an Object
How to rename an object in Web Intelligence?
sreenu435
- Mar 10th, 2011
Yes, and? it?will automatically updated if your using same object in other places
-
Universe Creation
Is it possible to create a Universe using flat file? If Yes, How?
vadivelmothi
- Mar 10th, 2011
Yes we can create the univese by using flat files, for creating the universe we need DSN (Data source name) that is using ODBC connectivity u can create the DSN,Create a DSN for the flat files and try...
RishiBO
- Jan 18th, 2010
No we can'tUniverse and flat file are data providers for generating the reports.
-
What is the difference between break and section in Reports.
lionskashif
- Feb 19th, 2011
Break is applied on whole block it gives you row at the bottom of block for subtotal. It breaks a whole report into the smaller groups according to your select column. When you apply a chart...
sheriey
- Dec 4th, 2007
Strong>Break All the data remain in one block but you can divide the data on the basis of groups
-
Kindly numberWhat are the steps to be taken to schedule the report?
lionskashif
- Feb 19th, 2011
if you want to schedule a report then you need to go to infoview and click on document list........ then click on public folder (if you have your own folder then click on it) all files are show you on...
prdunknown
- Aug 1st, 2006
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.
-
What is the difference between detect alias and detect context?
lionskashif
- Feb 17th, 2011
When you making a universe So, loop Generate bc of joins it is a common problem when you make universe.loop is a cirucular path of joins. when loop occur so we have a 2 way to solve them.......
Goverdhan Reddy
- Aug 15th, 2006
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 aliasif a loop ...
-
Explain the difference between Condition and Filter.
filter reusable..condition not reusableConditions: these retrievals the data based on the condition (universe level)Filter: it brings the data and filter; performance will be slow (report level)
lionskashif
- Feb 17th, 2011
Also added please, Condition: we put on the object belly where we write the where clause and FILTER is is ristrict the data according to the given/asking prompt. thx
Bharat Ahuja
- Jan 9th, 2007
An added point here is that a condition is used to fetch selected data from the data source (data base) while the filter is used to fetch selected data from the data cube.Also, you apply a condit...
-
What operator would you use to allow wild card characters in a query?
lionskashif
- Feb 17th, 2011
hi,like operator will help you to allow wild card character in a queryfor example: you want to find a name "Muhammad kashif" in the name column.but you dont know "Muhammad" Start b...
r.jain
- Nov 20th, 2008
Wild card character can be used in query with Matchs pattern and Different from pattern operator.
-
What if a cartesian product pop up block appears when running a report. Does it give wrong values? how to solve this issue?
lionskashif
- Feb 2nd, 2011
The Problem is in your schema. Please check your joins, and cardinalities
also check loops.
Whenever cardinalities is not set proper its give you three types of error.
1-->Incompatibility result
2-->Ambigeous result
3-->Cartiesum result
narmadac
- Feb 17th, 2010
To prevent cartesian product when running a report initially you can set it in the Universe Parameters.File ----> Parameters ----> SQL tab ----> two options for Cartesian products 1) Prevent 2) warn (default) -----> click any one of them and then OK
-
Universe Cordinality
How do you validate cordinality in universe?
arulibra
- Dec 2nd, 2010
We can check the cordiality by doing Integrity check, however it is not always recommended as accurate results are not achieved at times. It is advisable to check manually according to the relationship between the tables.
-
Universe Complexity
Give an example where you find complexity in Business Objects products/Universe Creation/ WEBI report complexity.
-
BOXIR2 is Which type of OLAP?
satish
- Oct 15th, 2007
Its a DOLAP solution because the cache is built dynamically, either on desktop in case of DeskI or on enterprise server in case of WebI. We can also say it as a ROLAP because it BO provides automatic drill through to detail, server based ranking,aggragate navigation.
-
What is a fantrap in Business Objects?
vinod3035
- Jul 11th, 2010
The above answer is well and I understood but Alias mean Duplicate name given to the original table? What about the Original table? How it will be include with in the Query?Associates=>Projects=>Departments.
Vineela
- Apr 26th, 2007
?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 : Ass...
-
How would I set up a variable to show a rolling 4 week average of, for example Arrears?
eussusn24
- Jul 6th, 2010
You need to use previous() function in your formaula.variablename = ( +previous()+previous(previous()) + previous(previous(previous())))/4
-
CHASM trap and FAN trap
While designing universe, a situation occurs when loops and traps occurs. What is CHASM trap and a FAN trap?
eussusn24
- Jul 6th, 2010
Chasm trap is type of join path between 3 tables. When two many-to-0ne join converges to a single table and there is no context in place to separate the converging paths.Fan trap is another...
-
BO Report Controls
What are report controls in BO? How to implement it?
-
Migrate Repository
What are the steps to migrate repository from 6.5 to XI?
bushy143
- Jun 22nd, 2010
1. Planning2. Installation of BOXI R23. Run Migration tools and utilities (Migration Wizard)4. Validation (Check Security, universes, reports)5. Deployment (Testing and tuning)
Business Objects Interview Questions
Ans