Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

adding a new column in the universe

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 replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question