UrbanPro

Learn SAP from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

can we create single universe with multi sources(oracle&my sql) in universe design tool? if yes then how?

Asked by Last Modified  

4 Answers

Learn SAP

Follow 0
Answer

Please enter your answer

Best SAP SuccessFactors Online Training

Cons for Single Universe - You would probably have to use contexts to keep users from building queries that mix data from different departments. This can be confusing for users. It's also more difficult to maintain because you have to manually make sure that the joins between tables are in the correct...
read more
Cons for Single Universe - You would probably have to use contexts to keep users from building queries that mix data from different departments. This can be confusing for users. It's also more difficult to maintain because you have to manually make sure that the joins between tables are in the correct context. - There would be more tables, which can make the visual view of the tables and links in the universe more difficult to see - it probably won't fit on a single screen view unless you zoom out to where you can't read the table names. This makes it harder to see how things are put together. read less
Comments

Best SAP SuccessFactors Online Training

Pros for Single Universe - There is a single place to make edits when something changes. Although from what you've described, you'd still have to make changes in multiple places in that universe. Cons for Single Universe - You would probably have to use contexts to keep users from building queries...
read more
Pros for Single Universe - There is a single place to make edits when something changes. Although from what you've described, you'd still have to make changes in multiple places in that universe. Cons for Single Universe - You would probably have to use contexts to keep users from building queries that mix data from different departments. This can be confusing for users. It's also more difficult to maintain because you have to manually make sure that the joins between tables are in the correct context. - There would be more tables, which can make the visual view of the tables and links in the universe more difficult to see - it probably won't fit on a single screen view unless you zoom out to where you can't read the table names. This makes it harder to see how things are put together. I can think of a couple of options that might make things easier, though. 1. If departments have tables that are essentially the same structure and "subject" for their data but with different names, create a view in the database that will "union" together the data for each set of similar tables. Include a static text field that will identify which department the data comes from. This way you could create a single universe on the views that would not be as complex as one on all of the tables. The down side of this would be that queries for data for one department will probably be slower using the view than just querying the tables for that department. 2. You might be able something like the following: - Create a separate "reporting" user ID for each department that is limited to seeing the tables for that department. - In the database, alias the tables and assign security in such a way that each department's tables have the exact same name as far the user ID created above can see. - Create a connection for each of the department users created above. - Create a "master" universe using one the user/department/connection combinations. - Use the master universe to create "linked" universes which have a different department connection but see the same table aliases which actually point to the different tables for that universe. Unfortunately, linked universes are only available for .unv universes created in XI 3.1 or earlier or in the legacy Universe Design Tool in 4.0. They're not available in the new .unx universes created with the Information Design Tool (IDT). read less
Comments

SAP BO Trainer with more than 7 Years of Industry and corporate Training Experience.

Hey Pavan, Multi Source Universe can only be done using Information Design Tool in SAP BI 4.0 version onward. Again, a Multi Source Universe can have all Relational or all OLAP connections only. In your case yes, it is possible to have a Universe from tables/ DB objects from Oracle and My Sql...
Comments

Leading Authorized SAP Training Centre

Better you can post this question in any SAP forums to get more support
Comments

View 2 more Answers

Related Questions

I Have passed M.com in accountancy in 2009 and then fell out due to marriage and for raising my child, and now I wish to restart afresh and get a job, but I cannot, so which course should I do to get an excellent job in these saddening time?
Hi Monisha! Yes more and more women are starting their careers after a break. My company which is among the top IT companies in India, is regarded as one of the top women employers in India. There is a...
Monisha
0 0
6

Which is the best training institute in Pune or Chichwad  for SAP training?

It is not the institute bu the trainer, Find a trainer who has industrial exposure and good teaching skill. Take into consideration given by other students reviews and most imporant is Self help is the best help.
Vaishali
0 0
5

Which companies give job opportunities for women after a career 2 to 3 yrs gap?

If we have an expected skill gap would not be a big deal. I joined cognizant after 5 years gap.
Priya

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

My Learning Strategy powered by SAP (Social-Academic-Professional Learning)
Make your Study NotesUse Mind Mapping,Flash CardsAdd bookmark-Start underlining keywordsLearn in Multiple Ways: Case Studies,Quizzes,PodCastsNever Stop Learning (and Practicing) New ThingsTeach What You've...

Corporate Challenges Of A Finance Professional Today: How to face it?
Dear Corporate Professionals, Past few decades the Global financial services industry and the accounting profession have undergone a sea change with the rapid globalization of economy where Financial...

SAP SD Training video for beginners
https://www.gurutara.com/sap-sd-training-videos-for-beginners/ SAP SD Training videos for beginners covers What is SAP SD? Why SAP SD? Who can learn SAP SD? and also SAP SD Online Training provides SAP...
G

What is M.S.Project ?
MICROSOFT PROJECT contains project work and project groups, schedules and finances.Microsoft Project permits its users to line realistic goals for project groups and customers by making schedules, distributing...

SAP Analytics Cloud(SAC), or SAP Cloud Analytics
Hi All For all those who are currently working on SAP-BW,SAP-HANA,SAP-BO,SAP-Lumira,Design Studio,S/4HANA,BW/4HANA suggested to update SAP Analytics Cloud(SAC) a cloud version of BI from SAP Which is...

Recommended Articles

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Looking for SAP Training?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
X

Looking for SAP Classes?

The best tutors for SAP Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn SAP with the Best Tutors

The best Tutors for SAP Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more