Skip to Content

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:

1universerefresh.PNG

Then you activate query stripping to help improve performance:

2querystripping.PNG

I learned you can do this in the business layer of the IDT

3webihanaquery.PNG

Then you can go to Web Intelligence to report against this HANA Universe as shown above.

4navigationpaths.PNG

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:

1olapconnectioninidt.PNG

You can specify a cube or not as shown above.  You publish the OLAP connection.

Then launch Crystal Reports for Enterprise:

2crystal.PNG

You use a HANA view as a data source.

3generates hana business layer.PNG

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.

Related Links:

SAP TechEd Virtual Hands-on Workshops

Sharing the Knowledge – SAP TechEd Get to Know the Real-Time Analytics Platform with SAP HANA Live

Interested in learning more?  BI 2014 in March has some HANA with BI sessions.  I also hope you consider attending ASUG Annual Conference June 3-5 in Orlando.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply