Skip to Content
avatar image
Former Member

Periodic repport failure

Hi Bpc Friends

There is something strange in BPC Dev.

If I run a report with measure YTD (the model is YTD) everything is fine, but if I run the same report with measure periodic I get the following error:

I have compared the formula perodic in Dev with Quality and it is exactly the same
8xmjv.png (13.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 14, 2017 at 08:05 AM

    Please provide details about bpc and bw version and sp!

    What is the server message?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      the details about bpc and bw are

      the error message is

      One or more errors occurred.
      The execution of report Default Report failed. Please contact your administrator.
      Bad request.

      Server message:

      code: UJO_READ_EXCEPTION_018
      severity: error
      description: MDX statement error: Syntax error: Syntax Error : ... PARENTH1].[LEVEL01])))' SOLVE_, row 378, item: 378
      log id: 051Ma3NS7kUKcwPN86CtbW
      DATAVALUE:Syntax error: Syntax Error : ... PARENTH1].[LEVEL01])))' SOLVE_, row 378, item: 378
      MDX: WITH MEMBER [Measures].[YTD] AS 'IIF(([/CPMB/G3DFBM3 PARENTH1].[2/CPMB/ACCTYPE]="INC" OR [/CPMB/G3DFBM3 PARENTH1].[2/CPMB/ACCTYPE]="LEQ"),-([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/G3D094P PARENTH1].[LEVEL01])), ([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/G3D094P PARENTH1].[LEVEL01])))' SOLVE_ORDER=3##MEMBER [Measures].[PERIODIC] AS 'IIF(([/CPMB/G3DFBM3 PARENTH1].[2/CPMB/ACCTYPE]="INC" OR [/CPMB/G3DFBM3 PARENTH1].[2/CPMB/ACCTYPE]="EXP") AND NOT ([/CPMB/G3D094P PARENTH1].[2/CPMB/PERIOD]="TOTAL" OR [/CPMB/G3D094P PARENTH1].[2/CPMB/PERIOD]="Q1" OR [/CPMB/G3D094P PARENTH1].[2/CPMB/PERIOD]="MAY" ), [Measures].[YTD]-([Measures].[YTD],[/CPMB/G3D094P PARENTH1].LAG(1)), [Measures].[YTD])' SOLVE_ORDER=3 SELECT NON EMPTY {[/CPMB/G3D094P PARENTH1].[FY2014.002] ,[/CPMB/G3D094P PARENTH1].[FY2015.002] } * {[/CPMB/G3DSW6W].[ACTUAL] ,[/CPMB/G3DSW6W].[BUDGET] } * {[/CPMB/G3DFBM3 PARENTH1].[CBOOTH /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[COGS1 /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[COGS2 /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[COMMREC /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[DIVGIFTAID /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[EANDO /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[EVENDORSALES /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[FADISPOSAL /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[FREIGHTIN /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[FXGAINLOSS /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[GM_ONE /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[GM_TWO /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[GWILLAMORT /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[IBTSALES /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[ICO_COMM /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[ICO_IP /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[IMPAIRMENTS /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[INVESTINC /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[JVSHARE_TOT /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[MGMNTFEES /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[MININT_TOT /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[NETCONT /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[NIR /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[OPSCONT /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[OPSCONT_AFTER /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[OTHCOGS /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[OTHINCEXP /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[PERMI_SALE /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[PLBEFUS /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[PPRESSAMORTN /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[RETURNS /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[RIGHTSEXP /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[RIGHTS_SALE /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[ROYALTIES /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[SALESDOM /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[SOCCOMM /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[STKADJS /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[STRAT_INV /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[TAXATION /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[TOT_OPEX /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[TOT_SALES /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[WIPADJS /CPMB/G3DFBM3] ,[/CPMB/G3DFBM3 PARENTH1].[ESOLPRF] ,[/CPMB/G3DFBM3 PARENTH1].[PL4100] ,[/CPMB/G3DFBM3 PARENTH1].[PL4130] ,[/CPMB/G3DFBM3 PARENTH1].[PL4135] } * {[/CPMB/G3DWVYF PARENTH1].[ALL_COSTCATS /CPMB/G3DWVYF] ,[/CPMB/G3DWVYF PARENTH1].[CG_BUSSUPP_T /CPMB/G3DWVYF] ,[/CPMB/G3DWVYF PARENTH1].[CG_DIST_T /CPMB/G3DWVYF] ,[/CPMB/G3DWVYF PARENTH1].[CG_FLHR_T /CPMB/G3DWVYF] ,[/CPMB/G3DWVYF PARENTH1].[CG_PE_T /CPMB/G3DWVYF] ,[/CPMB/G3DWVYF PARENTH1].[CG_SM_T /CPMB/G3DWVYF] ,[/CPMB/G3DWVYF PARENTH1].[CG_FACILITIES] ,[/CPMB/G3DWVYF PARENTH1].[CG_GENMNG] ,[/CPMB/G3DWVYF PARENTH1].[CG_PENSIONS] ,[/CPMB/G3DWVYF PARENTH1].[CG_TECHNOLOGY] ,[/CPMB/G3DWVYF PARENTH1].[NO_COSTCAT] } ON 0 from [$/CPMB/G3MS9NK] WHERE ( [Measures].[PERIODIC] ,[/CPMB/G3D3MOO PARENTH1].[ALL_CHANNELS /CPMB/G3D3MOO] ,[/CPMB/G3DSK0Q PARENTH1].[F_CLO] ,[/CPMB/G3DMM41].[LC] ,[/CPMB/G3DXF9P PARENTH1].[T_COMP /CPMB/G3DXF9P] ,[/CPMB/G3DRFWE PARENTH1].[TOTAL_INTERCO /CPMB/G3DRFWE] ,[/CPMB/G3DPKB4 PARENTH1].[DEFAULT] ,[/CPMB/G3DE6QS].[G_NONE] ,[/CPMB/G3DZ7Q5 PARENTH1].[ALL_PRODGRPS /CPMB/G3DZ7Q5] )
      V1:Syntax error: Syntax Error : ... PARENTH1].[LEVEL0
      V2:1])))' SOLVE_, row 378, item: 378
      V3:
      V4:

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

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

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

      juuav.png (10.9 kB)
  • Jun 14, 2017 at 08:52 AM

    The error like this often happen on the old BPC and BW SP's. And it's not an easy job to find the exact note...

    I recommend to upgrade to the latest SP for BPC and BW.

    P.S. If you search notes for: UJO_READ_EXCEPTION_018

    you will see 30 related notes...

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 14, 2017 at 08:50 AM

    Hi Michele,

    Open the report and check once the below:

    EPM >>> Options >>> Context Options >>> Context Lock.

    Check for dimension MEASURES that the same is not locked on YTD parameter.

    Thanks,

    Karan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      no it isn't locked

      if I run for measure=ytd it will be ok while if I run for measure=periodic it will fail