Skip to Content
avatar image
Former Member

Creating a filter in webi report Or in Universe!

Hi all,

using BO XI R3. In my report i need to create a filter for date object,

Actual scenario is, for every Product_ID need to show recent 8 quarters of data if available.  Almost every Product_ID is having more than 8 quarters of data.

How to create this kind of filter, can we create in reporting side, or need to create in Universe side.

Thanks,

Praveen.

My report should be like below table.

Product ID Available Date/Quarter
1235 2010-Q1 1235 2010-Q2 1235 2010-Q3 1235 2010-Q4 1235 2011-Q1 1235 2011-Q2 1235 2012-Q3 1235 2012-Q4
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Feb 18, 2013 at 02:28 PM

    If this is a business logic it is better to create the filter at Universe level so that you can reuse it across all documents

    thanks

    Simone

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 18, 2013 at 05:42 PM

    Hi,

    Better to create filter at universe level, which will improve the performance as well as reuse it.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 18, 2013 at 05:56 AM

    Hello Praveen ,

    you can use ranking .

    Ranking can be applied at a:

    • Database level - by clicking the Add a database ranking button in the Query panel (this

    feature is database specific).

    • Report level - by clicking the Add/Remove ranking button in the Web Intelligence Rich

    Client window.

    Applying ranking to data

    To apply ranking to data within a report, select the row or column to which you would like to

    apply ranking and then click the Apply/Remove Ranking button to open the Rank dialog box.

    To apply ranking

    1. Select the block that you want to rank.

    2. Click Apply/Remove Ranking.

    The Rank dialog box appears.

    3.Click Top and select the number of records if you want to rank the highest records in the

    block.

    138 Web Intelligence Report Design—Learner’s Guide

    4. Click Bottom and select the number of records if you want to rank the lowest records in the

    block.

    5. Select the measure on which the ranking is based in the Based on list.

    6. Click Ranked By and select the dimension on which the ranking is based if you want to

    rank by a particular dimension rather than by all dimensions in the block.

    7. Select the rank calculation mode in the Calculation mode list.

    The available calculation modes include:

    • Count: Counts the records and displays the first/last n records in the count, according

    to the Ranking Selection.

    • Percentage: Counts the records and returns the ones corresponding to the top/bottom

    percent of the total records specified in the Ranking Selection. It is not a real percentage,

    for example, if you want 10% and there are a total of 100 rows, you would receive 10

    rows.

    • Cumulative Sum: Adds up

    the values and displays the top/bottom n records required

    to reach the sum specified in the Ranking Selection.

    • Cumulative Percentage: Counts the total value of all the records and displays the

    top/bottom n records required to arrive at the percent of the total specified in the Ranking

    Selection.

    8. Click OK.

    9. Save the document.

    You can create ranking in data base side also..

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Satendra,

            i need to display recent 8 quarters, so how can i apply ranking on universe side??? is it possible?

  • avatar image
    Former Member
    Feb 18, 2013 at 08:53 PM

    Yes, its a business logic.  Need to create it in universe side, can some one help with logic.

    Thanks,

    Praveen.

    Add comment
    10|10000 characters needed characters exceeded