当前数据为空时,使用以前的期间值填充数据

2020-08-21 13:52发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


尊敬的专家

型号/应用程序详细信息:

SAP BusinessObjects EPM,Microsoft Office加载项

版本10.0 SP 25 Patch2 .NET4

CPMBPC版本800,SP级0021支持软件包SAPK-80021INCPMBPC

组件:SAP_BW

发布740

SP级:0020

支持软件包SAPKW74020

尺寸列表

ACCOUNT_PL(帐户),时间,版本(实际/计划/预测),公司,DATASOURCE,FOCUS(能力中心/业务线),MEASURE,RPTCURRENCY,TERM(合同寿命),PARTNER(客户群), 供应商(供应商)。

脚本:由 DM程序包

启动

计算引擎JAVASCRIPT。

我要做什么:

当数据集已经包含某个值时,脚本应保留该值;如果数据集为null,则脚本应写入上一个期间的值。

 * SELECT(%FIRST_PLAN_PERIOD%,[PLANNING_PERIOD],VERSION,[ID] =%VERSION_SET%)
 * SELECT(%FIRST_PLAN_PERIOD_TIMEID%,[TIMEID],TIME,[ID] =%FIRST_PLAN_PERIOD%)
 * SELECT(%TIDL%,[TIMEID],TIME,TIMEID <%FIRST_PLAN_PERIOD_TIMEID%)
 * SELECT(%LAST_ACTUAL_MONTH%,[ID],TIME,TIMEID> =%TIDL%AND TIMEID <%FIRST_PLAN_PERIOD_TIMEID%)
 * SELECT(%Y%,[YEAR],TIME,ID =%FIRST_PLAN_PERIOD%)
 * SELECT(%TIDDEC%,[TIMEID],TIME,YEAR =%Y%AND MONTHNUM = 12 AND CALC = N)
 * SELECT(%TIDG%,[TIMEID],TIME,TIMEID>%TIDDEC%)
 * SELECT(%NEXTYEAR%,[YEAR],TIME,TIMEID>%TIDDEC%和TIMEID <=%TIDG%)
 * SELECT(%TIDDEC1%,[TIMEID],TIME,YEAR =%NEXTYEAR%AND MONTHNUM = 12 AND CALC = N)
 * SELECT(%TIDG1%,[TIMEID],TIME,TIMEID>%TIDDEC1%)
 * SELECT(%NEXT2YEAR%,[YEAR],TIME,TIMEID>%TIDDEC1%AND TIMEID <=%TIDG1%)
 * SELECT(%TIDDEC2%,[TIMEID],TIME,YEAR =%NEXT2YEAR%AND MONTHNUM = 12 AND CALC = N)
 * SELECT(%TIDG2%,[TIMEID],TIME,TIMEID>%TIDDEC2%)
 * SELECT(%NEXT3YEAR%,[YEAR],TIME,TIMEID>%TIDDEC2%AND TIMEID <=%TIDG2%)
 * SELECT(%TIDDEC3%,[TIMEID],TIME,YEAR =%NEXT3YEAR%AND MONTHNUM = 12 AND CALC = N)
 * SELECT(%TIDG3%,[TIMEID],TIME,TIMEID>%TIDDEC3%)
 * SELECT(%NEXT4YEAR%,[YEAR],TIME,TIMEID>%TIDDEC3%AND TIMEID <=%TIDG3%)
 * SELECT(%LAST_PLAN_PERIOD_TIMEID%,[TIMEID],TIME,[YEAR] =%NEXT4YEAR%AND MONTHNUM = 12)
 * SELECT(%HOR%,[ID],TIME,TIMEID> =%FIRST_PLAN_PERIOD_TIMEID%AND ID <=%NEXT4YEAR%.12 AND CALC = N)

 * XDIM_MEMBERSET VERSION = VE_FORECAST
 * XDIM_MEMBERSET COMPANY = CO_0530006
 * XDIM_MEMBERSET TIME =%LAST_ACTUAL_MONTH%,%HOR%
 * XDIM_MEMBERSET ACCOUNT_PL = AC_ZRT00543
 * XDIM_MEMBERSET FOCUS = BAS(FO_FV)
 * XDIM_MEMBERSET PARTNER = PA_P1,PA_P2,PA_P3,PA_P4,PA_P5,PA_P10
 * XDIM_MEMBERSET TERM = TE_1,TE_2,TE_3,TE_4,TE_5,TE_6
 * XDIM_MEMBERSET VENDOR = VN_1
 * XDIM_MEMBERSET DATASOURCE = DS_MANUAL
 *当ACCOUNT_PL
 *是AC_ZRT00543
 *对于%T%=%HOR%
 * REC(表达式=((%%%> 0?%VALUE%:[TIME]。[TMVL(-1,%T%)])),ACCOUNT_PL = AC_ZRT00543)
 *下一个
 *结束
 

能请你帮忙吗?

(43.6 kB)

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


尊敬的专家

型号/应用程序详细信息:

SAP BusinessObjects EPM,Microsoft Office加载项

版本10.0 SP 25 Patch2 .NET4

CPMBPC版本800,SP级0021支持软件包SAPK-80021INCPMBPC

组件:SAP_BW

发布740

SP级:0020

支持软件包SAPKW74020

尺寸列表

ACCOUNT_PL(帐户),时间,版本(实际/计划/预测),公司,DATASOURCE,FOCUS(能力中心/业务线),MEASURE,RPTCURRENCY,TERM(合同寿命),PARTNER(客户群), 供应商(供应商)。

脚本:由 DM程序包

启动

计算引擎JAVASCRIPT。

我要做什么:

当数据集已经包含某个值时,脚本应保留该值;如果数据集为null,则脚本应写入上一个期间的值。

 * SELECT(%FIRST_PLAN_PERIOD%,[PLANNING_PERIOD],VERSION,[ID] =%VERSION_SET%)
 * SELECT(%FIRST_PLAN_PERIOD_TIMEID%,[TIMEID],TIME,[ID] =%FIRST_PLAN_PERIOD%)
 * SELECT(%TIDL%,[TIMEID],TIME,TIMEID <%FIRST_PLAN_PERIOD_TIMEID%)
 * SELECT(%LAST_ACTUAL_MONTH%,[ID],TIME,TIMEID> =%TIDL%AND TIMEID <%FIRST_PLAN_PERIOD_TIMEID%)
 * SELECT(%Y%,[YEAR],TIME,ID =%FIRST_PLAN_PERIOD%)
 * SELECT(%TIDDEC%,[TIMEID],TIME,YEAR =%Y%AND MONTHNUM = 12 AND CALC = N)
 * SELECT(%TIDG%,[TIMEID],TIME,TIMEID>%TIDDEC%)
 * SELECT(%NEXTYEAR%,[YEAR],TIME,TIMEID>%TIDDEC%和TIMEID <=%TIDG%)
 * SELECT(%TIDDEC1%,[TIMEID],TIME,YEAR =%NEXTYEAR%AND MONTHNUM = 12 AND CALC = N)
 * SELECT(%TIDG1%,[TIMEID],TIME,TIMEID>%TIDDEC1%)
 * SELECT(%NEXT2YEAR%,[YEAR],TIME,TIMEID>%TIDDEC1%AND TIMEID <=%TIDG1%)
 * SELECT(%TIDDEC2%,[TIMEID],TIME,YEAR =%NEXT2YEAR%AND MONTHNUM = 12 AND CALC = N)
 * SELECT(%TIDG2%,[TIMEID],TIME,TIMEID>%TIDDEC2%)
 * SELECT(%NEXT3YEAR%,[YEAR],TIME,TIMEID>%TIDDEC2%AND TIMEID <=%TIDG2%)
 * SELECT(%TIDDEC3%,[TIMEID],TIME,YEAR =%NEXT3YEAR%AND MONTHNUM = 12 AND CALC = N)
 * SELECT(%TIDG3%,[TIMEID],TIME,TIMEID>%TIDDEC3%)
 * SELECT(%NEXT4YEAR%,[YEAR],TIME,TIMEID>%TIDDEC3%AND TIMEID <=%TIDG3%)
 * SELECT(%LAST_PLAN_PERIOD_TIMEID%,[TIMEID],TIME,[YEAR] =%NEXT4YEAR%AND MONTHNUM = 12)
 * SELECT(%HOR%,[ID],TIME,TIMEID> =%FIRST_PLAN_PERIOD_TIMEID%AND ID <=%NEXT4YEAR%.12 AND CALC = N)

 * XDIM_MEMBERSET VERSION = VE_FORECAST
 * XDIM_MEMBERSET COMPANY = CO_0530006
 * XDIM_MEMBERSET TIME =%LAST_ACTUAL_MONTH%,%HOR%
 * XDIM_MEMBERSET ACCOUNT_PL = AC_ZRT00543
 * XDIM_MEMBERSET FOCUS = BAS(FO_FV)
 * XDIM_MEMBERSET PARTNER = PA_P1,PA_P2,PA_P3,PA_P4,PA_P5,PA_P10
 * XDIM_MEMBERSET TERM = TE_1,TE_2,TE_3,TE_4,TE_5,TE_6
 * XDIM_MEMBERSET VENDOR = VN_1
 * XDIM_MEMBERSET DATASOURCE = DS_MANUAL
 *当ACCOUNT_PL
 *是AC_ZRT00543
 *对于%T%=%HOR%
 * REC(表达式=((%%%> 0?%VALUE%:[TIME]。[TMVL(-1,%T%)])),ACCOUNT_PL = AC_ZRT00543)
 *下一个
 *结束
 

能请你帮忙吗?

(43.6 kB)
付费偷看设置
发送
2条回答
me_for_i
1楼-- · 2020-08-21 14:18

"当数据集已经包含一些值时,脚本应离开 此值,如果数据集为null,则脚本应从 前一个时期。"-我认为这个想法是完全错误的。...

您将无法再运行一次脚本!

me_for_i
2楼-- · 2020-08-21 14:18
安娜·特卡霍瓦(Anna Tkachova)

当然可以,但是您必须详细说明业务案例!!! 数据集已经包含一些值,脚本应该离开 此值,如果数据集为null,则脚本应从 前一个时期。"-这不是业务案例描述。

一周热门 更多>