-
Dynamic and Cascading Prompt
What is dynamic prompt? What is cascading prompt?how to create these? What is the difference between them.
RishiBO
- Jan 20th, 2010
Cascading prompts are nothing but the Nested/hierarchical Prompts. We can create the cascading prompt by using following Steps.Goto the Universe in Tools select Cascading list of Values from here we c...
-
Refresh Report
How to refresh the report?
RishiBO
- Jan 20th, 2010
Data-->Refresh Data option will Refresh the report as well.If the option is disabled You need to go to Data-->View Data Thn goto definition tab and check the Refreshble button.
-
How to access LOV values in report?How to set Hierarchy in Universe?
RishiBO
- Jan 20th, 2010
Adding to the above Point:Setting Hierarchy in UniverseYou can use the Hierarchies editor to view, create and rearrange existing object hierarchies in your universe.Designer provides a set of default ...
sreya_1234
- Nov 12th, 2007
Accessing LOVs in the report:-Go to Tools -> Universes -> select a universe and click on "List of Values" -> select an object from the table -> display - here you will get list of values for the object which ypu have selected.
-
Report Bursting
Hi Friends,Can any one help me regrading Report Bursting using Business objects xi release 2. what to use in BO XI R2.? can any one give the steps of Report Bursting.Thanks AdvancedSrinath
sree20483
- Jan 24th, 2010
According to my Knowledge,Report bursting concept comes in BO6.5. In XIR2, we use Profiles and Publications which interms called as Report Bursting (in 6.X)To say in brief, we need to create a PROFILE...
-
Business Objects Syncronization
What is Synchronization in Business Objects?
shree_uday
- Feb 8th, 2010
Syncronization in BO defines, method of creating synchronized query, if we find a loop or trap join error in the schema, we go for context to resolve, at this time synchronized query will generate.ie ...
-
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.
-
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 ...
-
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.
-
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 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.
-
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.
-
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.
-
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)
-
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...
-
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
-
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...
-
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.
-
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.
-
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
-
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.
Business Objects Interview Questions
Ans