Member Formula on 2 dimensions

[former_member214044]

Hi...

We are using BPC 10.0 SP 10 on 801 with HANA DB release 1.00.095.

ENABLE_HANA_MDX is X and i can see from UJSTAT that BPC MDX is being processed in HANA.

We have member formula on our Account and DataSource dimensions.

The DataSource member formula is:

DS_CALC_MEMBER = ([DATASOURCE].[DS_TOTAL],[MEASURES].[PERIODIC])

The Account member formula is:

AC_CALC_MEMBER = [EBIT] - [TOT_DEPN]

both EBIT and DEPN are Account members.

on there own DS_CALC_MEMBER and AC_CALC_MEMBER work perfectly well.

But if a report contains both, then we get the below error back to EPM when we refresh.

Is there something that we are missing???

Best Regards

Bad request.

Server message:

code: SY_530

severity: error

description: An exception has occurred

log id: LLuHCwDS2L3X08002WO26G

DATAVALUE:

MDX:

V1:

V2:

V3:

V4:

-----------------code: UJO_READ_EXCEPTION_000

severity: error

description: An exception has occurred

log id: LLuHCwDS2L3X08002WO26G

DATAVALUE:Internal error : no result set

MDX:

V1:

V2:

V3:

V4:

-----------------code:

severity:

description: An exception has occurred

log id: LLuHCwDS2L3X08002WO26G

CONNECTION_CLOSED:

DBOBJECT_EXISTS:

DBOBJECT_NOT_EXISTS:

DB_ERROR:X

DUPLICATE_KEY:

EXTERNAL_ERROR:

INTERNAL_ERROR:1

INVALID_CURSOR:

SQL_CODE:9300-

SQL_MESSAGE:Internal error : no result set

UNKNOWN_CONNECTION:

-----------------

Framework message:

The remote server returned an error: (400) Bad Request.

The remote server returned an error: (400) Bad Request.

[former_member424490]

Hi Mike,

Can you solve this issue? Do you remember what is the solution?

[dinesh_veluru]

Hi Mike,

Please check below note.

1673094 - Error in EPM add-in when running reports: UJO_READ_EXCEPTION_000

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

Thanks,

Dinesh.v

[former_member214044]

Thanks Dinesh

But we are hitting a different issue - our error code is SY_530 and we are running BW 7.31 on HANA.

Looking again at UJSTAT it looks like EPM isn't even getting as far as running an MDX statement???

Regards

Mike

[former_member186498]

Hi Mike,

have you seen the notes about SY_530 error code and HANA? See also this note 1958603 - Analyze HANA MDX problems in Planning and Consolidation 10.0 NW

Regards

     Roberto