-
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.
-
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...
-
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)
-
1. What is an Universe? 2. How many Universes did you create? 3. Tell me how many classes where there, and objects in each class? 4. What is Object qualification? 5. Tell me about a complicated object you have created? 6. What was the size of the database? Which server? 7. How many user were there? 8. What problems you have faced while creating an universe? tell me an incident and how you went about solving it? 9. Were any experts called from BO while you were on the project? 10. What was the Database? Was it a data warehouse? 11. How many Tables was the universe built? 12. What is a loop, how do you resolve them? 13. What do prefer an Alias or a context? Why? 14. What is join? Explain different types of joins? 15. What are linked universes? Have you worked with them, problems faced and solutions? 16. How many reports have you created? Explain a few? 17. What are alerters, filters, breaks, and master-detail? 18. What's the difference between master-detail and Breaks? 19. What's the difference between filters and conditions? 20. What are pre-defined conditions? Compare with report conditions? Justify? 21. What are the differences between a formula, variable and user objects? 22. Did you face any problems while creating reports? Name? Solutions? 23. How do you schedule the reports? 24. How were the reports scheduled and how to resolve unexecuted documents? 25. What is a micro cube? How many can a document have? 26. Have you worked with multiple data sources? If yes. How do you link them? 27. What are templates? Explain what you have created?28. I have some multi data providers (excel, text, universe). I want only retrieve the data from excel only. How to write the query in query panel?29. What is slice and dice? What is the use of slice and dice?30. What is core dimension?31. How do see the query performance in report?32. I want to display the last refresh report date and time in the below of the report, how will you do that?33. While running the query how much time it will taken, I want to see the time?34. What is Report Bursting?35. What is the use of alias and context? Which is the better for solving the loops? Why? Why we use alias and why we use context?36. How to improve the query performance in to report level and designer level?37. I have 3 tables A, B, C. I connected A to B and B to C. I want to report ABC, is there any loop problem will occur or not?38. I have 4 tables A, B, C, D. I connected A to B, B to C, C to D and D to A. I want to report ABC, is there any loop problem will occur or not? What is the Problem?39. How to interactive with Clients? 40. Can u tell me, what is the major problem you faced in your experience? How did you resolve the problem?41. I have one problem? My Client to told resolve the problem with in 2 hours, but its taken by full day (8 hours). How will u convince the client?42. How Many Classes and Objects you have in your Universe?
reddyvaric
- May 15th, 2010
Universe is a semantic layer in between database and reporting an environment.
srinivas
- Dec 8th, 2006
universe is enduser interface which isolate the technical property.
-
How to merge two universe in one query?
in_kkumar3
- Apr 1st, 2010
In Universe we can use Link two Universe.In WEBI we can use the option of Merge dimensions to join two universe. However we need to customize other objects with measures to join and get the results.
anasat
- Jan 16th, 2009
Two universes can be merged in deski using combine query in the data provider.
-
How do we test the reports in the business objects? How to creates the tabs in the reports?
narmadac
- Feb 17th, 2010
You can test the report by running the query in SQL*PLUS/TOAD and checking the results.
rasmikanta
- Jul 21st, 2006
In the central mangement consol one can test the report. jsut go to the link http://ipadress:port no/businessobjects/enterprise11/admin/en/admin.cwr .every thing can chk from the bo.
-
What is report template in B.O?
pat.mclean
- Jul 7th, 2006
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...
-
How to schedule the report in B.O?
narmadac
- Feb 17th, 2010
You can schedule the report inBO -------- BCA (Broad cast agent)BO XI onwards -------- CMS (Control Management Server)VBA Macro
pinki
- Jul 14th, 2006
We can schedule the reports through broadcast agent.
-
State the difference between Webi and Infoview
itsmuzaffar
- Feb 11th, 2010
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 ...
Goverdhan Reddy
- Aug 10th, 2006
Difference between the Infoview and WI????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 ...
-
What are the browsers that Business Object Web reports supports ?
vkypa
- Feb 9th, 2010
There is no restriction on the browsers for Business Objects. You can use the same URL to login to BO. But the default browser is Internet Explorer.
Business Objects Interview Questions
Ans