Skip to Content
0
Former Member
Jul 04, 2008 at 01:25 PM

Filtering a database ranked report

30 Views

Hi

I'm trying to do a Top 10 type report and ether Im hitting a bug or I'm missing something.

Heres the steps:

1) New Webi Report

2) Add a field (say name) and a measure (count of lives)

3) Add a database ranking using those two fields as well

4) Drop name into the Ranking query box (the light grey one) and filter for something

You can see in the SQL viewer it does not take the filter into account..

Using Webi XI2

Thanks in advance

des

The SQL you get is:

SELECT

ENTITY_FACT.NAME,

ENTITY_FACT.ID

FROM

ENTITY_FACT

WHERE

ENTITY_FACT.NAME In

(

SELECT

View__1.Column__1

FROM

(

SELECT

ENTITY_FACT.NAME AS Column__1,

RANK() OVER( ORDER BY ENTITY_FACT.ID DESC ) AS Rk__1

FROM

ENTITY_FACT

) View__1

WHERE View__1.Rk__1 <= 10

)