BusinessObjects Board

Repositry tables

building reports webintelligence
#1

I need to take to produce the report by using Repositry tables

Report name
Report exists folder
connection
universe name

can u pls tell me how to write the query

parameshwaran (BOB member since 2008-09-05)

#2

To get a list of all full client & WebI reports:

Select SI_ID, SI_NAME From CI_INFOOBJECTS WHERE SI_KIND IN ('FullClient', 'Webi')

To get a list of reports in a particular folder you need to first get the parent folder ID, then use it to list reports

To find the parent ID that is the folder ID run this query and look for your report names

SELECT SI_NAME, SI_KIND, SI_DESCRIPTION, SI_PARENTID FROM CI_INFOOBJECTS WHERE SI_KIND IN ('FullClient', 'Webi')

Now run the below query to get a list of Full Client and WebI reports from the folderID got from above query

SELECT SI_NAME, SI_KIND, SI_DESCRIPTION FROM CI_INFOOBJECTS WHERE SI_KIND IN ('FullClient', 'Webi') AND SI_PARENTID=123

To get a list of all universes:

Select SI_ID, SI_NAME, SI_KIND From CI_APPOBJECTS where SI_KIND ='Universe'

To get list of all connections:

select si_name, si_id from ci_appobjects where si_kind = 'MetaData.DataConnection'

.

haider :es: (BOB member since 2005-07-18)

#3

can u pls tell me on which database it is stored

parameshwaran (BOB member since 2008-09-05)

#4

I want to make a Report in DESKI that all the Reportsname ,corresponding foldername,
corresponding connectionname, corresponding universename…

Like this format shown below
can u pls help me from this issue…

Report name folder name connectionname universe name

parameshwaran (BOB member since 2008-09-05)

#5

You can run the above queries by using query builder utility from admin launchpad(http://servername/businessobjects/enterprise115/WebTools/adminlaunch/default.aspx)
But you will not be able to get in the desired format, though by using SDK it may be possible

.

haider :es: (BOB member since 2005-07-18)

#6

can u pls Tell me where this tables are stored
how can i find

CI_INFOOBJECTS
CI_APPOBJECTS

And also if any body having SDK programs also needed

parameshwaran (BOB member since 2008-09-05)

#7

Its in the CMS repository database which can be accessed using the below url which was given earlier

http://servername/businessobjects/enterprise115/WebTools/adminlaunch/default.aspx

You should find a link for Query builder on the left pane

.

haider :es: (BOB member since 2005-07-18)

#8

@Parameswaran: Please do not use any chat words like u for ‘you’. Also please do not write anything in ‘highly bold and capitalized’ format. It seems as if you are shouting. I have seen many warning replies before.

Jansi :india: (BOB member since 2008-05-12)

#9

For JANSI

why I make the word as BOLD means, to show the members what i looking for that is my main intention… (Not for shouting)

parameshwaran (BOB member since 2008-09-05)

#10

Hi All

I checked the CMS repository on my server but unable to find the tables like:

CI_APPOBJECTS
CI_INFOOBJECTS
CI_SYSTEMOBJECTS

though I found the following tables:

CMS_INFOOBJECTS5
CMS_RELATIONS5
CMS_ALIASES5
CMS_FRONTIER5
CMS_CCFRONTIER5
CMS_ROOTFRONTIER5
CMS_IDNUMBERS5
CMS_VERSIONINFO

please tell me where are the above tables and when i use query builder to fire the query to which database it refers to.

Regards
Anshul

anshuls (BOB member since 2007-03-16)

#11

Moderator note: Just to clarify things here: The bold caps used for the table names are fine. Generally speaking, using all caps online is considered shouting. However, the table names are all in caps in the repository, so no one will consider that to be shouting.

Having said that: Please do not use Instant Message abbreviations on BOB. We want to keep BOB easy to understand for our International community. Thanks.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

#12

Read this.

Joe

joepeters :us: (BOB member since 2002-08-29)