SAP HANA Features with BusinessObjects BI Solutions – TechEd Never Ends
One of the nice things about TechEd (now dcode) is it doesn’t end after you leave the event. There’s virtual TechEd, giving you structured opportunity to do hands-on sessions at your own desk, during a 12 hour period.
As an attendee, you get to select three hands-on sessions to do virtually. Today I did EA360, SAP HANA Features and Performance with SAP BusinessObjects BI Solutions. This covered the Information Design Tool, Web Intelligence and Crystal Reports for Enterprise.
As I am not an expert in any of these areas it was a good chance to learn how these solutions work with SAP HANA and In-Memory Business Data Management
I think it helps to have some experience or background in these tools, as the steps in the exercises don’t necessarily always match what you see in the system, but if you have some familiarity, you can get by like I did.
First using the Information Design Tool I created a HANA universe based on two HANA Analytic views:
Then you activate query stripping to help improve performance:
I learned you can do this in the business layer of the IDT
Then you can go to Web Intelligence to report against this HANA Universe as shown above.
The activity also walks you through Navigation Paths, something I haven’t done before.
The next exercise is using Crystal Reports not against a universe (as I was expecting) but reporting against an OLAP connection.
First I created the OLAP connection in the Information Design Tool:
You can specify a cube or not as shown above. You publish the OLAP connection.
Then launch Crystal Reports for Enterprise:
You use a HANA view as a data source.
What is interesting here, to me, according to the exercise is that the business layer is generated within Crystal Reports.
So I learned a lot today, I made it through exercises using tools I was not familiar with – this is such a nice feature of TechEd (now dcode) and something for you to consider attending this year in person.