Analysis for Office on HANA Analytic View

[Former Member]

Hi,

when i try to open an Analytic View, selecting an OLAP connection created on CMC, an MDX error is generated:

Unable to execute SQL statement (GET_CHARACTERISTICS) \: MDX SELECT "DIMENSION_UNIQUE_NAME", "COLUMN_NAME", "COLUMN_TYPE_D", "COLUMN_SQL_TYPE", "DESC_NAME", "DIMENSION_COLUMN_NAME", "DIMENSION_DESC_NAME", "COLUMNOBJECT_NAME", "DESC_TYPE", "DESC_TYPE_D", "DESC_COLUMN_SQL_TYPE", "KEY_COLUMN_NAME", "COLUMN_CAPTION", "DISPLAY_COLUMN_NAME", "DIMENSION_CAPTION", "CUBE_NAME", "CATALOG_NAME", "DIMENSION_TYPE", "IS_PRIVATE_ATTRIBUTE" FROM BIMC_DIMENSION_VIEW  WHERE ( "CUBE_NAME" ='SD_AN_VIEW' AND "CATALOG_NAME" = 'sd_h' AND "DIMENSION_UNIQUE_NAME" <> '[Measures]'  )   ORDER BY "KEY_COLUMN_NAME"  DESC   (ERROR [42000] [SAP AG][LIBODBCHDB32 DLL][HDB] Syntax error or access violation;257 sql syntax error: ERROR - DimensionViews Rowset command failed  at IS_PRIVATE_ATTRIBUTE)

Thanks.

Andrea

[Former Member]

I was have same problem, and followed Tammy Powlas's advice, I re-installed the sobp analysis office, version is 1.3 not 1.4. Because My HANA system is 1.0 sp5. Now analysis office tool can show the HANA information views.

[TammyPowlas]

Hello Andrea,

Would you please see SAP Note 1944465 - downward compatibility in BICS for hana data base and see if it applies to you and your situation?

Tammy

[Former Member]

Hi Tammy,

sorry but it's not my case.

I'm using BI 4.0 SP8 with HANA SP7 and Analysis for Office is 1.4 SP6.

Thank you very much.

Best Regards.

Andrea

[Former Member]

I solved the issue reinstalling Analysis For Office 1.4 without the option "Enabling 1.4 features".