What is the maximum possible number of tables in the repository

I am working on the Business Objects 6.5.1 Repository which is in Oracle 9i database. I need your help regarding this.
Firstly, What is the maximum possible number of tables in the repository?
Secondly, Is it possible to generate a report that describes the user's access rights in details (Like a user has access to Business Objects, BQY, Webintelligence, supervisor or designer . - Thank you

vsurya
Profile Answers by vsurya Questions by vsurya
Jun 11th, 2008
3
2761

Questions by vsurya

Business Objects

Answer

Showing Answers 1 - 3 of 3 Answers

sandeepkumarc
Profile Answers by sandeepkumarc

Jun 13th, 2008

There are only three default domains in the repository, security, universe and documentation domain, there are 57 tables in it. we can create additional documentation and universe domain( can't create security domain), these additional domains can contain any number of tables. we can say the default repository tables are 57 and, we can have more than 57 tables.

Thanks
Rex

sreenivas27
Profile Answers by sreenivas27

Jun 18th, 2008

Hi

In BusinessObjects 6.5 Repository 57 tables

Security Domain tables 25

1. OBJ_M_ACTOR
2. OBJ_M_USRATTR
3. OBJ_M_DOCCST
4. OBJ_M_GENPAR
5. OBJ_M_MAGICID
6. OBJ_M_RESLINK
7. OBJ_M_UNIVCST
8. OBJ_M_UNIVSLC
9. OBJ_M_ACTORDOC
10. OBJ_M_DOCUMENTS
11. OBJ_M_UNIVERSES
12. OBJ_M_ACTORLINK
13. OBJ_M_TIMESTAMP
14.OBJ_M_UNIVDBCST
15.OBJ_M_CONNECTION
16.DS_USER_LIST
17.OBJ_M_REPOSITORY
18.OBJ_M_CATEG
19.OBJ_M_CONNECTDATA
20.OBJ_M_OBJSLICE
21.OBJ_M_RESERVATION
22.DS_PENDING_JOB
23.OBJ_M_DOCCATEG
24.OBJ_M_DOCAT
25.OBJ_M_DOCATVAR

Document Domain have 1 tables

1.OBJ_X_DOCUMENTS

Universe Domain have 31 tables

1. UNV_JOIN
2. UNV_AUDIT
3. UNV_CLASS
4. UNV_RELATIONS
5. UNV_DIM_OBJ
6. UNV_OBJECT
7. UNV_OBJ_TAB
8. UNV_TAB_OBJ
9. UNV_CONTEXT
10. UNV_CTX_JOIN
11. UNV_TAB_PROP
12. UNV_JOIN_DATA
13. UNV_PROP_DATA
14. UNV_PROPERTY
15. UNV_UNIVERSE
16. UNV_CLASS_DATA
17. UNV_DIMENSION
18. UNV_PROP_TAB
19. UNV_OBJECT_DATA
20. UNV_CONTEXT_DATA
21. UNV_JOINCONTENT
22. UNV_UNIVERSE_DATA
23. UNV_OBJCONTENT
24. UNV_TABLE
25. UNV_TABLE_DATA
26. UNV_OBJECT_KEY
27. UNV_JOIN_OBJECT
28. UNV_COLUMNS
29. UNV_COLUMN_DATA
30. UNV_OBJ_COLUMN
31. UNV_X_UNIVERSES

http://businessobjectsforum.blogspot.com/2008/04/repository.html

Thanks

sreenivas27
Profile Answers by sreenivas27

Jun 18th, 2008

Hi All,

Repository have 57 tables.

1. security domain have 25 tables.
2. Document domain have 1 table
3. Universe Domain have 31 tables.

it possible create audit reports what ever you want.

Thanks.