Skip to Content
avatar image
Former Member

Webi to HANA calculation view MDX error

Dear SAP Gurus,

In WEBI & Anlysis office I’m facing MDX error when connecting to “STAR JOIN” calculation view created in HDI container.

Environment :

HANA 2 SPS 02 Patch 3 ( Build 4.2.20 )

SAP Business Objects BI Platform 4.2 Support Pack 4 Patch 1 Version: 14.2.4.2464

I have created a simple calculation view with Sales fact table and star joined it with “Material” dimension which is also created in same HDI ontainer. When I see the data preview the calc view data is showing for the Materials details (which are in Sales fact table).

When I connect to above view from WEBI .

  • i.If don’t include material in the query No issues- I can run query
  • ii.If I include Material in the query I’m getting following error

ErrorCode: 256 Description: sql processing error: Error occurred while executing a MDX statement. The error message is: An internal error occurred. Assertion failed with error message Hierarchy cache reference is invalid for (Material].( Material] : Hierarchy cache error:Hierarchy create error “HDI_CONAINER"."models:: Material /hier/ Material "error: No error Source: (Error: INF )

star-join.png (54.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 08 at 01:49 PM

    Hello Santosh,

    please re logon on HANA and WEBI try again, else still your facing the same issue, need to implement the Note.

    Place check below link and login in to market place for more Information.

    https://apps.support.sap.com/sap/support/knowledge/preview/en/2420295

    Thank You,

    Sathya.

    Add comment
    10|10000 characters needed characters exceeded