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.

how to query BO DB repository
2 members found this topic helpful
Goto page 1, 2  Next
 
Search this topic... | Search CMC... | Search Box
Register or Login to Post    Forum Index -> Security and User Administration -> CMC  Previous TopicPrint TopicNext Topic
Author Message
bo_rapor
Forum Member
Forum Member



Joined: 03 Jan 2009

Posts: 23



PostPosted: Sat Jan 03, 2009 5:32 am 
Post subject: how to query BO DB repository

I want to query BO dB repository like Microsoft Reporting Services.
I now BO repository has encrypted binary data. Maybe there is a way to do that.

Does anybody know?
Back to top
bernard timbal
Forum Addict
Forum Addict



Joined: 26 May 2003

Posts: 3882
Location: Paris - FRANCE


flag
PostPosted: Sat Jan 03, 2009 5:58 am 
Post subject: Re: how to query BO DB repository

Sorry but you can't query repository as it was in v4/5/6. A solution is to use the query builder tool but results are not very exploitable. So the solution is to use SDK to achieve it...
_________________
Bernard TIMBAL DUCLAUX de MARTIN
BusinessObjects Platform Certified Consultant
Image link
(Co)author of 2 books about SAP BusinessObjects XI3.x and BI4.x Administration
Back to top
bo_rapor
Forum Member
Forum Member



Joined: 03 Jan 2009

Posts: 23



PostPosted: Tue Jan 06, 2009 2:33 am 
Post subject: Re: how to query BO DB repository

Then, is only way sdk?
Back to top
bernard timbal
Forum Addict
Forum Addict



Joined: 26 May 2003

Posts: 3882
Location: Paris - FRANCE


flag
PostPosted: Sun Jan 11, 2009 3:24 pm 
Post subject: Re: how to query BO DB repository

Yes, only sdk if you considere (like me) that Query Builder is not useable icon_wink.gif
_________________
Bernard TIMBAL DUCLAUX de MARTIN
BusinessObjects Platform Certified Consultant
Image link
(Co)author of 2 books about SAP BusinessObjects XI3.x and BI4.x Administration
Back to top
Sebastien Goiffon
Forum Fanatic
Forum Fanatic



Joined: 29 Sep 2004
ASUG Icon
Posts: 6450
Location: Boston, MA


flag
PostPosted: Fri Jan 16, 2009 8:46 am 
Post subject: Re: how to query BO DB repository

Did you try the security viewer?
_________________
360Suite: Security, backup, promotion, bursting, automated regression testing, BI on BI, version control solutions.
Fast-track migration to bi4.2 80% time saver.
Back to top
bo_rapor
Forum Member
Forum Member



Joined: 03 Jan 2009

Posts: 23



PostPosted: Fri Jan 16, 2009 8:54 am 
Post subject: Re: how to query BO DB repository

how can i reach security viewer?
is it a tool or is it in BOXIR3.0?
Back to top
Sebastien Goiffon
Forum Fanatic
Forum Fanatic



Joined: 29 Sep 2004
ASUG Icon
Posts: 6450
Location: Boston, MA


flag
PostPosted: Fri Jan 16, 2009 8:58 am 
Post subject: Re: how to query BO DB repository

No sorry only for Xir2 ...
_________________
360Suite: Security, backup, promotion, bursting, automated regression testing, BI on BI, version control solutions.
Fast-track migration to bi4.2 80% time saver.
Back to top
marklee
Forum Member
Forum Member



Joined: 12 Dec 2008

Posts: 2



PostPosted: Thu Jan 22, 2009 10:19 am 
Post subject: Re: how to query BO DB repository

Hi, I managed to work out how to decrypt the infoobjects table.

For Oracle you could use the following to build a universe but run it at your own risk. I have only used it against test and development environments just in case it causes and issue. Also, I wouldn't rely on it working when upgrading Webi.

select
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
translate(replace(objname,'BE','.'),')+-/13579;=?ACEGIKMOQSUWY]!"{','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),
'`|>','1'),
'`|@','2'),
'`|B','3'),
'`|D','4'),
'`|F','5'),
'`|H','6'),
'`|J','7'),
'`|L','8'),
'`|N','9'),
'M|N','_'),
'M|Z','-'),
'@',' '),
'`|<','0'),
'B~P','/'),
'M}Z',':'),
'B|C','('),
'B|D',')'),
'B~K','@')
trans,cms.objname,cms.si_cuid,
cms.parentid,
decode((select typeid from CMS_INFOOBJECTS5 cmsp where cmsp.objectid = cms.parentid),311,'Webi Report',308,'Deski',1,'Folder',(select typeid from CMS_INFOOBJECTS5 cmsp where cmsp.objectid = cms.parentid)) parent_typeid,
cms.objectid,to_date(substr(cms.lastmodifytime,1,19),'YYYY MM DD HH24 MI SS')+1/24 lastmodifytime
,decode(typeid,311,'Webi Report',308,'Deski',1,'Folder',typeid) typeid
from CMS_INFOOBJECTS5 cms

It's not complete but should bring back something useful

For SQL Server try


select
objectid,
parentid,
ownerid,
lastmodifytime,
upper(left(objectname,len(objectname)-2)) ObjectName,
typeid,
type,
si_cuid
from
(
SELECT
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
cast(objname as varchar(2000))
,'S','v')
,'M','s')
,'A','m')
,')','a')
,'+','b')
,'C','n')
,'-','c')
,'/','d')
,'O','t')
,'E','o')
,'1','e')
,'3','f')
,'G','p')
,'5','g')
,'7','h')
,'W','x')
,'U','w')
,'Q','u')
,'I','q')
,'9','i')
,':','i')
,';','j')
,'K','r')
,'=','k')
,'?','l')
,'[','y')
,']','z')
,'!@',' ')
,'B~S','&')
,'!BO','.')
,'B|C"','(')
,'!B|D',')')
,'M|Z','-')
,'M}L',',')
,'M|N','_')
,'M}Z',':')
,'!B{B','''')
,'`|<','0')
,'`|>','1')
,'`|@','2')
,'`|B','3')
,'`|D','4')
,'`|F','5')
,'`|H','6')
,'`|J','7')
,'`|L','8')
,'`|N','9')
,'{','')
,'!','')
,'"','')
,'@','')
ObjectName,
case
when TypeID = 262 then 'Webi Report'
when TypeID = 314 then 'Deski Report'
when TypeID = 283 then 'PDF'
when TypeID = 267 then 'Text'
when TypeID = 323 then 'Excel'
when TypeID = 266 then 'Universe'
when TypeID = 278 then 'Publication'
when TypeID = 299 then 'Connection'
when TypeID = 19 then 'User type 19'
when TypeID = 18 then 'User type 18'
when TypeID = 47 then 'User type 47'
when TypeID = 48 then 'User type 48'
when TypeID = 8 then 'Shortcut'
when TypeID = 1 then 'Folder'
when TypeID = 20 then 'Groups'
when TypeID = 13 then 'Server'
when TypeID = 16 then 'BO Server'
when TypeID = 21 then 'Event'
when TypeID = 24 then 'License Key'
else 'Other'
end Type,
*
FROM [BOXI_CMS].[dbo].[CMS_InfoObjects5]
) BORepository


Cheers
Back to top
sticky
Forum Member
Forum Member



Joined: 20 Apr 2007

Posts: 10



PostPosted: Thu Jan 22, 2009 8:22 pm 
Post subject: Re: how to query BO DB repository

YOU ARE A GOD!!!!!!!!!!!!!!!!!!
icon_idea.gif
Back to top
bo_rapor
Forum Member
Forum Member



Joined: 03 Jan 2009

Posts: 23



PostPosted: Fri Jan 23, 2009 2:55 am 
Post subject: Re: how to query BO DB repository

waow. thnx.

this is also desert;

replace(convert(char(10),lastmodifytime),' ','') as lastmodifytime,
Back to top
bo_rapor
Forum Member
Forum Member



Joined: 03 Jan 2009

Posts: 23



PostPosted: Fri Jan 23, 2009 6:09 am 
Post subject: Re: how to query BO DB repository

hi,

thank you for your help. I want to add folder descriptions in my report.
do you column name of that?
Back to top
bo_rapor
Forum Member
Forum Member



Joined: 03 Jan 2009

Posts: 23



PostPosted: Thu Feb 05, 2009 10:08 am 
Post subject: Re: how to query BO DB repository

do you have any idea about logging description of objects?
Back to top
bo_rapor
Forum Member
Forum Member



Joined: 03 Jan 2009

Posts: 23



PostPosted: Thu Feb 05, 2009 10:10 am 
Post subject: Re: how to query BO DB repository

And also;

We are using nt authentication for bo. How can we report nt group names in our audit report?

Thnx
Back to top
bo_rapor
Forum Member
Forum Member



Joined: 03 Jan 2009

Posts: 23



PostPosted: Thu Feb 12, 2009 9:23 am 
Post subject: Re: how to query BO DB repository

And one more question:

We can find universes with TypeID = 324, and groups with TypeID = 20.

How can we releate Universes with Groups?
This means; we want to say "x" group has right for "b" and "c" universes.

Is it possible?
Back to top
exile
Senior Member
Senior Member



Joined: 02 May 2008

Posts: 42



PostPosted: Thu Jul 16, 2009 6:57 pm 
Post subject: Re: how to query BO DB repository

Hey,

1st of all, thank you so for this code correction. I was going nuts with the code from businessobjectstips.com where the commenter missed the '0' (zero replacement).

I have a question.

What is the TYPEID for Crystal Reports?

Is it 2?

I seemed to get the parameter objects related to Crystal Reports when I restrict by TypeID 2 only.

Thanks
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Security and User Administration -> CMC  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT - 5 Hours
Goto page 1, 2  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.0491 seconds using 17 queries. (SQL 0.0021 Parse 0.0345 Other 0.0124)
CCBot/2.0 (http://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