cancel
Showing results for 
Search instead for 
Did you mean: 

Can we join HANA analytical views in BO Universe?

Former Member
0 Kudos


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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

former_member4998
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Hi Sreeni,

Thank you. Today, I have tried joining analytical views in IDT. But, it is shwoing the below error.

Am I doing something wrong? Please advise.

Thanks,

Satyam