$(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
0

Unable to calculate CAL_YTD as Calendar wise

Oct 20, 2016 at 07:53 AM

41

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Nov 22, 2016 at 05:11 PM
0

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!

Share
10 |10000 characters needed characters left characters exceeded