Skip to Content
Author's profile photo Mohamed Judi

HANA Calculated/Restricted Measures based on other Calculated/Restricted Measures in SAP Analysis for Office 1.2

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

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mohamed Judi
      Mohamed Judi
      Blog 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

      Author's profile photo Former Member
      Former Member

      Hi MJ,

      Thanks for sharing 🙂 🙂 🙂 with screen shots its really helpful. 😆 😆

      Regards,

      Giri