-
'CMS' in BO XI
What is 'CMS' in BO XI?
sagarikaka
- Nov 5th, 2008
CMS standsfor Central Management Server which provides scheduling, security and system management services. You cannot login BO if CMS is not activated. It is a repository where all universes are stored. CMS is one of the main component in intelligence tier.
madhu09
- Aug 17th, 2008
It is the component within XI handling security and routing the request to other services.if the CMS is not runing than user willnot be able to login to BO's.if however the CMS is runing but other ser...
-
ANSI92
What is ANSI92 and What is its usage?
sagarikaka
- Nov 5th, 2008
If the target RDBMS supports ANSI92, then you can set a universe parameter. ANSI92 support for joins created in your schema. When a universe supports the ANSI92 standard for joins, newly created joins...
-
Cascading and nested prompts
How do I create cascading or nested prompts
nishamakhija21
- Nov 10th, 2008
Hi,In Universe designer Go to Tools->List of Values-> Create cascading list of values.here u have option to define the Cascading list of values, suppose if u want to create cascading list like Y...
-
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.
-
What is Business Objects Auditor and what can you do by using Auditor?
nishamakhija21
- Nov 10th, 2008
Hi,In business objects we have Auditor Database, which is used to store the auditing information about every user.Like suppose if User U1 is running some report at what perticular time. or How many ti...
G.V.subramanyam
- Jun 3rd, 2007
In bo 6.5 they are 7 auditor tables created while ur creating a repository.the tables that can store the information about the users and their authentication.
-
How to bring data from 5 different providers into one block...(they are not getting synchronized and all of them has different data types
nishamakhija21
- Nov 10th, 2008
Hi,To synchronize the dat from different data providers, u need to merge similar objects from all data providers and then only u can c the syncronized data in the single block.Eg: DP1 has Dimensi...
-
When do we go for cross tab , master-detail and chart blocks in a report ?
nishamakhija21
- Nov 10th, 2008
Hi,Depending upon the tupe of anaysis u can use any of the above defined blocks.Cross tab : This table will give u 3 dimensional view of data.Eg: Year/Quater 2000 &n...
-
What is UNIT Testing Method in BO?
nishamakhija21
- Nov 10th, 2008
Hi,As far as testing is concern, in BO we should have Functional knowledge of Report we have generated for complex reports. then u can generate logical query by ur own and run it at the backend and co...
-
What is the Hardware & Software system requirement of installation of Business objects xi R2
nishamakhija21
- Nov 10th, 2008
Hi,This is for BOXIR2: RAM 1 GB recommended3 GB free disk spaceOS should be of Windows XP or higher than This version.
Sunil
- Jun 4th, 2007
The minimum hardware requirements are: P3 700MHz 512 MB RAM, 1 Gigabyte RAM recommended 5 Gigabytes available hard drive space CD ROM The software required: 1. Operating system...
-
How Can We Restrict a database connection to a particular user? what i want ask is, particular connection should user only by that user when creating universes, no one should use that connection, how can we do that?
nishamakhija21
- Nov 10th, 2008
HI,I m talking about BOXIR2 version.you can restrict the Connection access to specific user by applying the restrictions on the user rights using CMC.Log on in CMC--> Go into Connections--> sele...
ranjoy7
- Jun 19th, 2008
The secured connection is not meant for share. the user who create the secured connection can access it.
-
Impact of changing the Genaral Supervisor password in supervisor.
What is the impact of changing the General Supervisor password in supervisor, what is the effect on the BO reports sheduled on the BCA under the Genral Supervisor's id?
viru_dwh
- Oct 10th, 2008
Changing the General Supervisor password in supervisor cannot effect your report becoz it is for admin section.
-
What are the steps to create aggreagate awareness table?
elnvishal
- Jun 27th, 2008
Hi,there are 4 steps to apply aggrigateaware 1)insert the summery tabe,set joins and cardinality2)set context3)redefinethe oblject using @aggrigateaware4)define the incompatible objects using aggrigate aware navigationif u got this as right thn plz replay
-
Repository File Format
-
How can a user other than the administrator view the encyclopedia in the Business Objects Enterprise applications of central management console
priyanka286
- Jan 25th, 2009
Go to List Mode View?in designer it will give you list of all the tables, Joins and Contexts used in universe.
-
How can I list the all the tables in the universe used by different objects. Also the tables which are not referred by objects.
priyanka286
- Jan 25th, 2009
Go to List Mode View in designer it will give you list of all the tables, Joins and Contexts used in universe.
-
Scnario: Let you have a reporting period one object in a prompt, and one measure say 'Limit amt' another object you want to show in a report. Now once user enters the prompt, you want reporting period data prior to the entered value in the report along with which is entered in prompt.That means say reporting period is 2007, but you should show 2006 data also in the report. How do you implement it?
prashantpurohit2000
- Mar 3rd, 2009
Hi Nisha,If you apply prompt on reporting period with condition "less than or equal to", you should get the desired data.
-
Currently I am sending the report to users in excel format,if there is no data also the report will be sent,Is there any option in BO to stop report from being sent if there is no data in the report?
prashantpurohit2000
- Mar 3rd, 2009
VBA scripts can be used to implement this but it will be a bit complex because you also need to make some changes in default settings of BO.
-
Can a universe be connected to different databases?
Jay
- Dec 14th, 2006
In Xi rel 2 using data federator you can connect to multiple database.in previous version there is work around, lets you have universe connecting to database user "A" and you are looking to ...
-
How do you get list of all reports used by Business Objects users?
prashantpurohit2000
- Mar 3rd, 2009
If you want to get the list of all the reports, it's not possible. In CMC you can view the list of the reports in a particular folder. You can copy them all and paste special in excel to get the list.
gkrishn01
- Oct 7th, 2007
We Can view the same in CMC.In the objects management area.Regards,
-
What are the Testing responsibilities in BO ?
prashantpurohit2000
- Mar 3rd, 2009
I didn't get you completely but you can test your report SQL against expected SQL on database, run them individually, that will be proper data testing. Other than follow the checklist for formatting and other check.
Business Objects Interview Questions
Ans