Add new connection to existing universe foundation

[Former Member]

Hi,

I have universe which was converted to UNX, I retrieve the universe to add to my projects, The data foundation is already created when i retreie the universe to local projects, which displaying all the tables (universes structure) The universe has more then 100 table and derived tables. I wanted to add one more connection to this data foundation to add few more tables from different database, but I don't see that options. Is possible or does IDT has the feature to add new connections to the existing universe, Is there any option available where i can avoid the starting from the scratch,  

thanks

kareem

[former_member193452]

Hi Kareem,

A unv universe converted to unx universe will only be a single source universe.

You can replace or edit a connection but not add an additional connection.

For adding an additional connection you will need a new Data Foundation selected as Multi-source.

But if you're just changing the connection in single source.

Then create a new connection and a shortcut to your local project

Then open the data foundation

click the Connection button in the middle bottom.

Icon appears for selecting the new shortcut.

then save and go to ACTIONS on the toolbar.

Refresh Structure.

Save and republish the Business Layer.

Jacq

[Former Member]

Thanks Jacq,

can I use a Universe in new data foundation, example

1) I will create a new data foundation add connection1 tables

2) can I add UNX universe to to any data foundation,

The universe has more then 100 tables with joins and contexts which is lot of work if i do as a new data foundation , is it possible to use this universe or copy universe structure / tables to the new data foundation

Thanks

Kareem

[Former Member]

Hi Kareem,

             if you lots of tables  there  if you feel lots of work to do in IDT there is an option called view you can separate tables by creating views on top of it you have to create Master view it will be easier to you

Thank you

varun G

[Former Member]

Hello Varun,

Actually some of these are derived tables created in BOXI 3.1,

I actually wanted to know If it is possible to add a existing universe to new multisource data foundation where I can I have more connections

Thanks

Kareem

[former_member193452]

Hi Kareem,

This is not possible for a multisource universe.

You can only convert a XI3.1 universe to a single source universe.

It is not possible to convert a single source universe to a multisource.

so there is no work flow to bring in a single source to multisource.

Jacqueline