sreenivas27

 Profile Answers by sreenivas27 Questions by sreenivas27

• Jul 1st, 2008

Condition and filters: 1.we can put conditions designer levels as well as report level also. 2. We can restrict some data in Universe level so that you want data we can restrict Universe level. ...

kiran.c

• Oct 16th, 2007

Condition is reusable, but not the filterWe can create conditions at designer level. where as filters are at report level.

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

What is #multivalue and #syntax error in Business Objects

avinash kumar

• Feb 10th, 2013

I need full example of #multivalue error............how the errors r coming..............n how to solve that errors

ag_SRIDHAR_SUBRAMANI

 Profile Answers by ag_SRIDHAR_SUBRAMANI Questions by ag_SRIDHAR_SUBRAMANI

• Sep 24th, 2008

Multivalue error will occur when more than one row comes for one cell. to avoid this issue you have to use Min(), or Max() as per your requirement.Syntax error will occur when available improper formula used in the report.  so you have to correct it first.

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

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

Arjit Dwivedi

• Aug 18th, 2011

By checking the integrity and the execution time of our reports and universe design

goutham438

 Profile Answers by goutham438 Questions by goutham438

• Jul 31st, 2011

Universe will tested using check integrity

Answer Question  Select Best Answer

kishoresai

 Profile Answers by kishoresai Questions by kishoresai

• Mar 7th, 2015

3types like 1 drill, drill down ,drill by.. in web i reprots

Milind

• Mar 6th, 2015

Any exact?answer. I?think?it?depends?on?depth?of?levels?

Answer Question  Select Best Answer

Aditya

• Dec 7th, 2014

Section is a master and detail functionality in Bo. It slice and dice the report. It divides the report into separate blocks.for example we have year, emp name, salary and if we apply section on year....

shashank

• Dec 13th, 2012

Section provide the analysis in sub group vise, suppose we have thee column country, region, revenue, if we apply section on country the table structure change (table structure not change in break) an...

Answer Question  Select Best Answer

nanis38

 Profile Answers by nanis38 Questions by nanis38

• Jun 15th, 2011

Ranking has priority than sorting .we apply ranking on dimension based on the measure like if you want to display top 100 sales revenue generated by a product or bottom 100 sales generated by a product.sorting is not based on measure or anything it will sort in ascending ,descending or custom order

sandeepkumarc

 Profile Answers by sandeepkumarc Questions by sandeepkumarc

• Jun 13th, 2008

If we think logically what is the purpose of sorting, if its been ranked already, Ranking will sort the rows from higher to lowest order(Descending order).  Does it make sense :)ThanksRex

Answer Question  Select Best Answer

Akhil Rawat

• Nov 12th, 2014

Yes, we can over write the query after creating a report from the universe. There is an option in Desktop Intelligence and Web Intelligence of Business Objects where we can make the changes in the SQL...

chandra

• Mar 28th, 2014

Yes we can override SQL Query if option "Allow other users edit the Query" is enable in the Edit Query Properties.

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

siva

• Nov 30th, 2014

Yes, we can do this. This is available in all version. In 4.0 version it is called as New Rule.

Akhil Rawat

• Nov 12th, 2014

Yes, with the help of Alerter functionality in Web Intelligence we can highlight or alert any column using the desired or required formulas.

Answer Question  Select Best Answer

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 28th, 2012

When Query fired very first time it hits directly against the Database and then its fetch all data and store into one MICROCUBE. MicroCube basically a temp place holder where all the Possible dimensio...

suresh

• Feb 29th, 2012

Micro cube is the one which stores the results of the query. each data provider stores it results as/ in the micro cube when we create the query in the query panel. you can access the micro cube in ...

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

Kapil

• Jul 27th, 2011

In BO also we can generate report from multiple data sources by merging two data providers at report level, however with universe we can connect to only one database unless they are not linked universes.

reddy.devender9

 Profile Answers by reddy.devender9 Questions by reddy.devender9

• Dec 2nd, 2009

In Cognos, we can generate a single report from multiple data sources (homogeneous or heterogenous).  In BO, we can generate report from single datasource (multiple connections not allowed).

Answer Question  Select Best Answer

dileepv

 Profile Answers by dileepv Questions by dileepv

• Jan 6th, 2010

Yes, we can we need to convert the deski (full client) to webi (thin client) using report conversion tool, but not vice-versa (webi to deski)

Revansing

 Profile Answers by Revansing Questions by Revansing

• Nov 25th, 2008

Straight forward answer is NO!!!!!If you needs to view the reports any how would have use report conversion tool to convert it into .wid and? vice versa but again it has limitations like the function...

Answer Question  Select Best Answer

sreenivas27

 Profile Answers by sreenivas27 Questions by sreenivas27

• Jul 1st, 2008

HiFirst you have check your report format i.e filters,conditons, graphics, sorts, ranks....mainly these you have check so that you can decided which option u can use better....so that you can easily tune your query performance.Regards,Sreenivas.

abdul123

 Profile Answers by abdul123 Questions by abdul123

• May 2nd, 2008

Avoid too much of Report level formulae.

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

shashank

• Dec 13th, 2012

We have to go for 80-20 rule. It means understanding the user requirement first, database, connection secured, table map, join, cardinality, loop, trap, if need then for performance issues we have to create (aggregate, aware,index,derived table,short cut join) test universe

Vyankatesh Valakate

• Oct 20th, 2012

Universe is used for Importing tables, Creating classes, Creating objects, Creating joins, Loops, Fan trap, Chasm trap, Creation of hierarchies, Dimensions, Filters, Breaks, Sections.

Answer Question  Select Best Answer

shashank chakraborty

• Dec 13th, 2012

We can link different data providers in a single report by merged dimension.

hari

• Nov 7th, 2012

Use the merged dimensions to link the data providers. It will give you a dialog for the selection of the dimensions in both data providers. select the dimensions which are alike and merge.

Answer Question  Select Best Answer