-
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.
-
-
How do I change AND to OR in the query pane?
nishamakhija21
- Oct 23rd, 2007
Just double click the AND operator on query pannel, it will get converted into Or operartor.
-
-
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 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.
-
What are the issues we are expecting when we convert Business Objects Desktop intelligence Reports TO Web Intelligence Reports.
muralikrishna1982
- Aug 23rd, 2008
There are so many issuesfirst of all you have to logon to report conversion toolBefore that you have to go business objects administration launch pad and then go to Business objects applic...
-
How to display the last refresh report date and time in the below of the report?
sreya_1234
- Dec 6th, 2007
Go to insert -> special field -> date and time -> last refresh, now click below the report area - you will get the date of the last refresh on that particular report.
-
-
Explain about Synchronization Error in Business Objects
hari7878
- Jan 14th, 2008
When you want to see the complex reports on that time you are using option called synchronization.On that time you are choose only comman column and the same data other wiswe it shows the error that e...
-
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...
-
-
What is file watcher? What is the use of it?
sarangoun
- Nov 19th, 2007
HAI I AM SARAVANANFile watcher is using in BCA. File watcher using 4 options using reports scheduling in BCA.1) Delete the file each time the task starts2) Never delete th...
-
How can we project the results of the two data providers in a single table? What is the process of merging two data providers?
Sivakami_Plr
- Oct 29th, 2009
In Webi - we can merge common dimensions from both DPs and then use them to show the measuresIn deski - We need to link common dimensions using Data Manager window.
-
How to suppress the reports in BO?
zingara
- Dec 1st, 2007
Create a seperate folder and dump all the reports to be hidden in it and hide the folder via CMC
-
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...
-
Difference Between ForEach and ForALL ?
Hi Everyone, Can you please tell me what is the difference between ForEach and ForAll (In BO Reporter), and give examples of when they are needed ?. Much appreciated !.Thanks in advance,Veronica
mvm2002_2002
- Dec 7th, 2007
For each The For Each context operator allows you to add dimensions to the current default input context. For example, if a table contains the dimension [year] and [Quarter] and the measure [reven...
-
How many alters can we apply in single column of a report and max no of alters for a whole report.
avbaby
- Jan 4th, 2008
On a single column maximum of 6 conditions can be applied. maximum 8 sub-alerters can be put in a single alert.additional info: BO supports maximum of 30 alerters in a single report.
-
What are derived tables.
chskumar
- Dec 27th, 2007
Derived tables are tables that you define in the universe schema. You createobjects on them as you do with any other table. A derived table is defined by anSQL query at the universe level that can be ...
-
Apply HTML Tags
How to apply HTML tags in a report?
vinny.jus
- Dec 9th, 2009
Using Html tags we can create links to websites based on Object values. This can be done from Designer, DeskI and WebI. To do this let us take a company object,that has values Sap, Microsoft,Oracle an...
Business Objects Interview Questions
Ans