Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Row Number

Received Response
265
Views
1
Comments
User_W9SZ5
User_W9SZ5 Rank 1 - Community Starter
edited Aug 13, 2024 6:06PM in Oracle Analytics Cloud and Server

Hi!

I have a OBIEE (11.1.1.7) analysis and I like to add a row number column. I use rsum(1) or rcount(1) for the row numeration. When I re-sort the rows (on an arbitrary column ) the row numbering does not change.

Does anyone know how to do that?

Best regards

Sven

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    I don't see where is the issue ...

    Row numbering is done at the query level, a visual reordering in the front end is not supposed to change that.

    If you make a SQL query with a row number column, export to Excel and sort by another column of your data set does the row numbering column change? Not really ...

    So it works as expected.

    What's the purpose of a totally data unrelated row numbering?

    PS: you can of course remove the ability to change sorting on the report and so the problem can't exist ...