BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Repository tables in XI
2 members found this topic helpful
Goto page 1, 2, 3  Next
 
Search this topic... | Search XI Server Discussion... | Search Box
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Author Message
dinesh2005
Principal Member
Principal Member



Joined: 12 Sep 2005

Posts: 178


flag
PostPosted: Thu Nov 03, 2005 11:08 pm 
Post subject: Repository tables in XI

Hi All,

I have installed BO XI using MySql as my repository database. How can i find what are the repository tables present. Or is there any standard set of repository tables (like CI_INFOOBJECTS,...)

TIA
dinesh
Back to top
bopro
Senior Member
Senior Member



Joined: 31 Oct 2005

Posts: 56
Location: chicago


flag
PostPosted: Fri Nov 04, 2005 12:49 pm 
Post subject: Re: Repository tables in XI

You can connect to your CMS database and view the tables
We also have our CMS database residing on the SQL Server and the table can be viewed.

_________________
Best in Business Intelligence
Back to top
substring
Forum Addict
Forum Addict



Joined: 16 Jan 2004
ASUG Icon
Posts: 4119
Location: Richardson Texas


flag
PostPosted: Fri Nov 04, 2005 4:01 pm 
Post subject: Re: Repository tables in XI

Quote:
I have installed BO XI using MySql as my repository database. How can i find what are the repository tables present. Or is there any standard set of repository tables (like CI_INFOOBJECTS,...)
You can view the database tables, but keep in mind that it is no longer as easily editable as the legacy BO repository. Furthermore, all report objects are now stored in the FRS and merely pointers in the system database.
_________________
If you are using BusinessObjects, you should join ASUG.
Follow me on Twitter: @substring
Back to top
dinesh2005
Principal Member
Principal Member



Joined: 12 Sep 2005

Posts: 178


flag
PostPosted: Mon Nov 07, 2005 1:28 am 
Post subject: Re: Repository tables in XI

Thanks for the reply.

I am able to connect to the CMS database. But i dont see any tables like CI_INFOOBJECTS . But when i use Query Builder provided by BO i am able to run query against the table.

Please help.

Thanks & regards
Dinesh
Back to top
substring
Forum Addict
Forum Addict



Joined: 16 Jan 2004
ASUG Icon
Posts: 4119
Location: Richardson Texas


flag
PostPosted: Mon Nov 07, 2005 10:11 pm 
Post subject: Re: Repository tables in XI

Some of the system tables are hidden and/or encrypted. They don't want people to mess around with them. And frankly, why do you have to query the table?
_________________
If you are using BusinessObjects, you should join ASUG.
Follow me on Twitter: @substring
Back to top
dinesh2005
Principal Member
Principal Member



Joined: 12 Sep 2005

Posts: 178


flag
PostPosted: Mon Nov 07, 2005 11:46 pm 
Post subject: Re: Repository tables in XI

I was trying to find the CUID and was trying to relate all the report names with the file names. i was able to find it only from the CI_INFOOBJECTS tables. So outof curiosity want to know if there are tables like this which is not shown directly

dinesh
Back to top
bopro
Senior Member
Senior Member



Joined: 31 Oct 2005

Posts: 56
Location: chicago


flag
PostPosted: Wed Nov 09, 2005 12:53 pm 
Post subject: Re: Repository tables in XI

Yes, _InfoObjects is one of the tables in the CMS databasein addition to 5 other tables.
_________________
Best in Business Intelligence
Back to top
dinesh2005
Principal Member
Principal Member



Joined: 12 Sep 2005

Posts: 178


flag
PostPosted: Wed Nov 09, 2005 4:40 pm 
Post subject: Re: Repository tables in XI

Hi Bopro,

You have anyidea about the other 5 tables. If so please let us know.

Thanks & Regards
dinesh
Back to top
bopro
Senior Member
Senior Member



Joined: 31 Oct 2005

Posts: 56
Location: chicago


flag
PostPosted: Thu Nov 10, 2005 9:35 am 
Post subject: Re: Repository tables in XI

The other tables(4 not 5) are


_ALAISES
_VERSIONINFO
_RELATIONS
_IDNUMBERS

_________________
Best in Business Intelligence
Back to top
bopro
Senior Member
Senior Member



Joined: 31 Oct 2005

Posts: 56
Location: chicago


flag
PostPosted: Thu Nov 10, 2005 9:40 am 
Post subject: Re: Repository tables in XI

Correction,

The first table was _ALIASES

_________________
Best in Business Intelligence
Back to top
venira
Principal Member
Principal Member



Joined: 07 Dec 2004

Posts: 362
Location: Tokyo


flag
PostPosted: Tue Feb 21, 2006 4:03 am 
Post subject: Re: Repository tables in XI

Hi,
can anyone tell me whether it is possible to get the universe access log from the repository tables. i mean like which user logged in, what time, which universe he accessed etc. i would be happy if any one can tell me the table name.

venira
Back to top
snagoski
Principal Member
Principal Member



Joined: 13 Dec 2004

Posts: 109
Location: Vancouver, BC, Canada


flag
PostPosted: Tue Feb 21, 2006 1:26 pm 
Post subject: Re: Repository tables in XI

Object usage & access history is only stored in the Auditing database, which is available when Auditor is enabled as an Add-on to BOE Professional, or it is included with BOE Premium. The CMS repository has an "as-of" representation of all managed objects in the repository, and no "history" excepting the list of scheduled instances of reports currently managed.

Note: direct Querying of the CMS database through reporting tools, depending on the tool used, the security account permissions, and the RDBMS underneath it, *can* cause performance, stability, and reliability issues with the CMS Service if Table Locks or Page Locks occur by the tool (cursor usage is a typical example of this), and direct SQL access to the repository cannot take the Enterprise ACL-based inheritance security model into account, thus is definitely not recommended nor supported.

"Query" access to the managed objects in the repository should be done through the Administration SDK only, to allow the CMS services to manage all database usage, get performance the benefits of Caching, and consistently apply security. The "Query Builder" tool you see (example JSP application) calls the SDK and does not make a JDBC call to the database directly.

Note: if you need to get the "object metadata" from the CMS repository on your reports or other managed content into a structure suitable for directly building reports, there are several partner tools from APOS and others that do just that.

_________________
"Metadata Steve", a.k.a. The Thirsty Traveler 2.0
http://xir2lcm.blogspot.com/2006/02/thirsty-traveler-20.html
Back to top
venira
Principal Member
Principal Member



Joined: 07 Dec 2004

Posts: 362
Location: Tokyo


flag
PostPosted: Tue Feb 21, 2006 7:24 pm 
Post subject: Re: Repository tables in XI

So. if my understanding is not wrong, it is not possible to et the userlog of designer from the repository metadata in BOXI. Please correct me if i am wrong.

Regards,
RAVI
Back to top
venira
Principal Member
Principal Member



Joined: 07 Dec 2004

Posts: 362
Location: Tokyo


flag
PostPosted: Thu Feb 23, 2006 2:35 am 
Post subject: Re: Repository tables in XI

can any one tell me what is APOS?? is it not possible to directly querying the repository database??is it mandatory to use any reporting tool like APOS?

please clarify my doubt.

regards,
R
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Thu Feb 23, 2006 9:19 am 
Post subject: Re: Repository tables in XI

venira wrote:
can any one tell me what is APOS?? is it not possible to directly querying the repository database??is it mandatory to use any reporting tool like APOS?

http://www.apos.com

In the BusObj Administration Launchpad, there is a link to a repository query tool (forgive me, I can't remember the exact name). It is a crude tool, and I honestly haven't spent much time trying to use it. It's more of a SDK demo really.

_________________
Dwayne Hoffpauir
Image link
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 3 All times are GMT - 5 Hours
Goto page 1, 2, 3  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0360 seconds using 17 queries. (SQL 0.0032 Parse 0.0011 Other 0.0318)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo