-
How do you apply ranking on crosstab ..? Is there any limit for rows and columns in the crosstab
VIKRAM KUMAR
- Mar 8th, 2018
We can apply ranking function in cross tab at WEBi report by creating a variable as =Rank(Sum() in dimension name) or we can go for creating a variable for the sum of the measure that we have along wi...
jemimaplatina
- Jan 13th, 2010
In the cross tab define the rank based on the lower level object you are pulling into the report. example: one country can have multiple states. One state can have multiple cities. If you are pulling ...
-
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 ...
-
Tell me about Business objects architecture
ASHOK1324
- Apr 19th, 2009
BO architecture has 3 layers. Database Layer, Business [Interface] Layer and Presentation Layer.Database layer contains the below tasks.1]. Define Universe Parameters to provide connectivity to databa...
Goverdhan Reddy
- Oct 18th, 2006
Hi guys here Iam giving the brief introduction regarding the architecture of BO XIIn BusinessObjects Enterprise XI, there are five tiers: the client tier, the application tier, the intelligence tier, ...
-
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...
-
-
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.
-
What is Business Object
s
- Mar 11th, 2007
Bussiness objects is query,reporting and analysis solutions for bussiness professinals that allows to retrive the data from various database and present the information in the bussiness documect.
-
What is Infoview in BO? andWhat are the differences between BO 6.5 and BO XIR2?
SUBBU
- Mar 11th, 2007
In bo 6.0 repository is created after instaling the bobj software.the repository is created by general supervisor.in bobj xi the repository is created at the software instalation.
-
Can we save or create more than one universe in one repository.
anil
- Mar 13th, 2007
Yes, u can more than one universe in the repository..which different names.....
-
Why there is no global or local repository like in informatica?Why BO is not using any server like informatica repository server or informatica server?
sat.inn
- Feb 10th, 2007
K thanks for ur response. But what abt the repository server?(talking abt BO 5.1)...And is there any scope for BO 5.1?..how s the market?
Guest
- Feb 9th, 2007
Actually, we have a global repository in Business Objects like informatica. It contains the users and domain information such as security domain, universe domain, document domain all are combinely cal...
-
What is info bust in BO, What is the main purpose of this?What is meant by report tracing in BO?When and where we use @variable function in BO?
prashantpurohit2000
- Mar 3rd, 2009
@Variable function can be used in BO designer, this function can be used in the SELECT clause of objects for display to the user or in the WHERE clause to restrict data. @variable(BOUSER) returns the infoview user, you can implement row-level restriction using this function.
prashantpurohit2000
- Mar 3rd, 2009
All server trace files are located in the logging folder, for BusinessObjects XIR2 the path is Business ObjectsBusinessObjects Enterprise 11.5Logging.
-
Is there any significance of testing the BO report by getting the Dataprovider SQL and running it against the DB to check whether the report and the DB gives the same data?
Is it like integrity check? Will we be able to find out any mis-match with the help of this?Kindly help me out in this.
nishamakhija21
- Nov 10th, 2008
Hi,The most difficult thing in BO is to Test, since we dont have any backtrace mechanism.So to test the report the most important thing to know is the Logic of the report, i.e Business logic behind th...
sreya_1234
- Feb 1st, 2008
In the query panel, go to SQL button -> there you can find the SQL query generated for that particular data provider. use the same sql query and run it in the backend. the results should match with the report data or when you see Data -> view data -> results tab.
-
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.
-
What is the difference between user and versatile user in superviser product?
I think user can work on all report in the document, but versatile user is a temparory user, so he work in particular report only.
BPatel
- Feb 1st, 2008
User : can have access of BO report product in terms of view, report, analyze, and query.versatile user: can have access of either of above but only if supervisor granted it.
sreya_1234
- Feb 1st, 2008
User profile - can access only Business Objects (Reporter).Versatile profile - This user is authorized to use any combination of products defined by a supervisor.
-
How would I achieve Traffic Lighting in Business Objects
princy2ch
- Mar 4th, 2009
It is alerters. You can set alerters in business objects reports if you want to highlight few rows in your report
nishamakhija21
- Nov 10th, 2008
Hi,Can anyone tell me what is Traffic Lightening in BO??I have never heard of this term...
-
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.
-
-
Foreach and Forall
Difference between Foreach and Forall?
lionskashif
- Aug 28th, 2012
There are major Three Context Operator use in the calculation.
ForAll : Operator Remove the Dimension form the Calculation context.
ForEach : Operator Add the Dimension From the Calculation Context.
In : Operator give you calculation from the scratch.
dasu.kaveri
- Oct 27th, 2010
Both ForEach and ForAll Operatators are context operators.ForEach allows us to define groups within the data context for our calculations.Whereas ForAll allows us to instruct Business Objects which dimensions in the report context will not affect our calculations.
-
What is the maximum possible number of tables in the repository
I am working on the Business Objects 6.5.1 Repository which is in Oracle 9i database. I need your help regarding this. Firstly, What is the maximum possible number of tables in the repository? Secondly, Is it possible to generate a report that describes the user's access rights in details (Like a user has access to Business Objects, BQY, Webintelligence, supervisor or designer . - Thank you
sreenivas27
- Jun 18th, 2008
Hi All,Repository have 57 tables.1. security domain have 25 tables.2. Document domain have 1 table3. Universe Domain have 31 tables.it possible create audit reports what ever you want.Thanks.
sreenivas27
- Jun 18th, 2008
Hi In BusinessObjects 6.5 Repository 57 tablesSecurity Domain tables 251. OBJ_M_ACTOR2. OBJ_M_USRATTR3. OBJ_M_DOCCST4. OBJ_M_GENPAR5. OBJ_M_MAGICID6. OBJ_M_RESLINK7. OBJ_M_UNIVCST8. OBJ_M_UNIVSLC9. OB...
-
Differences Between WEBI & Full Client BO
Can someone send me a listing of things you cannot do in WebI that you can do in DeskI?
Rajnish_kaushal
- Apr 13th, 2009
Subqueries can be created in webi as well. Webi is thin client whereas deski is thick client. Webi has less number of graphs / charts wheres as Deski has more options.Rest of the difference are already covered by other members.RegardsRajnish Kaushal
Revansing
- Nov 25th, 2008
Apart these I found differences mainly in formatting perspectives.for ex the Ouline(Folding) functionality in DeskI cannot be achieved in Web I we needs to get it done differnly either drilling or Hyp...
Business Objects Interview Questions
Ans