-
What’s universal join in BOs?
VIKRAM KUMAR
- Mar 8th, 2018
Universal refer to in all. So, in BO there are many types of joins which are used as per need while designing. There is no such join that can be used everywhere across the Business object for joining purpose. So there is nothing called as universal join.
-
-
What do you use aliases and contexts when working with loops ?
raghu
- Aug 26th, 2011
When we got loop in the universe, we can resolve loop for using alias and context. But there is no rule for going alias and context. But if we have too many to one converges on single table we go for alias.
Raji G
- Feb 24th, 2010
While making with between the tables, loops will be created .When the loop will occur with the Master table (Look up table) we have to use Aliases to resolve the loops.When the loop will occur with th...
-
BOXIR2 is Which type of OLAP?
satish
- Oct 15th, 2007
Its a DOLAP solution because the cache is built dynamically, either on desktop in case of DeskI or on enterprise server in case of WebI. We can also say it as a ROLAP because it BO provides automatic drill through to detail, server based ranking,aggragate navigation.
-
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 ...
-
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...
-
Different background in alternative rows
hi hii am senthil. i have one question please help me.i want to set the report Different background in alternative rows(like even number rows one background color and odd number rows in one background colour)how i do this one?
mkm123
- Mar 15th, 2008
In WEBI, select whole structure of table, and select the Alternet row/column colour from the properties window.
-
How to create S.No variable which starts from 1 ?
I am trying to create S.No. column for a report by writing this formulae =RowIndex() Where (="2002")But is generating S.No starting from 0 (not from 1).
-
How to share documents
Can anybody tell me how to share a document and how to check the document which i have shared in web intelligence.
Rajnish_kaushal
- Apr 13th, 2009
Addition to what has already been answered.if sharing documents using Public Folders. You can allow users to share their comments about data displayed on report using Discussions tab in the report. If...
hari7878
- Sep 10th, 2008
There are several options are available in BO for sharing purpose.1.You can save your documents in public folders2.You can send your documents to their inbox.3.You can share your repository.4.You can share throuh via online mode etc
-
Templates
I have saved my reports in to a category. Now i want to modify all the reports with the same change. So how can I change all the reports at a time? If I want to use a template, how can I apply it to all the reports at once?
54446
- Sep 17th, 2009
Yes after creating report also we can apply template which you wanted to apply but one report at a time at desktop,Go to Format-->Report-->Apply template.You will go to all report template and also you have a browser to your own template.
Rajnish_kaushal
- Apr 13th, 2009
If I have to reply to this question, I will reply as "It is shame business objects do not have templates. but at the same time, if we start creating templates we will end up creating number of differe...
-
Send Report
How to send report/universe from development environment to production environment?
sapna
- Aug 29th, 2017
If you are using SAP BO 4.0/.1, You can use promotion management tool to send reports/universe from developement environment to production environment.
mudit0506
- Dec 1st, 2011
With BI 4.0, we cannot anymore use Import Wizard instead we have to use LCM for migrating Reports from one Environment to another. Import Wizard will only be used to migrate reports from One version o...
-
QAAWs and Live office
What is the difference between QAAWs and Live office?
Aditya
- Dec 7th, 2014
Major differences b/w live office, Qaaws and BI services is... Live Office. Live Office is a Business Objects tool that is installed as an add-on to Microsoft Office Excel. This allows you to connec...
lionskashif
- Aug 30th, 2012
Qaaws : As you know Query As a Web Service. It is generate the URL for using in Dashboard to access report data as a Data Source.
Live Office : Bessically is a technique how to connect Dashboard with your different data source through Excel. It can be Webi, Crystal, Excel etc... file. -
-
What is the diferrence between slice and dice and cross tab report?
jgd.ramesh
- Aug 19th, 2007
It is user friendly and changing the position of data,it is grapical representation to analyis the data
vishnuvardhanreddy.k
- Apr 19th, 2007
Slice and Dice : Arrangement of Data Crosstab report is for Comparision.Cheers,Vishnu.
-
How we drill up week to Month?
sandeepkumarc
- Jun 13th, 2008
Very simple, click scope of analysis-> select by hierarcy radio button -> check boxes of year and month -> click ok ->run->generate report-> click drill tab ->you will get a...
jgd.ramesh
- Aug 19th, 2007
First you set in report level?customer hierarchies and then using drill mode
-
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 ...
-
When there are 2 prompt statements given one after the other which one is prompted first when RUN?
zbiswajitece
- Jun 9th, 2011
Yes the prompts will be appearing in order of their creation when u run the report .
nishamakhija21
- Nov 10th, 2008
Hi,It depends upon what object u drag and drop as a prompt first time in condition pane of the report.Eg: Case1: say while creating the report, u add "Enter Year" as a first ...
-
How to create predefined filters in BO
lionskashif
- Aug 30th, 2012
when you have a restriction and you dont want to bound the variable or Object then you need to make Predefine filter in Universe. For example. you have city Object and there is couple of people using ...
VP
- Apr 2nd, 2012
There are 4 filters
Pre defined filters
custom filters
prompts filters
quick filters
Pre defined filters are created at the Universe level.In the Universe window,select the object,right click ,select condition then enter the condition name and filter conditions -
How to decrease time running query for report?
Hi All, My query take long time for running query/report. How to manage time for running fast report/query?
lionskashif
- Aug 28th, 2012
Query Performance: I would say you should check first SQL and run against directly to the database and note that it is taking the same time to fetching the data. 2) Try to avoid extra prompt in your r...
Krishna
- Dec 1st, 2011
Check your Sql Query for all Data providers in your report
In Groupby is there any measure you have.
If you have measure objects in groupby then it will take too much time run the report. -
Business Objects Interview Questions
Ans