$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
avatar image
Former Member

Unable to calculate CAL_YTD as Calendar wise

Hi experts, I need help with the below (custom) code.

MEMBER [MEASURES].[CAL_YTD] AS 'IIF(([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC" OR [%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP"), [MEASURES].[CAL_YTD_MTH],IIF([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/NKPDM4H")="1",[MEASURES].[CAL_YTD_MTH],

IIF([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/NKPDM4H") ="2",SUM({[%TIME%].LAG(1):[%TIME%].CURRENTMEMBER},[MEASURES].[CAL_YTD_MTH]),IIF([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/NKPDM4H")="3",SUM({[%TIME%].LAG(2):[%TIME %].CURRENTMEMBER},[MEASURES].[CAL_YTD_MTH]),IIF([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/NKPDM4H")="4",SUM({[%TIME%].LAG(3):[%TIME%].CURRENTMEMBER},[MEASURES]. [CAL_YTD_MTH]),IIF([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/NKPDM4H")="5",SUM({[%TIME%].LAG(4):[%TIME%].CURRENTMEMBER},[MEASURES].[CAL_YTD_MTH]),IIF([%TIME %].CURRENTMEMBER.PROPERTIES("2/CPMB/NKPDM4H")="6",SUM({[%TIME%].LAG(5):[%TIME%].CURRENTMEMBER},[MEASURES].[CAL_YTD_MTH]),IIF([%TIME%].CURRENTMEMBER.PROPERTIES ("2/CPMB/NKPDM4H")="7",SUM({[%TIME%].LAG(6):[%TIME%].CURRENTMEMBER},[MEASURES].[CAL_YTD_MTH]),IIF([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/NKPDM4H")="8",SUM({[%TIME %].LAG(7):[%TIME%].CURRENTMEMBER},[MEASURES].[CAL_YTD_MTH]),IIF([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/NKPDM4H")="9",SUM({[%TIME%].LAG(8):[%TIME%].CURRENTMEMBER}, [MEASURES].[CAL_YTD_MTH]),IIF([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/NKPDM4H")="10",SUM({[%TIME%].LAG(9):[%TIME%].CURRENTMEMBER},[MEASURES].[CAL_YTD_MTH]),IIF ([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/NKPDM4H")="11",SUM({[%TIME%].LAG(10):[%TIME%].CURRENTMEMBER},[MEASURES].[CAL_YTD_MTH]),IIF([%TIME %].CURRENTMEMBER.PROPERTIES("2/CPMB/NKPDM4H")="12",SUM({[%TIME%].LAG(11):[%TIME%].CURRENTMEMBER},[MEASURES].[CAL_YTD_MTH]),[MEASURES].[CAL_YTD_MTH])))))))))))))' SOLVE_ORDER=3

While am selecting CAL_YTD as calendar wise, it’s not accumulating. It should accumulate all calendar Year.

Requirement:-

The values showing in CAL_YTD_MTH should get accumulated (added) in to CAL_YTD.

Eg : Jan+Feb –> 3567302.9+ 2753165.4= 6320468.29

In CAL_YTD should appear this value 6320468.29 in February month. Please see below screenshot.

Can you please help to resolve this issue. Is there change required in Code

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 22, 2016 at 05:11 PM

    You primary tag for this question is incorrect, has to be

    SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

    And please describe the logic you want to achieve including screenshot of time dimension and calculation sample in Excel!

    Add comment
    10|10000 characters needed characters exceeded