Skip to Content

During my assignment at the HANA War Room, I stumbled upon this restriction in Analysis for Office 1.2 when connecting to HANA via ODBC. Let’s assume you have the created the following data model,

Pic1.png

Contribution Margin 1 are based on Net Revenue, which is also a calculation,

Pic2.png

Pic3.png

The following screen shot showing Contribution Margin 2, which is calculated based on Contribution Margin 1,

Pic4.png

Pic5.png

The following screen shot showing Contribution Margin 2, which is calculated based on Contribution Margin 1,

Pic6.png

Now, try to report on this model from SAP Analysis for Office 1.2 and you will get an error as soon as you drag any characteristic into the report,

Pic7.png

When you drag KUNNR into the Rows section, an error occur,

Pic8.png

If you drag out all Calculated/Restricted measures, the report will work without error,

Pic9.png

If you run the same query in the Studio with the calculated measures, then it will work fine,

Pic10.png

SELECT “KUNNR”, SUM(“GrossRevenue”), SUM(“CM1”) from “_SYS_BIC”.”i805724/CEA1_MJ” GROUP BY “KUNNR”

SAP Analysis of Office 1.2 doesn’t handle cascading measures, which will require modeling the data differently for Analysis.

Now, let’s change the data model and calculate CM1 and CM2 from the base measures,

Pic11.png

Pic12.png

Only in this case, the report in Analysis works,

Pic13.png

To report this post you need to login first.

2 Comments

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

  1. Mohamed Judi Post author

    Just a quick update to the issue outlined in this blog. As of HANA Rev. 62 (including Client), this is not an issue anymore. Make sure you have the latest front-end tool version such as SAP Analysis for Office 1.4 SP03.

    Thanks,

    MJ

    (0) 

Leave a Reply