business-objectsinfoview

Transact-SQL in BO XI?


I recently asked the following question and received a wonderful answer: SQL: Dynamic view with column names based on column values in source table

As someone not familiar at all with BusinessObjects, is there any way to perform this in InfoView? Would I have to edit the universe?

Sorry, I know this is a terrible question... but we're in a bind.


Solution

  • This might be possible via a derived table in the universe. A derived table allows you to write a custom query to provide objects in the universe.