Which is ( are ) correct about object inheritance

1. Rights set at global level inherit rights set at folder level
2. Top level folders inherit rights set at folder level.
3. Object inherit rights from the parent folder
4. Rights Inherited from the parent folder override explicit rights set at object level.

Venkataramana Kamarshi

• Sep 12th, 2019

Object(s) inherit rights from the parent folder

Answer Question  Select Best Answer

VIKRAM KUMAR

• Mar 8th, 2018

We can apply ranking function in cross tab at WEBi report by creating a variable as =Rank(Sum() in dimension name) or we can go for creating a variable for the sum of the measure that we have along wi...

jemimaplatina

 Profile Answers by jemimaplatina Questions by jemimaplatina

• Jan 13th, 2010

In the cross tab define the rank based on the lower level object you are pulling into the report. example: one country can have multiple states. One state can have multiple cities. If you are pulling ...

Answer Question  Select Best Answer

VIKRAM KUMAR

• Mar 8th, 2018

Hierarchy can be defined as parent child relationship i.e. from higher to granular level and vice versa. Custom hierarchy can be set and defined at universe level. While we design a universe in BO env...

Ravinder Singh

• Sep 3rd, 2012

Custom hierarchy is used in Scope of Analysis, we can decide the hierarchy as per requirement. For e.g. if there is a hierarchy Year

Answer Question  Select Best Answer

VIKRAM KUMAR

• Mar 8th, 2018

Data profiling is a feature of SAP BODS. Data profiling handles the inconsistencies seen in data. When data comes in through a single interface, the program can validate data as it is entered. But in ...

smilley

 Profile Answers by smilley Questions by smilley

• Dec 26th, 2006

data synchronisation is used to synchronise data from say 2 data providers :1 say all list of sent emails2 say all list of recd emailsyou can synchronise these 2 lists using merged dimensions in webih...

Answer Question  Select Best Answer

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.

rsvM31

 Profile Answers by rsvM31 Questions by rsvM31

• Jan 15th, 2009

Two universes can be link Dynamically by using "Link Parameter".

Answer Question  Select Best Answer

Rahul B

• Jan 17th, 2018

Rank - After same ranking , next ranks are skipped e.g. 1,2,2,4,5,6,6,6,6....
Dense_rank - After same ranking also ranking continues e.g. 1,2,2,3,4,5,6,6,6,7....

venkat

• May 13th, 2006

The DENSE_RANK function computes the rank of a row in an ordered group of rows. The ranks are consecutive integers beginning with 1. The largest rank value is the number of unique values returned by t...

Answer Question  Select Best Answer

shekar

• Jan 15th, 2018

Context is a collection of joins in universe, which is generates a Query in Business Objects.

dileep

• Aug 23rd, 2016

In BO, Context is nothing but query travelling path.
In Webi it is a calculation

Answer Question  Select Best Answer

How to create reports in universe easily?

Asish

• Nov 1st, 2017

Make sure proper schema design with dimension, measure, detail, proper join, mapping of of all parameter at Report level, We need to tune DB query for calculating all measure, dimension at report or Universe Report Tuning level!

bala

• Jan 29th, 2016

In Universe, 1. We have array fetch size option in relation connection. In that we will mention the max. no. of row to be hit and extract form the data base for each time. 2. Reduce derived tables,...

Answer Question  Select Best Answer

Sapna

• Sep 4th, 2017

When we have either two different database or two different universes.

prashantpurohit2000

 Profile Answers by prashantpurohit2000 Questions by prashantpurohit2000

• Mar 3rd, 2009

You should use more than 1 data provider when you feel that you need different data set to design your report properly. These data providers can be from different database/universe or same database/universe.

Answer Question  Select Best Answer

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

 Profile Answers by mudit0506 Questions by 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...

Answer Question  Select Best Answer

sapna

• Aug 29th, 2017

Using Promotion Management Tool, We can export reports to one repository to another repository.

VP

• Apr 2nd, 2012

When ever we work with DESKI/WEBI rich client, we have option to save the report in the local m/c or in the repository.Select File->export, report gets saved in the repository.

Answer Question  Select Best Answer

how to change the date format in Prompt ie dd/mm/yyyy to mm/dd/yyyy?

sapna

• Aug 29th, 2017

Formatdate(UserResponse("Select Start Date:"),"mm/dd/yyyy")

Srini B

 Profile Answers by Srini B Questions by Srini B

• Feb 2nd, 2012

In Oracle to_date(to_char(datecol, mm/dd/yyyy), mm/dd/yyyy)

Answer Question  Select Best Answer

e.g i have a column having data as 1, 5, 7, 3, 4, 5, 9Sorting will sort as 1,3,4,5,5,7,9What will ranking do???

Vinayak SB

• Aug 1st, 2017

In order of the data and rank : 1 1; 3 2; 4 3; 5 4; 5 4; 7 6; 9 7

mithun

• Apr 6th, 2017

Filtering: Filters the data according to the selected parameter.
Sorting: It simply sort the data in ascending or descending order.

Answer Question  Select Best Answer

How we will do universe report optimization, tuning at query level? What are the major Universe Project estimation parameter in Estimation sheet?

Deepak

• Jun 25th, 2017

1. Using aggregation tables in scheme.
2. Chnge the Array Fetch parameter.
3. Using shot cut joins.
4. Puting indexes on tables.

Answer Question  Select Best Answer

Sanjay Mohan

• Jun 15th, 2017

Local filters are applicable within the block whereas the Global filters are applied outside the block. Using global filter restrict the data set within the whole block in the report

Mohd Irshad Sahad

• Apr 6th, 2017

Block Filter is applied when you just want to show Chart/table with some restricted dim values. For example in a table you just want to show the number of support incidents resolved in time. But in th...

Answer Question  Select Best Answer

Hi,

I have to develop a Webi report (3.1) in which I need to calculate sales for 6 weeks like this

Date Range Sales

Dec 28,2015 - Jan 3,2016 23,000
Jan 4 ,2016 - Jan 10, 2016 16,000
Jan 11,2016 - Jan 17,2016 7,000
Jan 18,2016 - Jan 24,2016 ...

Sanjay Mohan

• Jun 15th, 2017

1. Could you please share me the Quantifiable measure used within?

@Vara

• Feb 2nd, 2017

If you have access to write Custom Query in the Report, it will be easy. I am not sure about report level.

Answer Question  Select Best Answer

Give examples for Complex WEBI report, Complex Crystal Report, Complex universe

Pradeep

• Aug 22nd, 2016

Complex WebI mean what all WebI functionalities you used, like Input Control, Ranking, Section, Break, Conditional Formatting, Element Linking, Hyperlink, Prompt, User Response function, Cust...

Answer Question  Select Best Answer

Benny Paul

• May 9th, 2016

The micro cube refers to the data set returned from the query that is then processed by the Web Intelligence. For example, when we drill the data, the data in the micro cube is analyzed. The micro cub...

Jeff

• Jun 3rd, 2015

The micro cube is not the universe designer tool. The micro cube refers to the data set returned from the query that is then processed by the WebIntelligence (or other report tool).

Answer Question  Select Best Answer

Explain some of the things you might teach a new employee in regards to personal information

What you might need to think about in regards to the storage of personal information?