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
)