Scribd Logo
Upload

Welcome to Scribd!

  • 17 views

    5 BOs

    Uploaded by

    Abhilasha Modekar
    1. There are a few ways to delete duplicate rows in a Business Objects report. You can select the "Delete Duplicate Records" radio button in the Query Options window to remove duplicates from the report. 2. You can also prevent duplicate rows from being retrieved by unselecting the "Retrieve Duplicate Rows" option in the query properties. 3. Aggregate awareness allows Business Objects queries to optimize performance by running against aggregate tables in the database instead of base tables when conditions are met. This utilizes pre-aggregated data to speed up queries.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    5 BOs

    Uploaded by

    Abhilasha Modekar
    17 views2 pages
    1. There are a few ways to delete duplicate rows in a Business Objects report. You can select the "Delete Duplicate Records" radio button in the Query Options window to remove duplicates from the report. 2. You can also prevent duplicate rows from being retrieved by unselecting the "Retrieve Duplicate Rows" option in the query properties. 3. Aggregate awareness allows Business Objects queries to optimize performance by running against aggregate tables in the database instead of base tables when conditions are met. This utilizes pre-aggregated data to speed up queries.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. There are a few ways to delete duplicate rows in a Business Objects report. You can select the "Delete Duplicate Records" radio button in the Query Options window to remove duplicates from the report. 2. You can also prevent duplicate rows from being retrieved by unselecting the "Retrieve Duplicate Rows" option in the query properties. 3. Aggregate awareness allows Business Objects queries to optimize performance by running against aggregate tables in the database instead of base tables when conditions are met. This utilizes pre-aggregated data to speed up queries.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    17 views2 pages

    5 BOs

    Uploaded by

    Abhilasha Modekar
    1. There are a few ways to delete duplicate rows in a Business Objects report. You can select the "Delete Duplicate Records" radio button in the Query Options window to remove duplicates from the report. 2. You can also prevent duplicate rows from being retrieved by unselecting the "Retrieve Duplicate Rows" option in the query properties. 3. Aggregate awareness allows Business Objects queries to optimize performance by running against aggregate tables in the database instead of base tables when conditions are met. This utilizes pre-aggregated data to speed up queries.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    Can you please tell me how to delete a duplicate rows in a Report.

    Whether it is
    posible.
    1. u can delete the duplicate rows in u r report .....in the query panel ...classees and object window below option
    button is ther click that one query option window open from thet delete the duplicate record radio button ther u
    can select that one... click ok... duplicate rows donot appear in u r report...byeAnil kumar.Devireddy
    2. You can stop the retrivel of duplicate rows by selecting the optin properties in infoview.In the query panel
    when u start to drag and drop the objects there another tab knoen as 'PROPERTIES' u can unselect RETRIVEL
    DUPLICATE ROWS
    we create X reports using template.can we change the template?
    You can not modify the templete. Modify old report and create a new templete based on the report and use it.

    yes we can create new template for report and also we can change the query also .
    Name some of the business objects dashboard analytics?
    some of the most commonly used analytics are Alerts,interactive metric trends,maps,metric trees,pareto charts,
    gauges such as speedo meters & traffic lights,viewers.

    can anyone specify the address from where we can get the information about
    dashboard in business objects?
    Yes Business Object XI R2 quick tour is there which shows the Dashboard and its functionality
    Could any of u say the answer for the following question which i faced in the interview
    the question is "When will training occur in BO?"
    if the training that u were talking is for users, then usually  it happens once we are done with development.

    what are the requirements for cube creation in business objects XI?
    You should have a  "Universe" with proper star or snowflak schema(Dimension and Fact) .Call this Universe in
    the "infoview"  to create a web intelligent ananlysis(OLAP) report. 
    in a report can we hide an particular object ?
    yes we can show/hide a perticular object in a table by using the pivot tab of the format table dialog box
    what is drill filter and it's usage ? How many types of filters are there ?
    1. I dont think there is any number of type in drill through filter, drill through filter is used to fech the
    particular data from the report or other report by click browse while in the drill through process.
    2. 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

    3. drill filters acts as query conditions when you bring new data from from database
    we can not say there are different types of drill filters,because we apply filters through scope os analysis and
    set the apply drill filters option by
    tools >options>drill tab
    there are different drill modes like drill up,drill down,drill through

    What is a Data Cube ? What is its use ?


    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. 
    Data cube is the representation of data along every possible dimension included in the query. data cubes are
    processing units composed of fact and dimensions.

    What is aggregate awareness and how can we use it?


    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 also select the compatable as well as incompatible objects through aggregate  navigation so that it improves
    the performance of the system in generating the report.
    3. You can use features in Designer to allow you to define the Select statement for an
    object to run a query against aggregate tables in the database  instead of the base
    tables. You can set conditions so that a query will be run against aggregate tables
    when it optimizes the query, and if not, then the query will be run against the base
    tables. This ability of an object to use aggregate tables to optimize a query is called
    aggregate awareness

    You might also like