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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (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 Previous  1, 2
 
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
bdharma
Senior Member
Senior Member



Joined: 07 Jul 2008

Posts: 64



PostPosted: Fri Oct 02, 2009 4:20 pm 
Post subject: Re: how to query BO DB repository

It looks like for SI_Kind ='CrystalReport' the TYPEID/SI_OBTYPE is 2 but please verify
Back to top
Cybersoft
Forum Member
Forum Member



Joined: 08 Dec 2007

Posts: 9
Location: Ankara


flag
PostPosted: Mon Oct 25, 2010 6:45 am 
Post subject: Re: how to query BO DB repository

bo_rapor wrote:
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?


That would be great!
Back to top
wasy.wasu
Senior Member
Senior Member



Joined: 17 Sep 2006

Posts: 60
Location: Bethesda, MD, USA


flag
PostPosted: Mon Dec 03, 2012 10:33 pm 
Post subject: Re: how to query BO DB repository

hi,

that work is awesome, was wondering and trying to understand how did you manage to decode the characters, is there a way or pattern you have...

how did you match the characters with Letters/Numbers?

appreciate if you could help me out here..really appreciate...

thanks,
-wasy
Back to top
ErikR
Forum Enthusiast
Forum Enthusiast



Joined: 10 Jan 2007

Posts: 1111
Location: Wellington, NZ


flag
PostPosted: Tue Nov 26, 2013 10:32 pm 
Post subject: Re: how to query BO DB repository

Does anyone has an updated decryption logic or character match table for BO 4.0 and BO 4.1?

The included query runs against my BO 4.0 CMS database but is not correctly showing all the object names.
Back to top
wasy.wasu
Senior Member
Senior Member



Joined: 17 Sep 2006

Posts: 60
Location: Bethesda, MD, USA


flag
PostPosted: Tue Dec 03, 2013 11:56 am 
Post subject: Re: how to query BO DB repository

i was able to change few of them and this is working fine for me..i can see all of the names properly.

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(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
to_char(objname)
,'"','"')
,')','a')
,'+','b')
,'-','c')
,'/','d')
,'1','e')
,'3','f')
,'5','g')
,'7','h')
,'9','i')
,':','i')
,';','j')
,'=','k')
,'?','l')
,'A','m')
,'C','n')
,'E','o')
,'G','p')
,'I','q')
,'K','r')
,'M','s')
,'O','t')
,'Q','u')
,'S','v')
,'U','w')
,'W','x')
,'[','y')
,'Y','y')
,']','z')
,'`|<',0)
,'`|>',1)
,'`|'||'@',2)
,'`|'||'B',3)
,'`|'||'D',4)
,'`|'||'F',5)
,'`|'||'H',6)
,'`|'||'J',7)
,'`|'||'L',icon_cool.gif
,'`|'||'N',9)
,'`|','$')
,'!@',' ')
,'Bo','.')
,'m}d','--')
,'m}l',',')
,'m}w',';')
,'m}z',':')
,'o}H','+')
,'!m|N','_')
,'m|N','_')
,'m~T','?')
,'B|c','(')
,'!B|d',')')
,'m|Z','-')
,'B|e','[')
,'B|',']')
,'B~s','&')
,'B~w','%')
,'B~v','#')
,'B~p','\')
,'o~&','~')
,'m~L','!')
,'!B{B','')
,'{','')
,'!','')
,'"','')
,'@',''||'')
Object_name,


also, these are the types i was able to identify for my use.

case
when TypeID = 1 then 'Folders'
when TypeID = 8 then 'Shortcut'
when TypeID = 16 then 'BO Servers Nodes'
when TypeID = 18 then 'Favorites Folders'
when TypeID = 19 then 'users'
when TypeID = 20 then 'groups'
when TypeID = 22 then 'Calendars'
when TypeID = 45 then 'Categories'
when TypeID = 47 then 'Personnal Categories'
when TypeID = 48 then 'inboxes'
when TypeID = 57 then 'Access Levels'
when TypeID = 59 then 'Clusters'
when TypeID = 260 then 'PDF Instances'
when TypeID = 266 then 'Excel Report'
when TypeID = 268 then 'Profiles'
when TypeID = 273 then 'Relication list'
when TypeID = 275 then 'Universes'
when TypeID = 291 then 'Federation Jobs'
when TypeID = 291 then 'Replication Jobs'
when TypeID = 295 then 'Remote Connections (Federation)'
when TypeID = 319 then 'Webi report'
when TypeID = 322 then 'LCM Jobs'
when TypeID = 333 then 'Probes'
when TypeID = 342 then 'Universes (.unx)'
when TypeID = 363 then 'Connections'
when TypeID = 365 then 'Events'
when TypeID = 392 then 'Platform Search Scheduling'
else 'Null'
end object_type,

hope this helps..

let me know.

-wasy
Back to top
pratip
Principal Member
Principal Member



Joined: 06 Apr 2007

Posts: 141
Location: chennai,india



PostPosted: Fri May 22, 2015 3:20 pm 
Post subject: Re: how to query BO DB repository

Hello All -

Can anybody let me know how to identify the "Class Name" of an object used in a report.

I am using XI3.7 version

Thanks,
Pratip
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6625
Location: Connecticut, USA


flag
PostPosted: Sat May 23, 2015 8:26 am 
Post subject: Re: how to query BO DB repository

You're not going to get that from a repository query. Only option is a program using the Report Engine SDK.

Joe
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Security and User Administration -> CMC  Previous TopicPrint TopicNext Topic
Page 2 of 2 All times are GMT - 5 Hours
Goto page Previous  1, 2
 
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.0292 seconds using 17 queries. (SQL 0.0035 Parse 0.0009 Other 0.0248)
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