cancel
Showing results for 
Search instead for 
Did you mean: 

MDX QUERY - HANA STUDIO ERROR

former_member623
Participant
0 Kudos

HANA - 2.00.055.00.1615413201

BPC 10.1 BW 7.5 SP20

Trying to run a simple query (copied bpc query from SLG1)in hana studio but gives below error . is there any syntax error in below query? it erroring @mdx close stmt.

Error:

Could not execute 'mdx close request' in 7 ms 432 µs . SAP DBTech JDBC: [256]: sql processing error: ERROR - 'CLOSE REQUEST' is not a valid MDX request

Query:

set 'MDX_CURRENT_CATALOG'='$MDX';

MDX

MEMBER [Measures].[YTD] AS 'IIF(([/CPMB/DNDFTE7 PARENTH1].[2/CPMB/ACCTYPE]="INC" OR [/CPMB/DNDFTE7 PARENTH1].[2/CPMB/ACCTYPE]="LEQ"),-([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/DNDTXBJ PARENTH1].[LEVEL02])), ([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/DNDTXBJ PARENTH1].[LEVEL02])))' SOLVE_ORDER=3

SELECT NON EMPTY {[/CPMB/DNDFTE7 PARENTH1].[TOTAL_REVENUE /CPMB/DNDFTE7] } ON 0

from [$/CPMB/DNMTPPZ]

WHERE

( [Measures].[YTD], [/CPMB/DNDV3FS].[LC], [/CPMB/DNDEHSJ PARENTH1].[F_CLO], [/CPMB/DND4MPK PARENTH1].[I_ALL/CPMB/DND4MPK], [/CPMB/DNDYXQ9 PARENTH1].[TOTAL_MGMT /CPMB/DNDYXQ9], [/CPMB/DNDYHRJ PARENTH1].[ACTUAL], [/CPMB/DNDFZDK].[S_NONE], [/CPMB/DNDTXBJ PARENTH1].[2020.01], [/CPMB/DNDOWG0 PARENTH1].[PC1000 /CPMB/DNDOWG0] ) ;

mdx get_axisdata 0;

mdx get_axisdata 1;

mdx get_axisdata 255;

mdx get_celldata;

mdx close request;

Accepted Solutions (0)

Answers (2)

Answers (2)

hugo_amo
Active Contributor
0 Kudos

for possible workarounds, I would recommend to contact SAP Product Support component HAN-DB-MDX

hugo_amo
Active Contributor
0 Kudos

Hello Rekha,

This is a known issue that will be fixed in the next SAP HANA SPS5 revision, expected to be released in July.

Hugo

former_member623
Participant
0 Kudos

hi hugo,

we cannot run any MDX query on HANA studio in R2.00.055? or any specific format or member combination that doesnt work?

Thanks

Rekha