ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 21st, 2007

Did u mean that Measure objects??Ravi Kumar Garre

sar

• Apr 23rd, 2007

Most important, Backup and maintain versions

Answer Question  Select Best Answer

Nidhii

 Profile Answers by Nidhii Questions by Nidhii

• Mar 12th, 2007

Hi,I can explain why a report performance is increased when we apply a filter at the universe level rather than at the report levelWhen we apply a filter in the universe level,after the query is fired...

Latha03

 Profile Answers by Latha03 Questions by Latha03

• Jan 26th, 2007

Avoid applying filters unless and until there is a requirement from client side. Thus we can increase the performance of the reporter.

Answer Question  Select Best Answer

Muthukrishnan

• Aug 7th, 2007

To enhance the performance of the universe, we have to do the following:1) Keep universe light,2) Deselect multiple SQL statements for each measure options,3) Try to avoid outer joins,4) Use off-line ...

Tushar

• Feb 16th, 2007

I agreed with Ravi what he said except his 4th point. Short cut join privide shortest path and and gives result in shortest time but Business Objects itself suggest using shortcut join is not good practice.

Answer Question  Select Best Answer

Sarojini

• Nov 12th, 2016

We can set the security at Universe level and provide access to only specific Group to get their Region data

Abhishek

• Oct 13th, 2015

You can create a publication and schedule reports according to different location.

Answer Question  Select Best Answer

What are isolated joins? whether there will be any problem if we have isolated joins in our universe?

Sudheer Vemulapally

• Nov 23rd, 2013

An isolated join is one that has not been included in any context in your universe. Once you start using contexts in a universe, every single join must belong to at least one context. A join can belon...

Kishore

• Jul 5th, 2012

Hi ......
Isolated joins is ex: i have 15 table A is 7 table B is 7 Table taken last is missing in the table that is the Isolated Joins

Answer Question  Select Best Answer

A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins.

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 19th, 2009

An alias is identical to base table with different name. The data in alias is exactly same as original table/but the different name tricks SQL into accepting that we are using 2 different tables. ...

Suresh

• Jun 25th, 2006

Actually, What happens in the back end?(i.e) in database end, while?alias?is performed, whether it points to one table or too many table. How the performance will be in universe level.Please help me by explaining with this concept correctly, because i faced?such question by interviewer.

Answer Question  Select Best Answer

A logical grouping of objects and conditions within a universe. In general, the name of a class reflects a business concept that conveys the category or type of objects.

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 19th, 2009

A Category is grouping of certain entities [reporting objects]. A class is a category of reporting objects. A object is an instance of class or a reporting field [entity]. A class can be further divid...

harshadapj

 Profile Answers by harshadapj Questions by harshadapj

• Jul 24th, 2008

Classes are folders that serve to organize data objects according to common business need. A class can contain any type of object, including another class, (i.e. subclass). The number of classes and s...

Answer Question  Select Best Answer

A method by which Designer can decide which path to choose when more than one path is possible from one table to another in the universe.

gaurav07

 Profile Answers by gaurav07 Questions by gaurav07

• Oct 7th, 2010

Context :   defined as a group of joins shares common business purpose                    ...

rupesh.sivaguna

 Profile Answers by rupesh.sivaguna Questions by rupesh.sivaguna

• May 28th, 2009

Context:Contexts are a collection of joins which provide a valid query path for Web Intelligence to generate SQL.Regards,Siva

Answer Question  Select Best Answer

arunabala

 Profile Answers by arunabala Questions by arunabala

• Feb 26th, 2008

HiSlicing and dicing means switching the position of data in the report, two swap two variables horizontally, we can swap rows to columns or columns to rows,   very easy to do master detail reports.

raysgowda

• Feb 26th, 2007

Slice and Dice is used for extensive data analysis.

Answer Question  Select Best Answer

sekharregati

 Profile Answers by sekharregati Questions by sekharregati

• Mar 13th, 2009

Of course, we can create Universe from flat file, by using EXTERNAL STRATEGIES,By using external strategies we are going to pull the meta data from flatfile and create the universe.

chennu

• Jun 15th, 2006

Hi..... how many fact & dimensional tables (max&min)can use in projects?

Answer Question  Select Best Answer

gaurav07

 Profile Answers by gaurav07 Questions by gaurav07

• Oct 7th, 2010

Universe requirements 1) Database connections which you manually select2) Classes and objects which maps the data from tables and columns of database3) Create or automatically extract joins4) Set card...

Nayef Almiseher

• Dec 4th, 2006

Hi ,First thing you have to create connection with the DataBase which you want to work on it .Then you can take tables and put them in the Universe and starting analyzing them .Regards ,Eng. Nayef AlmiseherSaudi Fransi Bank Saudi Arabia

Answer Question  Select Best Answer

Sunil Dadheech

• Jun 2nd, 2007

Steps are as follows:1. Set up the Performance Manager(PM) Repository.2. At PM home page, Add universe available in the repository.  Important Point  to take care of is, All measur...

Nayef Almiseher

• Dec 4th, 2006

Hi ,Before started with Dashboard you have to build an Universe using BO Designer?and you have to know some of SQL statments . I think its better to get Training from BO in DashBoard because it's not easy like creating Reports using BO Reporter .Eng.Nayef Saudi Arabia

Answer Question  Select Best Answer

muni krishna reddy

• Jun 1st, 2007

BO XI archi. is completely different from its previous versions. It was completely built on crystal reports archi. In XI we don't save docs in repository. we will save them as physical data known as f...

Latha03

 Profile Answers by Latha03 Questions by Latha03

• Jan 25th, 2007

In BO 6.5 either subordinates(Designer,Reporter) or Supervisor can have more or less rights independent of their positions.In BO XIR2 the rights are inherited from the supervisor to the subordinates(Designer, Reporter).

Answer Question  Select Best Answer

BauV.QA

• Feb 12th, 2007

Hi,Open your Universe in Designer, just check "Prevent" optioin in UNIVERSE PARAMETERS>>SQL tab under CARTESIAN PRODUCTS title.Regards,Balaji V.

BauV.QA

• Feb 12th, 2007

Hi,Open your Universe using Designer and just check the "Prevent" option under 'Cartesian products' in Universe Parameters>>SQL tab.Regards,Balaji V.

Answer Question  Select Best Answer

sri_emd

 Profile Answers by sri_emd Questions by sri_emd

• Jul 29th, 2010

The measure of specifying which rows a user can retrieve based on a column of data or combination of columns is called row level security

Kumaresh Goplsamy

 Profile Answers by Kumaresh Goplsamy Questions by Kumaresh Goplsamy

• Jul 25th, 2007

HI,   It is a security implemented by the supervisor for accessing particular data from the database . This can be done by 1.login to BO supervisor .2.Go to universe tab3.select the&nbs...

Answer Question  Select Best Answer

Anil saka

 Profile Answers by Anil saka Questions by Anil saka

• Jan 22nd, 2009

Best Practices:1. keep the objects minimum2. follow the naming conventions3. use universe level conditions4. minimize joins5. aggregating the measure objects

rchrdrea

 Profile Answers by rchrdrea Questions by rchrdrea

• Aug 22nd, 2007

Since you mentioned the term 'Universe' I am under the assumption that you are referring to Business Objects.The two best practices are "keep your universe simple", and "Align y...

Answer Question  Select Best Answer

jagsganti

 Profile Answers by jagsganti Questions by jagsganti

• Apr 3rd, 2008

It has both 2 tier and 3 tier arch. Desktop and web reporting is possible with these 2 types of arch's

Anil kumar Saka

• Sep 21st, 2007

3-tier architecture

Answer Question  Select Best Answer

Anil saka

 Profile Answers by Anil saka Questions by Anil saka

• Jan 22nd, 2009

Drill is used?for multi dimensional analysis:Drill up : one level higher analysis with in the same hirerchyDrill down : one level lower analysis with in the same hirerchyDrill across : is used to analyse data across multiple hirerchies.

kamal.7923

 Profile Answers by kamal.7923 Questions by kamal.7923

• Mar 11th, 2008

Hi         Data analysis across dimensions.

Answer Question  Select Best Answer

Anil saka

 Profile Answers by Anil saka Questions by Anil saka

• Jan 22nd, 2009

If your question is to add aggregate tables in the schema then go to insert tables add the required tables in to the schema or you can add the tables by double clicking on the structure pane.

Tanveer Ahmed

 Profile Answers by Tanveer Ahmed Questions by Tanveer Ahmed

• Jul 23rd, 2008

Hi,Aggregate awareness is the ability of a universe to make use of aggregate tables in a database. These are tables that contain pre-calculated data. You can use the @Aggregate_Aware function in the S...

Answer Question  Select Best Answer

In real time environment what do we get from the client for the development of universe. provide me with an example document.

Noel Lastra

 Profile Answers by Noel Lastra Questions by Noel Lastra

• Mar 3rd, 2008

I agree, just to add after receiving the functional specifications you start with your technical specifications, then you can create your Data Model.

sreenivas27

 Profile Answers by sreenivas27 Questions by sreenivas27

• Feb 4th, 2008

Hi In real time we get functional spec so that we can create universe based on user requestsSreeni.

Answer Question  Select Best Answer