SAP BusinessObjects Universes can be acquired by SAP Analytics Cloud as well as connected to in a ‘live’ means. When connecting ‘live’ the data stays on-premise and only metadata is uploaded into the Cloud. You may wonder what are the best practices for Universe design for such a use-case. Look no further!
I’ve just published a wiki that presents the theory and a methodology:
I hope this wiki answer many ‘why’ questions. Your feedback would be helpful! ?
Knowing the theory is all well and good, but sometimes a practical step-by-step guide is also needed. Therefore, I’ve published another wiki to complement the theory using my Auditing Universe as an example.
You can follow this Live Universe step-by-step guide and within a short time use my Auditing universe to build a dashboard like this:
I’ve also updated my ever-expanding ‘Support Matrix’ with a section dedicated for Universes. The idea of this is to keep the list of known restrictions in one place. (That wiki is still in development)
According to the SAP Roadmap the live connection for Universes is due for some enhancements soon. With the speed of innovation, I will do my best to keep all this material up-to-date! So, it’s best to keep following for updates! ?
As ever, feedback is very welcome. Tell me what you think!
Matthew (Twitter @MattShaw_on_BI)