Business Development Executive

When we install Enterprise Server, by default if we dont specify any password then it create "Administrator" userid with no password.

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

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.

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 fact tables) then the loop can be resolved by detecting context

Detect alias: resolving fan trap

Detect context: resolving chasm trap

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 like

Year>Month>Week>Day>Hour>Minutes>Seconds.

So by changing the symbol from - to + at month aggregation level u can drill up.

We can schedule the reports through broadcast agent.

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

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.

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 looked for aggregate awareness.

year:-month,quarter,week,day are compatable but customer class is incompatable.

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.

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

year:-quarter, month, week, day are compatable objects

quarter:-year?class is incompatable and month, week, day are compatible.

3. We specify the objects in descending order.

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

Filters - are used to restrict the number of rows in the output.

Conditions - It wont reduce the Number of Rows, but you can show up data based on some validations.

For Eg: select cust_id from customer where cust_name like 'A%'

Filter is Cust_name like 'A%'.

Condition is also applied at report level.

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 building your reports...

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 Details page.

To retrieve a thumbnail, a separate page needs to be created because the code that writes an image to the screen erases any text that may have previously been there.

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.

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.

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 , user etc.

It is similar to views,it is mainly used to restrict the datas.

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