Hi all,
We are currently looking for a documentation that would contain the tables used by BO XI R2 to keep its information, I mean tables like CI_SYSTEMOBJECTS or CI_INFOOBJECTS.
For instance, we are trying to list (via the query builder) all universes available in the installation.
I remember that a few months ago, I was writing some Java code to list planned reports and their associated calendars when relevant. I didn’t find a suitable method in the SDK so I figured I should write an SQL query and have it executed, which had the expected result, but knowing what table (CI_SYSTEMOBJECTS) to query took me a day and a half searching the web. I had a hard time finding the info as a “select * from cat where table_type=‘TABLE’” is not allowed by the SQL query builder provided with BO XI R2.
Thanks for any input.
vodoomoth (BOB member since 2010-10-19)
(BOB member since 2005-01-06)