saisowhit

• Nov 19th, 2015

By creating condition for top 50 contractors

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Feb 17th, 2011

First you need to put the RANK function on the report for top 50 then you put the row level security for 50rows .................. I hope it will work...........

Answer Question  Select Best Answer

sreenu

• Nov 25th, 2015

By using check integrity you can find errors what I did all mistakes in universe

Akhil Rawat

• Nov 12th, 2014

After creating the universe, one can debug the same for finding the errors one can just go to Tools in the top panel and click on Integrity Check and then one can tick mark all the options for which o...

Answer Question  Select Best Answer

Hi,I want to know what are the requirement to make registration of vat

Dilshan

• Dec 19th, 2015

Create variable based on the Sales multiply your tax with that column. Finally you can drag and drop. You can find a taxation block in a report.

Answer Question  Select Best Answer

kareem

• Jan 5th, 2016

By using relative position

venkat

• Jan 25th, 2015

Best way to use " Relative position"

Answer Question  Select Best Answer

Pavan reddy

• Mar 16th, 2016

Report bursting is nothing but running report at one time and distribute results to multiple users. Example: Suppose if we have multiple sales persons and each sales person want to see only his repor...

pat.mclean

 Profile Answers by pat.mclean Questions by pat.mclean

• May 26th, 2006

If some part of the data in your report is sensative, you can't risk sending the whole report to everybody, even to those who need to see the least sensative part of report !Solution is Report Burstin...

Answer Question  Select Best Answer

What are the Roles and Responsibilities of SAP BO Consultant

Brahmareddy

• Mar 16th, 2016

The Roles are Purely Defends Upon Types of Projects.... -----If it is Development Project---- 1.Requirements gathering 2.Clarification interactions 3.Technical specification documents 4.Development(Re...

Jitin

• Jan 29th, 2016

To me, a BO Consultant is a person not only with good technical expertise on the subject but also has knowledge on the domain(retail, banking, pharma etc), and ofcourse has analytical skills and skill...

Answer Question  Select Best Answer

Jose Roy

• Apr 8th, 2016

3 type of filters are there
1) Query filter
2) Report Filter-Two type a) Global Filter b) Block Filter
3) Predefined Filter

azzar

• Apr 13th, 2015

Simple,Multiple,Complex,Predefined(Function),Prompt .

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

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

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

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

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

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 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

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 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

• 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 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

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

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