Categories
How to add serial number to analysis report in obiee 11g
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
Answers
-
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
0 -
Hi,
Add serial number as a column in the dimension table, so it group by based on the branch name.
Regards,
Akansh
0 -
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
0 -
Do this in the database ...
0