on 05-27-2014 5:29 AM
Hi Experts,
Can we join HANA analytical views in BO universe? we have 14 analytical views.
User wants to do self service reporting using webi.
what is the best approach to build the universe so that it satisfies the self service reporting out of this 14 views.
Please advise.
Thanks,
Satyam
That error usually occurs when the aggregation functions on the measures aren't defined. You will probably have to manually edit each measure in IDT to include SUM(....)
Error aside, are you sure you want to join views in IDT? You will be killing your HANA performance. It would be better to create a calculation view in HANA to join all your views and then connect directly to that without doing any joins in BOBJ. The result will be a lot less data being transferred over into BOBJ for calculation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Yes, you can join HANA analytical Views and develop the universe.
You can connect SAP HANA using relation connection using JDBC or ODBC drivers.
If 14 views are related different business areas...then Design and develop the universe based on business areas (Sales, Finance, HR etc.. ), you need to develop the universe model if your data warehouse is small.
But for self-service universe you need to incorporate all the business logic and calculations at the universe level.so users can only drag and drop the objects in the report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.