I was wondering if anyone had an up to date copy of the universe that goes against the Security, Universe, and Document domains?
I am looking for which ever one is current with version 4.1 or better.
Thanks a bunch
Michael Holly
Southwestern Bell Telephone
Listserv Archives (BOB member since 2002-06-25)
Has anyone ever created a Repository Universe? I need to be able to run a monthly report that shows each Business Objects User and the documents they have access to.
Cynthia L. Spears, SSgt, USAF
HQ SSG/SWSX 596-3376
Cynthia.spears@gunter.af.mil
Listserv Archives (BOB member since 2002-06-25)
Spears Cynthia L SSGT HQ SSG/SWSX escribiÛ:
Has anyone ever created a Repository Universe? I need to be able to run a monthly report that shows each Business Objects User and the documents they have access to.
Cynthia L. Spears, SSgt, USAF
HQ SSG/SWSX 596-3376
Cynthia.spears@gunter.af.mil
You have one. It is available in your BO 5 CDROM. This is the PATH
G:\freeware\Repostry\Managero.unv
There are a good HTML documentation about the repository
–
Libardo Rodriguez V.
UNIBASE
Listserv Archives (BOB member since 2002-06-25)
I tried to, but there are a lot of things that won’t work… BO does a lot with inheritance - eg, a group has access to documents and this user is in these groups - to really show all users you have to do some nested queries…
Someone correct me if I am wrong, but that is what I found
Brent
Has anyone ever created a Repository Universe? I need to be able to run a
monthly report that shows each Business Objects User and the documents they
have access to.
Listserv Archives (BOB member since 2002-06-25)
I do have one…
It was sent by BO support… not managerO
Ashish
Listserv Archives (BOB member since 2002-06-25)
Are you taking requests for the sharing of this? I would love to get a copy if you have time.
Thanks,
Simon
Listserv Archives (BOB member since 2002-06-25)
In a message dated 00-02-10 17:33:48 EST, you write:
Has anyone ever created a Repository Universe? I need to be able to run a
monthly report that shows each Business Objects User and the documents they have access to.
Unfortunately, this is not a trivial issue. You can easily find documents that users have a direct link to, but detailing the inherited documents gets trickier.
For example: it’s an easy thing to determine which documents I have exported myself. That’s because I am the owner of the document.
Determine which other documents I have access to requires a recursive traversal of the repository tables, checking at various levels for granted or revoked documents.
If someone does have standard SQL or a universe that has been verified correct to do this, I would love to see it!
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)
I am sorry to say but I would love to get a copy if you can find time for that.
Thanks,
Modest Orman
Listserv Archives (BOB member since 2002-06-25)
May I get a copy of this other Repository Universe that is not Managero?
Thanks,
Glenn R. Cameron
On Fri, 11 Feb 2000 09:36:16 -0500, Simon Miller Simon.Miller@DIVERSEYLEVER.COM wrote:
Are you taking requests for the sharing of this? I would love to get a
copy if
you have time.
Thanks,
Simon
I do have one…
It was sent by BO support… not managerO Ashish
Has anyone ever created a Repository Universe? I need to be able to run a monthly report that shows each Business Objects User and the documents they have access to.
Listserv Archives (BOB member since 2002-06-25)
Has anyone built a universe off of the BO repository tables (5.1.2/2.6.2)? If so would you mind sharing? We’d like to be able to easily report (using BO) on our repository… the more robust the better!
ROD
Listserv Archives (BOB member since 2002-06-25)
If you use Oracle for your repository, this already exists in the “Freeware” folder on the Install CD (CD1) as ‘managero.unv’. We use SQL Server for our repository, and I’ve just not done the work of porting over the universe and getting the syntax just right.
Blake
Listserv Archives (BOB member since 2002-06-25)
Wow. That’s pretty nice but only covers the UNV tables in the repository - anyone know of one that deals more directly with security in the the rep tables? OBJ_M_ACTOR and the like?
ROD
Listserv Archives (BOB member since 2002-06-25)
In a message dated 01-05-16 15:49:40 EDT, you write:
Wow. That’s pretty nice but only covers the UNV tables in the repository -
anyone know of one that deals more directly with security in the the rep tables? OBJ_M_ACTOR and the like?
Not one that will do you any good. The security tables use indirect references and recursive relationships… two things that cannot be effectively reproduced with straight SQL.
An example of a recursive relationship would be the fact that groups can contain sub-groups which can contain sub-groups which can contain… you get the idea. You have no idea how deep the tree structure may go. And don’t forget that users can exist in multiple groups, so there is another factor to consider.
An example of an indirect reference is the fact that a universe can be exported / enabled at a top (group) level. Every user in that group, or in a sub-group, or in a sub-sub-group (oh wait, covered that already ) gets access to that universe by inheritance but may or may not have a direct link to the universe resource. So asking a simple question like, “Who has access to this universe” rapidly becomes an exercise in futility.
Obviously BusObj has a way of extracting the information. I have heard a rumor, however, that they run 20+ separate SQL queries against the repository each time a person logs in. Recreating that logic in a universe is not going to be a trivial task.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)