adding a connection to a universe

[former_member248263]

I have an existing universe (a .unv originaly created in BO XI R2 or before) that is currently in BO 4.1 SP7.

There is a need to add a source of data to this universe.

I understand that there is no way to convert a .unv to a .unx based off a

a multisource-enabled data foundation but what would be the recommended approach to achieving this? and are there best practices somewhere that I could look up when creating a new Data Foundation / Business Layer.

The reason I ask is that if I am going to fully recreate a universe with ~25 contexts, ~100 tables, ~500 dimensions and ~200 measures ... I would really like to avoid traps and have to live with mistakes in the future.

Can anyone recommend an approach? Best practices? or anything that could help guide me?

[amitrathi239]

if new data source is required for limited reports then you can create separate universe and use multiple webi queries to display data at webi level.with this you can avoid creating new universe.

if it is going to important in future and need in single universe then only option is to create multi-source universe.

check attached links.

http://www.clariba.com/blog/2645

https://wiki.scn.sap.com/wiki/display/BOBJ/Conversion+of+the+relational+universes+in+BI+4.x%2C+from+...

[former_member248263]

The process on the clariba blog is what I was looking for. I was told that the business layer could not be re-used and I was happy to see that there is a chance for some copy paste on the data foundation.

Now if I could only find some best practices when creating a new Data Foundation, I would feel much more confident that I am doing it right. [or better if nothing else]

[amitrathi239]

I do not have any such document.I would suggest check IDT help guide for building universe.

[former_member193452]

Amit is correct. There is no possible way to convert your existing universe into a Multisource universe.

Here is a link for tutorials in IDT:

https://archive.sap.com/documents/docs/DOC-8461