Skip to Content

Convert Existing Objects in Main Universe to New Objects from Linked Universe?

Within our data warehouses we have a subject area called Job that pretty much joins to everything. Job comes along with many many attributes.

In total, we have 15 universes. We recently created a Job Master universe, and now I would like to Link this in to all other universes to take advantage of.

The issue comes in that the 15 universes already have a lot of the Job Attributes.

In a magical world when I link in the Job Master universe, I would be able to map the old Object ID's to the new Object ID's so that any existing reports, when opened, would reference the object in the linked universe. Eventually I could go and delete out all of the old attributes and corresponding tables from the data foundation.

I'm sure I'm not the only one encountering this issue. I'm guessing there is no way to link an old ObjectID to a new ObjectID within a given universe?

Is there a tool that would go through all reports and update an old ObjectID to a new ObjectID?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Feb 21 at 06:43 PM

    I think your best bet is to use the Change Source function in WebI. Normally you use this to switch a report from one universe to another, but you can also use it to modify a report to replace one object with another (you just pick the same universe as the target). In your case, you'd replace all references to objects in the Job Details class with the associated objects in the Job Master class. Once done, the query should point to the Job Details objects, and the report should look exactly as it did before.

    This can also be done via the REST API. You could write a script that automates the "Change Source" function, but you'll need to map all of the old object IDs to the new ones. That can also be automated. It would be a bit of scripting, but easier than modifying hundreds of reports by hand.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14 at 08:09 PM

    I have very limited knowledge with linked universe but if you can replace the tables in data foundation and map the existing objects in business layer again with new table mapping then you don't need to do any changes at reports level.

    Even in the business layer with find/replace functionality you can update the objects mapping from old to new in single step.

    In case of replacement of table mapping from old to new I would first insert new table in DF and change the joins from old to new.after that in business layer I would use find/replace functionality to change mapping of all objects from old to new.

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Amit, this would be applicable for all scenarios where you are replacing objects EXCEPT for linked universes :( .

      When you link in a core universe, the linked in objects are all locked and cannot be modified.

      linked-objects.png (10.2 kB)
  • Feb 16 at 04:13 PM

    It's not really clear. But my understanding is you are trying to create one Core universe which is the Job Master universe and then have 15 Derived universe and map the old CUID from the 15 Derived universe to the new CUID for the core.

    If that is the case… yes you can create One Core universe to multiple Derived universe and mapping is done automatically based on the core id. All core universe object must be available and valid through the connection. However, CUID’s are different. Core object in Derived Universe (seen in gray) has its own ID and a reference on the original ID in the Core (used to do the synchronized).

    So if you have an older webI report, then you have to change the source in webI to the core universe. Changing the source in Webi is mandatory.

    I hope this answer your questions.

    Add comment
    10|10000 characters needed characters exceeded

    • The report was build before the Linked universe. Now, the universe is linked. Which means CUID’s are different. Core object in Derived Universe has its own ID. So it's basically having a new universe. So you have to update the source in WebI. I'm hoping it would not break the report link. But that is how it should work. I'm not really sure about SDK.

  • Feb 21 at 09:31 PM

    Joe Peters what about this new utility that I just came across? Does this automate what I'm asking to do?

    Note 2432962

    Add comment
    10|10000 characters needed characters exceeded