-
-
How would I hide fields in a report other than formatting the cells?
sheriey
- Nov 29th, 2007
You can do in Webi also. This is not the proper way but it is just a work around. Just make the backgroung color and text color white and minimize the width. you will only see a little gap in the report
Amit Sachan
- Nov 21st, 2007
We can hide the coloumn from the report with out formatting.when ever you are making the report the total columns comes in dataprovider in form of select query. those columns also appear in slice and ...
-
@aggregate aware function
What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function.
sheriey
- Nov 29th, 2007
The @Aggregate_Aware function allows an object to take advantage of tablescontaining summary data in the database. If your database contains summarytables and you are running queries that return aggre...
shilps.verma
- Nov 24th, 2007
Lets understand the use of Aggregation first with examples.Information is stored in the datawarehouse in the summarised form.Instead of recording the date and time each time a certain product is sold,...
-
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
-
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.
-
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...
-
Snow flake schema is normalized or denormalized? Explain how?
VAMSIKRISHNACH
- Dec 9th, 2007
Facts : Always normalised in both the schemasDimensions : Denormalised in StarDimensions : Dimension bcoz of which you are calling a particular star as snow-flake only is normalised but remaining dimension are denormalised
jayasudha.alvi
- Nov 7th, 2007
Hi,Snow flake schema is normalized, bcoz it is interlinked with other dimensions and it is having lot of complex joins, and takes huge database size? and ?the performance wise very slow it will take time a lot to retrieve the data?.cheersJaya
-
Explain scenario where you would use theta Join in Business objects ?
chskumar
- Dec 24th, 2007
use of a theta join: let's assume that we have a customer_look-up table and Age_group look-up table in ur schmea u have a age column in ur customer table u need to match the age column with ...
ravi_kumar_garre
- Dec 20th, 2007
Hi Use of Theta join in BO:consider you have a table called "Customer" having AGE one column. And another table called "AGE_GROUP" with coulmns MAX_AGE and MIN_AGE. If you want to ...
-
What is canned universe and canned reports in bo?
chskumar
- Dec 24th, 2007
Canned reports means pre-defined reports given by the cleint....he wants the report in a specified format .i am sure that there is no canned universe there is always a ad-hoc universe onlyyy.............cheers sateesh
kiran
- Nov 19th, 2007
Canned reports are the Pre defined reports..where in which you get the requirement from the users through a requirement specification doc. I havent heard of a canned Universe....bcos every universe should be adhoc
-
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 ...
-
Query not returning any value?
What are the steps to take when the query will not return any value?
-
Hyperlinks for subreports in Webi
How can we use hyperlinks for subreports in Webi documents in XIr2
-
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.
-
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...
-
What is the difference between condition and filter? What is thumbnail?
bolladi
- Jan 19th, 2008
In short we can say,, Condition : Applied on the query(QP) to restrict data retrieved from the database... Filter : Applied on the report to hide the data which is already retrieved from DB
sarangoun
- Dec 5th, 2007
Thumbnail: A thumbnail is a small image, or a part of a larger image. Normally a thumbnail will be of a border background, or a background set, or a photograph. Clicking...
-
What's the major difference between regular universe & metric universe?
mhreddy
- Jan 21st, 2008
In case of regular universe all the tables have to be joined. where as in case of Metric universe all the tables need not be joined, there can be isolated tables in universe.In metric universe object ...
avbaby
- Jan 4th, 2008
Regular universe is created when there is a need to create reports only using the universe.metric universe is created when we to create analytics from the universe.
-
How do you restrict the users from using a particular universe, a class or object(s) of a universe, a particular document etc?
Pers.L
- Jan 23rd, 2008
1. In supervisor select the user to whom you will restrict. Right click on the universe in the resource pane and select disable.2. For restricting the class and objects, select the user and right clic...
-
Sub-Reports in a Report
How can can we apply Sub-Reports in a Report?
Pers.L
- Jan 23rd, 2008
Every report having some report tabs. The report tab which was created from the base report is called base report and nothing but the exact duplicate of the base report.
-
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.
-
While resolving loops, how to decide whether alias or context to be used?
Amandeep
- Nov 3rd, 2007
If the dimension table involved in the loop is associated with more than one fact table, then for each fact table, an alias would be required for each dimension leading to a chaos. Contexts are advised in such cases, one for each fact tableFurther consider the scenarioFact1
Business Objects Interview Questions
Ans