Is there a way to get all the fields in a table out of the repository? I know I can parse out the select statement and get all the fields that are used by objects, but is there a way to access fields both a) easier, and b) for fields not associated with an object?
smokybfgs (BOB member since 2004-06-18)
You can get that from your database data dictionary, even if you have to join to the universe domain in order to get the list of tables. For example, in Oracle you can query ALL_TAB_COLUMNS to get a list of columns in a table, and ALL_TABLES to get a list of tables. Join the table names to those tables from the universe domain and you’re probably on your way.
As far as I know, there is no listing of columns - used or otherwise - in the BusinessObjects repository.
Dave Rathbun 
(BOB member since 2002-06-06)