Business Objects - What is the maximum possible number of tables in the repository

GeekInterview.com > Interview Questions > Data Warehousing > Business Objects

Go To First | Previous Question | Next Question

Business Objects | Question 232 of 240

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

Total Answers and Comments: 3

Last Update: June 18, 2008 Asked by: vsurya

Sponsored Links

Best Rated Answer

—

Submitted by: sreenivas27

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

Above answer was rated as good by the following members:
nikhilbaldota

June 13, 2008 03:43:51

sandeepkumarc

Member Since: March 2008 Contribution: 5

RE: What is the maximum possible number of tables in the repository

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

June 18, 2008 08:36:14

sreenivas27

Member Since: November 2007 Contribution: 15

RE: What is the maximum possible number of tables in the repository

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

June 18, 2008 08:45:06

sreenivas27

Member Since: November 2007 Contribution: 15

RE: What is the maximum possible number of tables in the repository

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.

Is this answer useful? Yes | No

Go To Top