-
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.
-
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...
-
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...
-
'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...
-
Alerters
What are alerters in BO?
sagarikaka
- Oct 29th, 2008
Alerters are used to draw attention to a block of data either by hightlighting or by displaying some messages near the cell.
-
-
In webi XI how can we create report by using multiple data providers?
phinnies
- Oct 24th, 2008
My experience has been that there three ways in which to use multiple data sources in a single report. 1. Purchase Data Federator 2. Migrate all data to a single Database3: Link data via multiple quer...
-
Differences between Deski and Webi XI
Can anybody list what are all the differences between the Desktop Intelligence and Web Intelligence in XIR2?
srikanth4bos
- Oct 21st, 2008
In Deski User defind objects are there but in Webi there is no User defined objects if you create variable and formulasIn Deski Undo operation is perform many time but in Webi it will perform only one time
vams_gk
- Apr 8th, 2008
DI :1)not more interactive 2)u need universe in ur local system..otherwise import from the repositary server 3)need BO software client versi...
-
Automation of Goal Refresh via SDk
How to automate goal refresh using Java SDK?
-
(ERR101)Failed to intialize the active manager [DBD,[Microsoft OLE DB provider for sql server]: Invalid object name OBJ_M_ACTOR'.43502
This is the error iam getting. Help me out
">How to Import universes and user from business object 6.5 to XI R2, it is showing as some ODBC error is there any setting to change?when i start the Import Wizard it is asking the Source environment, i selected the source evironment as BO 6.x, i gave the username and password, I gave the key file of BO6.x and then when i gave next it is showing as"Error logging on to server. Please check logon information and try again.(ERR101)Failed to intialize the active manager [DBD,[Microsoft OLE DB provider for sql server]: Invalid object name OBJ_M_ACTOR'.43502This is the error iam getting. Help me out
viru_dwh
- Oct 10th, 2008
First login on your BO cmc then import the universes from 6.5.check your user name and password on both BO vesion.
surendra
- Feb 8th, 2007
First u have to check CMS. all servers are running or not. and then login into cmc with administrator. if everything is ok! i think u will not get this error. which OS are using. use win 2000 server SP4 pack. and install sql server.
-
IRise with RUP
How do you use iRise prototyping tool with RUP process? How do you use iRise rational requisite pro?
-
How can I create a TODAY variable in WEBi or full client?
In Excel I simply use the TODAY() command. Is there a BO equivalent that I don't know about?
WebIDG
- Sep 16th, 2008
There is a function for this. The best way to do this from the WebI is:on Edit Report tab, on your variables panel, click on "template" > "free standing cells" > under "Formula and Text Cells" click a...
-
BO Report and Web Intelligence Issue
I am not able to save BO report created in Web Intelligence. . When I try to save after giving name and descriptions, keywords and all just plain box pops up but it is not saved. It used to work fine earlier. Could anybody tell me please what went wrong ??
shaunakhs
- Sep 12th, 2008
Please check if your saving webi doc option in BO supervisor is still enabled for your id or not.
zeenat14
- Apr 25th, 2008
Goto CMC, than click on users n than (advance rights) and check whether on ur login id , save rights are given or not, sometimes this also creates problem.
-
Cross Tab and Tabular Report
What is the difference between Cross Tab and Tabular Rreport?
hari7878
- Sep 10th, 2008
Cross tab:1.Cross tabs are three dimensional grid.2.Cross tabs are provides essential information for analysing the data.3.These are applicable for more than two filedsTabula:1.Tabular reports ar...
sreenivas27
- Aug 10th, 2008
Hi Cross Tab reports analysis like 3 dimentional Tabular report u can analysis 2 dimentional ...
-
-
Testing a report
How will you test a report whether it is returning the correct results or not? in WebXIR2
michaelgaultner
- Aug 27th, 2008
I think we can do data validation test. Checking the summary results of the reports by writing
SQL query against database.checking the columns, fields, alignments, report look etc. satisfying the report required
specs.Correct me if i am wrong -
Dimensional and Fact Table
Is it possible to use a dimensional table as a fact table also, if yes, how?
muralikrishna1982
- Aug 25th, 2008
Yes you can use. that is in the snow flake schema one fact table acts as a dimension to another fact table.
-
Restriction on Class / Universe
How do you restrict the users from using a particular universe, a class or object(s) of a universe, a particular document etc in BO xi R2? Where can we apply it.
muralikrishna1982
- Aug 23rd, 2008
You can restrict an object / class / universeIn the Designer go to Tools --> ManageAccess restrictionsa new window will open, at the top of this window you will have labels as objects --- classes --...
-
What is Scope of Analysis?
muralikrishna1982
- Aug 24th, 2008
Scope of Analysis will retrieve additional objects from the database based upon your definition as one level, two levels or none. but these additional objects will not be displayed in the report resul...
amjad.shaik
- Nov 13th, 2007
Scope of analysis is a multidimensional analysis technique through which u can set the analysis upto one leveldown,two level down etc.
-
WebI report
1. can we apply a sort or rank on a webI report column in XIr2 version??2. where will you give the row level restrictions in XIr2 Designer??
muralikrishna1982
- Aug 24th, 2008
yes we can apply sort or rank on a column with in the report of xir2 , you have to apply any one of them at a time , you can't go for both at a time with in the report. hope this wil clear your do...
Business Objects Interview Questions
Ans