Skip to Content
0
May 31, 2011 at 05:03 PM

adding a new column in the universe

478 Views

Hi Experts,

I have a BEx Report on which the universe is based on.

I need to have an extra column (week number) which will have numeric values, and for each additional row it will have a cumulative number.

Col1 Weeknumber col2

xxx 1 yyy

xxx1 2 yyy1

xxx2 3 yyy3

It would be a formula key figure in Bex.

But,I am not able to implement this col in Bex as the query is complicated and in Bex we have a restriction that we cant have more than 2 key figure structures.

Please let me know how this can be achieved at Universe level or Webi level.

Thanks

El