Error UJO_READ_EXCEPTION_018 refresh EXCEL

[Former Member]

Hi Experts,

While refresh report, I get the attached error message saying 'UJO_READ_EXCEPTION_018'.

The Remote server returned error. (400) Bad Request.

Could you please let me know how to resolve this?

BW and BPC version:

Error message:

One or more errors occurred.

The execution of report Informe predeterminado failed. Please contact your administrator.
Bad request.

Server message:

code: UJO_READ_EXCEPTION_018
severity: error
description: MDX statement error: Syntax error: Syntax Error : ..., row 55.876, item: 55.876
log id: 051Mi6E07jYWajmoowcx3m
DATAVALUE:Syntax error: Syntax Error : ..., row 55.876, item: 55.876
MDX: SELECT NON EMPTY {[/CPMB/ZSDIQGX PARENTH1].[2018.TOTAL /CPMB/ZSDIQGX] ,[/CPMB/ZSDIQGX PARENTH1].[2018.01] ,[/CPMB/ZSDIQGX PARENTH1].[2018.02] ,[/CPMB/ZSDIQGX PARENTH1].[2018.03] ,[/CPMB/ZSDIQGX PARENTH1].[2018.04] ,[/CPMB/ZSDIQGX PARENTH1].[2018.05] ,[/CPMB/ZSDIQGX PARENTH1].[2018.06] ,[/CPMB/ZSDIQGX PARENTH1].[2018.07] ,[/CPMB/ZSDIQGX PARENTH1].[2018.08] ,[/CPMB/ZSDIQGX PARENTH1].[2018.09] ,[/CPMB/ZSDIQGX PARENTH1].[2018.10] ,[/CPMB/ZSDIQGX PARENTH1].[2018.11] ,[/CPMB/ZSDIQGX PARENTH1].[2018.12] } * {[/CPMB/ZSDJRVE PARENTH1].[C400100 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500311T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500314T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500317 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500318T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500320T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500370 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500371T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500380 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500381 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500382T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500384 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500385 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500389T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500400T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500402T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500403T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500404T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500405T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500406T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500408T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500409T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500410T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500421 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500422 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500430T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500431T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500433T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500436T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500440T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500441T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500461T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500501T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500502T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500505 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500506T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[CTO_FINANC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[DIF_CAMB /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[GAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[GCPEACTOPE /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[GCPEANTIMP /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[GCPEOPCONT /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[GTOIMPGCIA /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[ING_ACT_ORD /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[ING_FINANC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[OTRAS_PERD_GANAN /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[OTROS_ING /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[OTRO_GTOXFUNC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAREQUPRPCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAREQUTERCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAARREQUIPCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAARRINMBCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAARRINMBGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAARRINMUGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAASESGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAASESIACV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUDITGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUTORCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUTORCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUTORGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUTORGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSABSCOMGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACIPERSCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACMRCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACMRGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACMRGAV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOMISCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTOFCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTOFCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTSEGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTSEGCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTSEGCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTSEGGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADEMURRAGCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADEPAMORCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADEPAMORGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADEPAMORGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADIFPREC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADONACGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOADMBACKOFFICEGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOADMGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOBANCGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOBANCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOISOGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOOFGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOOFGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOPROYGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTORECH /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTORECHCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTORECHGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAINGRESOS /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAINRCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAINRGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAINRGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAIVACV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAIVAGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMARKCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMARKGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMARKGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMATOPERCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMGBRUTO /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMGOPERAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAOTCOSPGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAOTGTORHGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPARTSAAMCL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPEREJECGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERGRALGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSAAMGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSSAAMCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSSAAMCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSTERCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSTERCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERTERGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERTERGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPROVGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPROYECTOCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPSGRALGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPSSAAMGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSARSTDOCTBLE /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASISCOMCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASISCOMGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASISTCOMGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSADMCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSADMGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSAGMACV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSBASICGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSBASICGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSBASICV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSDYMCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSFLOTACV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSINPERGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSINSPERCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSINSPERCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSINSPGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSLOGCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSOPERCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSPORTCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSTRANSCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSTRANSGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSATOTCTOS /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSATRANSPCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAVALLIQGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAVEAS /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[RES_UNI_REAJ /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[VP /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C400100C] ,[/CPMB/ZSDJRVE PARENTH1].[C400100I] ,[/CPMB/ZSDJRVE PARENTH1].[C500200] ,[/CPMB/ZSDJRVE PARENTH1].[C500301] ,[/CPMB/ZSDJRVE PARENTH1].[C500302] ,[/CPMB/ZSDJRVE PARENTH1].[C500303] ,[/CPMB/ZSDJRVE PARENTH1].[C700508] ,[/CPMB/ZSDJRVE PARENTH1].[C700509] ,[/CPMB/ZSDJRVE PARENTH1].[C700510] ,[/CPMB/ZSDJRVE PARENTH1].[C700511] ,[/CPMB/ZSDJRVE PARENTH1].[C700512] ,[/CPMB/ZSDJRVE PARENTH1].[C700520] ,[/CPMB/ZSDJRVE PARENTH1].[C700521] ,[/CPMB/ZSDJRVE PARENTH1].[C700530] ,[/CPMB/ZSDJRVE PARENTH1].[C700531] ,[/CPMB/ZSDJRVE PARENTH1].[C700532] ,[/CPMB/ZSDJRVE PARENTH1].[C700534] ,[/CPMB/ZSDJRVE PARENTH1].[C700535] ,[/CPMB/ZSDJRVE PARENTH1].[C700537] ,[/CPMB/ZSDJRVE PARENTH1].[C700540] ,[/CPMB/ZSDJRVE PARENTH1].[C700541] ,[/CPMB/ZSDJRVE PARENTH1].[C700542]...................................................................................................................,[/CPMB/ZSDJRVE PARENTH1].[C9000403] ,[/CPMB/ZSDJRVE PARENTH1].[C9000404] ,[/CPMB/ZSDJRVE PARENTH1].[C9000405] ,[/CPMB/ZSDJRVE PARENTH1].[C9000406] ,[/CPMB/ZSDJRVE PARENTH1].[C9000407] ,[/CPMB/ZSDJRVE PARENTH1].[C990000] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUDITCV] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACIPERSCV] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSGRALCV] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASISCOMCV] } ON 0 from [$/CPMB/ZSMMMOH] WHERE ( [Measures].[/CPMB/SDATA] ,[/CPMB/ZSDN624 PARENTH1].[AG_ALL /CPMB/ZSDN624] ,[/CPMB/ZSDZF58 PARENTH1].[AuditTotal /CPMB/ZSDZF58] ,[/CPMB/ZSDKSFY PARENTH1].[SAAM_CC /CPMB/ZSDKSFY] ,[/CPMB/ZSDMQ48 PARENTH11].[SIN_CLI] ,[/CPMB/ZSDM28D PARENTH2].[SEG_NA /CPMB/ZSDM28D] ,[/CPMB/ZSDIHWJ PARENTH1].[S_MON] ,[/CPMB/ZSDOM2S PARENTH1].[LC] ,[/CPMB/ZSDPFYF].[SAAM] ,[/CPMB/ZSDVHVY].[Plan] ,[/CPMB/ZSDTQXZ].[NA] )
V1:Syntax error: Syntax Error : ..., row 55.876, item
V2:: 55.876
V3:
V4:

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

Framework message:
Error en el servidor remoto: (400) Solicitud incorrecta.

Error en el servidor remoto: (400) Solicitud incorrecta.

Regards,

Pedro Cueva

[Former Member · Accepted solution]

This SAP note resolved the issue:

2183923 - MDX: Termination when function ABS used

[SeerOfSig]

Can be many reasons.

Is this a new or existing report?

Did the refresh work correctly previously and suddenly generate this error?

Does issue only occur for one report or all reports?

Does it occur for only one model or all models?

If you have multiple environments, does it occur in all environments?

Are you using HANA MDX?

If no, does the error occur when executing the MDX query directly in MDXTEST?

If yes, does the error occur when executing the MDX query directly in UJHANAMDX or Run UJHANA_MDX_TEST in SE38

[Former Member]

Thanks Peter.

Answers:

Is this a new or existing report?
- Is a existing report.

Did the refresh work correctly previously and suddenly generate this error?
- After update BPC 10.0 to 10.1 and BW 7.3 to BW 7.5 on HANA

Does issue only occur for one report or all reports?
- Many reports, not all.

Does it occur for only one model or all models?
- Two models.

If you have multiple environments, does it occur in all environments?
- Multiple environments

Are you using HANA MDX?
- Yes.

If no, does the error occur when executing the MDX query directly in MDXTEST?

If yes, does the error occur when executing the MDX query directly in UJHANAMDX or Run UJHANA_MDX_TEST in SE38
- Yes, the error occur when executing the MDX query directly in UJHANAMDX.

Regards,

Pedro Cueva

[former_member186338]

Please show screenshot of your time dimension...

[SeerOfSig]

There may be some BW notes to apply. Can you please let me know what SP of BW 7.5 you are using (and confirm that you are on BW 7.50 and not 7.51). There may be notes that will come up if you search for this error plus BW 7.50.

Regards,

Peter Kreutlein

[Former Member]

Hi Peter,

BW 7.50 and SP 9

Regards,

Pedro Cueva

[former_member186338]

Time dimension, please!

[Former Member]

Hi Vadim ,

[former_member186338]

Members????????????????

[Former Member]

Hi Vadim ,

[Former Member]

Hi Peter,

BW 7.50 and SP 9

Regards,

Pedro Cueva

[former_member186338]

Second hierarchy in TIME dimension is not supported! Remove it!

[Former Member]

Hi Vadim, I removed it but don't work

[former_member186338]

"don't work" - is not a description, please provide details!

[Former Member]

Hi Vadim.

1. I deleted the second hierarchy (PARENTH2) in TIME dimension
2. I pressed "Save and Process" in TIME dimension
3. I executed the report and I get the attached error message:

code: UJO_READ_EXCEPTION_018
severity: error
description: MDX statement error: Syntax error: Syntax Error : .../ZSDMQ48] ,[/CPMB/ZSDTQXZ].[NA], row 56.026, item: 56.026
log id: 051Mi6E07kYXa1mWnmFdnG
DATAVALUE:Syntax error: Syntax Error : .../ZSDMQ48] ,[/CPMB/ZSDTQXZ].[NA], row 56.026, item: 56.026
MDX: SELECT NON EMPTY {[/CPMB/ZSDIQGX PARENTH1].[2018.TOTAL /CPMB/ZSDIQGX] ,[/CPMB/ZSDIQGX PARENTH1].[2018.01] ,[/CPMB/ZSDIQGX PARENTH1].[2018.02]....................................................................

V1:Syntax error: Syntax Error : .../ZSDMQ48] ,[/CPMB/
V2:ZSDTQXZ].[NA], row 56.026, item: 56.026
V3:
V4:
-----------------
Framework message:
Error en el servidor remoto: (400) Solicitud incorrecta.
Error en el servidor remoto: (400) Solicitud incorrecta.

[former_member186338]

"I deleted the second hierarchy (PARENTH2) in TIME dimension" - how? details? please! Resulting screenshot!