How to create row id for records in webi report?

[Former Member]

I have generated a webi report from 3 derived tables in universe. But now I need to insert unique row id for all the records. Please suggest.

Many Thanks

PK

[Former Member · Accepted solution]

Could you please elaborate in detail please?

Regards

Niraj

[Former Member · Accepted solution]

Yes Neeraj, I have got a webi which is generated from 3 derived tables in universe. Now I have to insert a row id for all the rows returned in in webi.I hope it explains it a bit better

[Former Member · Accepted solution]

Please try

=RowIndex()

and see if it matches your requirement.

Regards

Niraj

[Former Member · Accepted solution]

Thanks It works but it start with 0, I want the records from 1....

Thanks Niraj

[Former Member · Accepted solution]

I got rid off 0 by using =RowIndex()+1

Thanks Neeraj for helping me out

[Former Member · Accepted solution]

Glad I was able to help!!

There is another thing that may interest you to know which is LineNumber() in this you have to substract 1 from it to get the exact result.

Hope this also helps for your future reference.

Please close the thread if this answered your question.

Regards

Niraj

[Former Member · Accepted solution]

Yes Indeed Thanks Mate

[amitrathi239]

use =r=RowIndex()+1

[Former Member]

Yes Mate this works..:) Thanks