adding a new column in the universe

[sap_user62]

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

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Triying to add date column and use the function week() on webintelligence.

Regards