XI Repository (Schema Design)

system · October 19, 2007, 3:54pm

I wonder if any body have the schema design for XIR2, Would be really great!!!
Because I need to know following information for X report

Who is receiving X report???
What time x report runs???

Etc.

Note: I need to get these answers from Query builder

Thanks in advance.

cva (BOB member since 2006-05-20)

system · October 22, 2007, 10:34am

The db is denormalised and most things are in binary.

Pretty much everything goes into CMS_Infoobjects.

If you have a look at the instance manager that pretty much gives you this information also.

Andy

ABILtd (BOB member since 2006-02-08)

system · October 27, 2007, 7:46am

Thanks for your kind Responce.

To answer the simmilar queries we are going to build the Universe based on this tables…

CMS_Aliases5
CMS_IdNumber5
CMS_InfoObjects5
CMS_RELATIONS5
CMC_VersionInfo …

any ideas is much apreciated on building the universe on Repository.

Thanks in advance,
Siva

cva (BOB member since 2006-05-20)

SebastienGoiffon · October 27, 2007, 1:23pm

Hi Siva,

Please avoid cross post.

Regards
Sebastien

system · November 7, 2007, 2:35pm

Hi,

As I said the majority of things in the BOXI repository are binary and pointers, building a universe on it would be pointless. That and BO warn against querying the repository directly.

Your best bet it to either use the SDK to write a bunch of infostore queries, or to use Auditor if you have the license.

Andy.

ABILtd (BOB member since 2006-02-08)