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

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

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

kareem

• Jan 5th, 2016

By using relative position

venkat

• Jan 25th, 2015

Best way to use " Relative position"

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

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

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

I am creating a crosstab report. In rows, I have companies and a field with Actual, budget and variance and a measure in column. I want to calculate sum for actual, buget and variance individually at the end of columns. is it possible?

Poonam Birla

• Nov 18th, 2015

Yes, we can sum up those values. try with this formula in the end of the column =sum(actual), sum(budget),sum(variance).

Answer Question  Select Best Answer

Venky

• Oct 23rd, 2015

Cardinality is more important in the universe other wise its give more data when traps are exist in the universe if loops are there in the universe its gives less data but our requirement is to give accurate data what client is expected so we have to take care while giving cardinal in the universe.

vivek sharma

• Sep 16th, 2015

Everything will work just fine if we don't define the cardinality. but if you define there will be added advantages like: 1) Auto detect function will work that detect the cardinality thud will help i...

Answer Question  Select Best Answer

How to show a message when there is no data in table?

Poojitha S

• Aug 11th, 2015

=if(NumberOfRows([Webi Query Name])=0) then "No Records Found"

Answer Question  Select Best Answer

How to add a description to the list of values?

Abhishek

• Jul 21st, 2015

A LOV is a file which contains list of values of a particular objects.

anil

• Sep 3rd, 2014

A list of the distinct values from the column or columns to which the object refers

Answer Question  Select Best Answer

Raju

• Jul 8th, 2015

Derived table we can use in universe design tool, it is a table by using sql sytax we will create it derived table, main we can create this table by using multiple data providers..

Akhil Rawat

• Nov 12th, 2014

Derived Tables are the tables which are created in the Universe. These are basically used for the databases which are not accessible by the users. One can create Derive Table using the name of the columns which the user wants to access.

Answer Question  Select Best Answer

How to resolve Computationa and Multivalue errors?

Vivekanand

• Jun 24th, 2015

I need clarification from you sir, actually Aggregate function ignore the Null values right.could you please give me example.

tanejvicky

• Mar 6th, 2015

Multivalue error:when we try to add one object values into single cell then we will get multivalue error

resolution:use aggregate awareness

Answer Question  Select Best Answer

Ankit Sahu

• Jun 18th, 2015

Yes it is possible to achieve this by using a merge dimension concept. Create 2 different queries for both the data providers and then create a merge dimension on a common dimension, and then create a single report .

Anyone

• Oct 19th, 2011

Yes the 2nd one is possible only if it is R3(i.e external source).

Answer Question  Select Best Answer

" In WEBi we have to create a chart for complete year wise sale and in a table we have to display only current month sales the thing is we have to use only SINGLE query for both"

Mahesh

• Jun 16th, 2015

Create a block with year, month and sales. Duplicate the block on the same report and apply block level filter on one block as current month.

Answer Question  Select Best Answer

How to resolve it?share some realtime errors?

shashikant chourasia

• Jun 1st, 2015

This message usually comes up when the ODBC connection fails for any reason. It may not be there, someone may have changed the password on the database, or someone may have changed its name. I sug...

Answer Question  Select Best Answer

If I want to use an object from two different classes in one query, what is the procedure to do so...Combined query or merge dimensions?

naguakkina

• May 14th, 2015

so, here in this case two different classes within a data provider -- > go with combined query prerequisite : corresponding number of objects should be same and data types should be same. if y...

phani

• Dec 7th, 2011

It is a common dimension there in two queries. The basic use of merge dimension is to create a common block with the help of two or more data providers. steps: 1. Create a report with two queries. 2. ...

Answer Question  Select Best Answer

Mohit Gupta

• May 7th, 2015

Whenever we run a query in web intelligence, the data storage structure used to store the results is called microcube. This data remains hidden, untill displayed in the reports.

senthil

• Feb 11th, 2015

Its a virtual table b/w DB and report.

Answer Question  Select Best Answer

How to create hyperlinks in Infoview Charts?

Milind

• Mar 19th, 2015

First?make?sure?that?column?appears?in?other?report?so?that?you?can?link?them?Open?infoview..select?report..right?click..modify..select?column?for?hyperlink?thats?it ..

Omar Chowdhury

• Jul 18th, 2012

There is Alerter option in Webi/Webi rich Client. By using this option u can highlight as much as you want. And there is also sub-alerter under Alerter.

Answer Question  Select Best Answer

Milind

• Mar 16th, 2015

Alerters?are?basically?applied?on?column?of?the?report?upon?given? condition? Eg If?there?is a?revenue?column n?we?need?to?check?which?revenues?are?greater?than 100000 n?le...

tanej

• Mar 6th, 2015

Alerts are used to highlight the selected data based on condition.In Bo we have two kinds of alerts are there 1.Formatting alerte 2.Text based alert 1:Formatting alert is used to highlight the data...

Answer Question  Select Best Answer