adding a new column in the universe
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.
Welcome to the sometimes frustrating world of working with dates against SAP BW via BusinessObjects!
Your best bet here is to have a financial calendar table in a database and build a new query against that. Return Week Number as a detail of date and then merge the date dimensions.