Hi Experts,
We have set of Business Object reports based out of universes, now we are planning to move these reports to Power BI.
The users creates reports on Ad hoc basis based out of universes here.
Now we have decided to change all this setup to Power BI, I know we can do Power Bi reports design, but have few questions below:
- What is the effective way to replicate universes in such model so that Users can design ad-hoc reports out of it. Here users are not SQL friendly hence we need to have Universe like model available for them to create Power BI reports.
- What are the tools we need to have to have universe like models so that Users can create ad-hoc power bi reports? Can we use SSAS to design models for reports
- If SSAS ,whether a Power BI report can be designed from multiple models (Like a Business Objects reportins connecting to more than 1 universes)
- Can SSAS models be Semantic Layer witout storing data in it?
Appreciate the replies and suggestions here.
Thanks
