1.XIR3 can use Excel document as a data provider which was not possible in XIR2. 2.We can open XIR2 universes using XIR3 Designer but XIR3 universe cannot be opened using earlier versions of designer. Read More

Aggregate awareness function is used to aggregate the values present in the classes in decending order. for instance we have year,quarter,month,week tables then we sum the year,sum(quarter),sum(month),sum(week) in decending order respectively. we... Read More

I have found some differences b/w BO and XI and only the last is specific to XIR2 Difference between BO and XI BO uses classic BO Architecture and XI uses crystal classic Architecture BO uses 57 tables for BO repo and 8 tables for auditor... Read More

By doing integrity check we can test universe & By coping report query and run in backend(oracle, sql server...) we can test the data by comparing both. Read More

You can do Load testing for Webi Reports using Load runner tool. 1) Install loadrunner in your system. ( to use loadrunner you need admin rights). 2) Generate loadrunner scripts. 3) Use controller(which is present in loadrunner) to get the... Read More

Slice and dice means change the postion of the data like move the data from rows to columns drill mode means allow u to analyze the data in different angles and different levels of details.. in drill mode different types of analysis’s are... Read More

Cross tab report is like at the intersection of 2 dimensions measure is displayed.like if we have two dimensions year and product and a measure revenu,revenue is displayed at the intersection of year and product. Read More

In infoview you can create a webi documents i.e wid documents, you can open, schedule, save it as an excel or pdf or business objects document(.rep). Webi is a part of Infoview Read More

We can select or choose compatable n incompatable objects through aggregator navigation in the designer. with this method the performance increases tremendously. instead of checking for each n every object only the compatable objects are only... Read More

ZABO is zero administrator businessobjects , which will be installed on your local m/c when any full client report in opened/edited from infoview . For this you don’t require any BO mainkey , key will be installed from BO server.Webi is also... Read More

1. In order to solve fan trap in busines objects we either create alias table or aggregate awareness function 2. Through aggregate navigation we can also select the compatable as well as incompatable objects Ex:-year, quarter, month, week, day ... Read More

Three types of drill is in BO.1.drill up,2.drill down,3.drill thro’. drill up means second->minutes->hour->->day drill down means region-> country->state->district drill thro’--wht ever u want that element Read More

we should use Detect Aliases and Detect Contexts to formally identify and resolve loops. i.e.if a loop contains only one lookup table then the loop can be resolved by detecting the alias if a loop is having 2 or more fact tables(multiple... Read More

In the central mangement consol one can test the report. jsut go to the link http://ipadress:port no/businessobjects/enterprise11/admin/en/admin.cwr .every thing can chk from the bo. Read More

Report Template is a specimen for your future reports. You create a report from scratch, say make it Master-Detail Report with charts, put your company logo, add some default colors(something like same colors your company uses for its documents,... Read More

By default one class having one hierarchy ie called report hierarchy.Custom hierarchy we can create in designer according our req. Read More

Syntax @Prompt (’ message’, [’type’], [lov], [MONO|MULTI], [FREE|CONSTRAINED]) where message is the text of a message within single quotes. type can be one of the following: ’A’ for alphanumeric, ’N&rsquo... Read More

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 the query. Rank values are not skipped in the event... Read More

THOUGH my biggest achievement is still to be achieved ,and that would be if I am able to give all the happiness to my family along with a reputed professional position. Read More

As far as i know we schedule the reports through broadcast agent. Read More

In BO Designer, from File Menu -> Parameters -> Links tab on Universe Parameters box. Click Add link to link the universe. The linking universe should be exported and imported from repository before linking. Read More

When you are defining Aggregate tables in Universe design, you need to create hirarchies for aggregated objects, for that you need to make the relative objects incompatible (the objects which are of lower level of aggregation -- not of hirarchy). If... Read More

Repository means set of database tables, Business object store security information e.g user, group, access permission, user type etc. , universe information e.g. objects, classes, table name, column name, relation ship etc.and document... Read More

Object store is nothing but the container of object which is created after rpt file run once. Read More

We can schedule the reports through broadcast agent. Read More

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 Bursting. You can send reports to BCA for... Read More

- make sure to have the right context - apply right indexes on the tables Read More

You can schedule any report using Business Objects (reporter) .1) Open report in BO2) Select option " File->Send To- BCA"3) Select the BCA name to which report has to be scheduled4) Set other options for report scheduling like time , any macro ,... Read More

SUPERVISOR offers various types of users of Business Objects products. The user profile determines by default what products a user can use. User profiles can be customized to reflect the needs of the users. ? User (all products but DESIGNER and... Read More

Start BO, Select "Others" on Data Providers wizard page, from drop down menu, select "ersonal data files", specify file location & check the box "First Row contains Column names" this will help you in creating Objects. click Ok. Start... Read More

Nested prompts are called "Cascading Prompts" in BusinessObjects environment. try searching for this keyword. to create cascading prompts, you need to edit the properties of an object & impose another prompt as a condition. Read More

Conditions: these retrievals the data based on the condition (universe level)Filter: it brings the data and filter; performance will be slow (report level) Read More

The level of join between two universe with a matching coloumn Read More

when we export a universe first time,a unique identifier is allocated to the universe and this identifier is updated on the local version of the universe in the universe domain If we export the universe to a diff,domain and now the universe has an... Read More

BusinessObjects Enterprise lets you preview a report using thumbnails. You can request the server to take a snapshot of the first page of the report and return it to the browser as an image file. This image can then be displayed as part of the Report... Read More

Cartesian product is getting incorrect results. for instance if we have a cham trap or a fan trap n we din’t solve them after checking the integrity also we get duplicate results of the same record ie nothing but cartesian product. ex:- we... Read More

Tabular reports is a 2D format and Cross tab reports is a 3D format. Most of the operational/formated reports will be created in tabular form and most of the analytical reports are created in the cross tab report form (Product VS Year VS Sales... Read More

Question : How to filter repeatative values in the report to get distinct values. Example: In any database we can use distinct command But My Report source is flatfile.Therfore,I cann’t manipulate source system. Is there any... Read More

If you have two tables with many to many relation ship, take the keys of those tables and form a 1-1 relationship table. then you can connect both the existing tables to the newly formed table using the key. Read More

The Prompts will appear in the alphabetical order. To make them appear in the order of our requirement, need to prefix a numerical with the prompt We can do this in two ways... 1.Add the number in the first parameter of the... Read More

Actually FAN TRAP is a problem that occurs in Universe Level. Loop occurs while we design the universe. Two Types of Loop Problem: 1) FANTRAP PROBLEM solved by ALIAS METHOD: Definition: Two One-to-many table link eachother is in turn linked... Read More

The difference between union and group is as follows: take two tables t1 and t2. in t1 we have columnss like a,b,c,d. and t2 has a,d,e,f. so union means t1 union t2 i.e getting result from both tables i.e a,b,c,d,e.,f where as group performs on... Read More

Once you have your report generated, right click in the left window (your variables) click on "New Data Provider" follow the wizard. & you are done. If trying to use diff. data provider for different reports, after creating 1 report, right... Read More

Alerts are used to alert some part of the data if any change occurs . select the part of the data in the report where u want to keep alerts n just click on alerts in the tool bar which is present in the third line from menu bar besides rank then... Read More

Database connections, key column, joins and check for loopif you need mesures, metrics, There are 4 steps: 1.Define the connection. 2.Create the classes and objects. 3.Give the joins and resolve loops. 4.Generate the universe. Read More

Yes,#MULTIVALUE error is there in BO.It’s common when u r trying to use multi valued multiple objects in section. Go through error documentation for further details... Read More

Create objects in your universe with date functions. Let’s say your DB is Oracle. In your "Select" statement of new object called year, try to_char(INVOICE_DATE, ’YYYY’) similarly for month create object called month & repeat... Read More

We can create any number of universe, but at a time we can open only one universe, generally number of universes should be equal to number of sub-domains. Read More

No there are only 3 repository domains for BO 6.5 i.e universe, security and document. Read More

Think this should be in the Reporter Forum but, a local filter would apply to just a single block (table, cross tab or chart) within your report. a global filter would apply to all blocks in your report, so if you had many tables the filter would... Read More

Here alert means to highlighted data in a particular report.in every report we can apply alerts situtation like, sales revenue per city wise.here city field we can apply alert,condition like sales revenue >=50,000 Read More

it is similar to views,it is mainly used to restrict the datas Read More

Your objectives for this project will be your Report Requirements. whatever the requirements are baselined, you will develop the universes & create simple, complex reports. Requirements can be : Standard sales reports -- Location wise,... Read More

To create a report using notpad (.txt files) : 1.open BusinessObjects --> new report 2. select data provider as Others instead of universe, from "Others" drop down list, select "Personal Data Files", File selection box appears, specify the... Read More

In data Warehouse when u change + symbol to - , u would c all the aggregation level in that + this is called rolling down. So if u again click over that - it would again compressed back to +. This is call drill up. your Aggregation levels woudl b... Read More

Question : Product date sales p1 20/Jan/1999 100 p1 20/Feb/1999 200 p1 20/apl/1999 100 p1 20/DEC/1999 50 p1 20/Jan/2000 100 p1 20/mar/2000 500 now i want query like product ,sum of actual year ,sum of business year p1 450 750 ... Read More

Data cube will present in BO tool. Data cube is used for storing the data values which we are using in the documents. We can clear the data cube by using purge command. Data provider is used to retrived the datas from data cube to documents. Read More

1) we can createedit Universe in the full client but not in WebI 2)WebI has comparatively less functions to use than in Full client 3) In Full Client we can write macrosaddins but i am not sure whether we can do the same in WebI or not. Read More

Yes both can exist on the same tier because Datamart is a subset of data warehouse and it supports a particular region, business unit or business function. The data in the Datamart and DWH is Denormalized and optimized for OLAP systems Read More

There is no such tool available yet for comparing Universes/Reports. The best way to compare Universes is to do check intergity constraints & the compare the outputs. Read More

The time interval will be fixed for sending the report If you are generating or not a default report will be sent regularly, to stop sending you have to condact your admin Read More

i know one approach ..we have to creeate these in Univrse design level.. this makes some process.. that means..we have create objects..ans in conditional we to create prompts.. Read More

No we can’t apply rank and sort at a time on one object in one single report.If we try to apply , BO asks if you want to over write the previous condition. Read More

Bo XI R2 Read More

1. Motivation factor 2. Team leader quality 3. Risk handler Read More

We can install BO in sun solaris server. Install the server components like Configuration tool & Administration console and configure the solaris machine as Primary node. Read More

We can select either tables or procedures or views as our data to generate our reports.In the designer in bo’s we can select tab "insert" n select the particular data source for generating the report through mouse click. Read More