How to add serial number to analysis report in obiee 11g

Question

Hi

I have tried to add serial number column with rcount(1) formula  in analytics report . I am getting output as follwing below

here row count is incremented by 1

But i want to get output as follwing below. is it possible ???. Please help me how to do??.

Thanks in advance,

A.kavya

Thomas Dodds · Answer

Do this in the database ...

ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD · Answer

Hi,

Thank you very much for giving reply.

As you said, if i use bin for groping the values , it is ok for limited number of rows. But if i wil add 10k rows to that table in future. At that situation no use of bin . I want to do automatically serial number group by based on the branch name. I have tried. I did nt get o/p. Please give other alternative solution for this

Thanks in advance

AkanshAgarwal · Answer

Hi,

Add serial number as a column in the dimension table, so it group by based on the branch name.

Regards,

Akansh