Linked universes in Universe Designer

Jan 16, 2017 at 06:19 PM|54 Views

Hi,

Is it possible to add to an already created universe a table coming from excel? I was thinking to create a universe pointing to excel and then to link this new universe with the existing one. What do you think? The existing universe points to an Oracle database.

In what directory should we put the excel?

We use 3.1 version and unfortunately we don't have the Rich Client activated. It would have been much more easier with Rich Client.

Related questions

2 Answers

If you don't have access on rich client then instead of linked universe,load excel file in the database under the same schema.After that you can use the table in the same universe.

These are some things to remember with Linked universe.

Things to remember for Linked universes

Linking universes must use the same data account/database and same RDBMS.• Using the same connection for both universes makes managing the universes easier, but this can be changed at any time.• Core and Derived universes must be in same repository.• Core universe must be exported and re-imported at least once.• Derived universe does not need to have been exported before creating a link.• Only the table schema, classes and objects of the core universe are available in the derived universe. Contexts must be re-detected in the derived universe.• Exported derived universes are located in the same universe domain as the core universe.• You are authorized to link the given universe.