Derived Universe

building semantic layer
1

Hi ,

I want to design derived universes from a Large Universe due to the Business users requirements basing upon their department needs.Initially when business objects reporting solution was rolled out ,2 big universes were designed and wanted all the users across the company to start using the universes for doing their own reports for a self service model.

Now the users are complaining that they are finding it difficult to navigate thru all the available objects and at times it is very confusing for them to find out what they are looking for.

My task now is to build as many small universes as possible to cater to independent departments.

I understand Maintaining these small Universes is a big task.

My question now is if the changes are done at the core universe will the changes perculate to the derived universes or do i need to do the changes to each individual universe.
Secondly what kind of security/access level settings are required such that data from Dept A is not seen by Dept B
Environment :Business Objects XiR2,WebI for reporting.
Any help is appreciated.

pan1969 :us: (BOB member since 2005-01-27)

2

Changes to the core universe will propagate to the derived universe. A quick analogy would be a shortcut to a document on a server. When the document on the server changes, you see the changes when you open the shortcut.

You can apply your row security restrictions on the derive universe to limit users from viewing each other’s data. The other option is Oracle VPD if you are using Oracle. You can pass the login to Oracle using the connection ConnectInit parameter with logic like so where INITIALIZE_BO is a stored procedure in Oracle:
begin INITIALIZE_BO(’@VARIABLE(‘BOUSER’)’); end;

vxl1970 (BOB member since 2008-05-15)

3

Hi,

I came across this Terminology “Derived Universe” for the first time. Is it a synonym for “Linked Univese” or is it something else?
And how do we create a derived Universe.
Kindly explain.

Thanks,
Siddhartha

siddhartha.dubey :india: (BOB member since 2006-09-13)

4

The concept of linked universes is indeed to try and ease the maintenance. Linked universes however bring their own issues and personally I’d rather take the hit on maintaining multiple universes rather than linking.

That is available in the Designer User Guide.

dessa :madagascar: (BOB member since 2004-01-29)