-
I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Karthik
- Nov 1st, 2007
When?you want to perform the prompts with your requirements you follow this@prompt("enter the month","a" ,multi/mono, free/constrained, USER.2)then this prompt performs as first one .Like that you can define your own prompt
-
How to filter repeatative values in the report to get distinct values.Example: In any database we can use distinct command But My Report source is flatfile.Therfore,I cann\'t manipulate source system. Is there any command or function to filter repeating records/values in the report.Advance,Thanks.BO-Nath
smghurde2
- Sep 10th, 2009
I suggest you use the break function as it filteres the distinct values.Hope it help,NEAL
Omkar Paranjpe
- Mar 18th, 2006
Hi,One other way possible is by doing "No Duplicates" radio button in the Options of the data provider in the Definition(the black cube)But sometimes in free-hand sql reports it is not possible.
-
-
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...
-
What are all difference between business objects 6.5 and XI R2
nameer.pmp
- May 10th, 2011
BO 6.5:1. 3 tier architecture2. Supervisor is?used as administration console3. Security - Object level and Row level4. Only universe is used as the data provider5. Central configuration manager to ma...
-
-
If in a report i get 4 times the actual value then what are the various soloutions to rectift it
kalpesh_geek
- Aug 21st, 2007
By default, the 'Avoid Duplicate Row Aggregation' option is disabled. Your problem may be due to this option. To enable this, right click on the block, format table and select this option
Fazalhusein Z Patvi
- Mar 17th, 2007
A very common problem.There are 2 reasons. 1. The query itself is returning multiple rows. That is the result set does not contain single distinct rows but multiple rows. Eg:Country&n...
-
-
How can we use the multiple data providers in a single report?
sshyam
- Aug 22nd, 2008
We can use multiple data providers in a single report by creating two different queries for each of the data providers and then syncronising the result by merging the dimensions.
antonykumar
- Jan 3rd, 2008
Yes, it is possible through Business View(BV) Managers XI R2.Design the BV with multiple datasouce.Assign BV as the datasource for the crystal reports.+Antony
-
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...
-
What is Broad casting Agent?
what is it used and what are the steps to follow BCA??
sarangoun
- Nov 19th, 2007
HAI I AM SARAVANAN BCA is a document sceduler that allows you to publish the finished results in a number of ways ,BCA is a software product to process and distribute documents autom...
swapna
- Nov 13th, 2007
A Business Objects application that allows users to automatically process and publish documents using either the repository, intranet, extranet or over the web. Broadcast Agent consists of four components: Scheduler, Broadcast AgentConsole, BusinessObjects Services Administrator and BOManager
-
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 is difference between BOXIR2 and BOXIR3?
Kiran Venkata
- Oct 17th, 2011
Major difference b/w XIR2 and XI3.1 from the server part
1. we have a centralized server SIA which manages all the other servers in XI3.1.
2. In XI3.1 webi rich client has been introduced.
3. Security model is different regarding inheritance in XI3.1
etc
B.Nikhileswara Reddy
- Jun 5th, 2011
XI r2----we used to do the webI reports in Infoview that is in the web. XI r3----we can do the webi in both infoview and rich clint that is we can do the reporting in online and offline modes. 1. W...
-
-
-
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...
-
What is the difference between derived tables and a view? Which one gives better performance ?
Pradeep Mishra
- Jan 7th, 2010
Yes, it's too good.But One more thing is there , We can use The @Function (@variable,@Prompt) in the derived Table ,but we can't do the Same thing in the Views.So you can say that these are benefits are in the Derived Tables.
pat.mclean
- Mar 23rd, 2007
Hi !Just an addition, 1. Views play all their rollups at database level. Derived Tables will fetch values into BO's microcube & then will perform the rollup calculations, resulting more proces...
-
What is the diferrence between slice and dice & drill through
sandeepkumarc
- Jun 13th, 2008
Slice and dice is used for data manipulation and Drill through is used for Data analysis.
Latha03
- Jan 20th, 2007
HiSlice and dice allows us to show and hide the objectsWhere as drill allows us to drill the data like drill up, drill down, drill through depending upon the user requirements.
-
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.
-
1)How to send universe from Development to Production?2)How to send reports from Development to Production?3)There are 2 tables...table 1 and table 2....suppose if table 1 shows some times shows 5 rows an some other time it shows 50 rows...if there is no sufficient space in table 2 for 50 rows then how can this issue be solved??How can we stop overlapping?4)If there are 50 objects ina an universe...suppose if we want to change the objects from varchar to numeric then how can it be modified..where we have to change this?5)One report is there and after running the report,it always displays the message called partial result so to what should be done to stop displayingthar msg?6)To resolve the loop,why cant we choose context..why we are using alias to do that?7)suppose there is an object called empno and first it is kept that as varchar in universe and suppose if we want to change that varchar to numeric,then how to reflect that change?
anuanu
- May 24th, 2008
1 &2 ) In our scenario will maintain only one copy of the universe and whatever the changes we need to add, will do that in dev and then will export it to repository. the admin will migrate t...
newinbo
- Apr 23rd, 2008
I don't know whether the answer given by Bandaru is correct or not. But seems it is based on BO 6.X version or earlier. There is nothing like Supervisor in BO XIR2. So is above ans...
Business Objects Interview Questions
Ans