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

ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD

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

asim cholas

Dear Kavya,

OBIEE just displaying the records like that for convenience. So your branch name is actually repeating as per query and the count is correct. I dont think it is possible to acheive the count in the way you mentioned. Try BIN concept if you have limited number of branches and it will not change in future.

Thanks

Aj

AkanshAgarwal

Hi,

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

Regards,

Akansh

ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD

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

Thomas Dodds

Do this in the database ...