Issue in Business Rule

[Former Member]

Hello Experts,

I am facing an issue while running Account Transformation Business Rule.

I have PRC dimension with Entity type and GMS is one of the member in it.

I want to run business rule only for the base level members of GMS, so for that I have written following Biz rule script logic:

*XDIM_MEMBERSET ZAUDIT as %A% = BAS(ALL_DATASOURCE)
*XDIM_MEMBERSET PRC as %C% = BAS(GMS)

*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = ACT
CURRENCY = SEK
TID_RA = %TIME_SET%
OTHER = [PRC=%C%;ZAUDIT=%A%]
CALC = EA_LOGIC
*ENDRUN_PROGRAM

But when I run the Data Manager on any other member then BAS(GMS), then too data gets posted.

Basically, the line in red doesnot accept BAS(GMS). If I write a base level member directly there like

*XDIM_MEMBERSET PRC  as %C% = P17005 (this is base level member)

then it work as expected.

So my concern is , is Business rule doesnot catch BAS(GMS)?

Regards,

Apoorva

[former_member186338 · Accepted solution]

Hi Apoorva,

Please test the script in UJKT (Execute Simulate) and post results here!

Vadim

P.S. Use some fixed TIME member for test.

[Former Member · Accepted solution]

Hello Vadim,

Here are the results:

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = ACT

CURRENCY = SEK

TID_RA = %TIME_SET%

OTHER = [PRC=P13365,P13364,P13363,P13362,P13361,P13359,P13358,P13357,P13356,P13355,P13354,P13353,P13352,P13351,P13350,P13310,P13006,P11412,P56320,P56120,P56328,P56317,P56128,P56117,P56314,P56114,P56313,P56113,DMDR_DUMMY,P13366,P13750,P13680,P13630,P13550,P13520,P13470,P13396,P13395,P13394,P13393,P13392,P13388,P13387,P13386,P13385,P13384,P13383,P13382,P13381,P13378,P13377,P13376,P13375,P13374,P13373,P13372,P13371,P13368,P13367,P13761,P13073,P13072,P13071,P13070,P13900,P13880,P13800,P13788,P13787,P13786,P13785,P13784,P13783,P13782,P13781,P13777,P13776,P13775,P13774,P13773,P13772,P13771,P13768,P13767,P13766,P13765,P13764,P13763,P13762,P13074,P13529,P13459,P13450,P13410,P13300,P13289,P13280,P13005,P56331,P56131,P12050,P12010,P56501,P11413,P11411,DMMG_DUMMY,P13198,P13197,P13196,P13195,P13194,P13193,P13192,P13191,P13190,P13078,P13077,P13076,P13075,P13540,P13694,P13693,P13692,P13691,P13620,P13586,P13585,P13584,P13583,P13582,P13581,P13576,P13575,P13574,P13573,P13572,P13571,P13566,P13565,P13564,P13563,P13562,P13561,P13556,P13555,P13554,P13553,P13552,P13551,P13695,P13080,P13048,P13047,P13046,P13045,P13044,P13042,P13040,P13029,P13020,P13850,P13839,P13836,P13835,P13834,P13833,P13832,P13831,P13830,P13828,P13827,P13826,P13825,P13824,P13823,P13720,P13709,P13700,P13696,P13180,P56333,P56200,P56141,P56134,P56133,P56502,P12070,P12060,P12055,P12030,P56604,P56603,P56601,P56600,P56504,P56503,P56500,P56404,P56403,P56400,P13259,P13256,P13255,P13254,P13253,P13252,P13251,P13250,P13200,P56334,P46010,DMRO_DUMMY,PG4118MS,P56118,P56311,P56111,P56309,P56109,DMPC_DUMMY,P56357,P56157,P56356,P56156,P12040,P56339,P56139,P12090,P12023,P12020,P12001,P56000,P56338,P56330,P56138,P56130,P12080,P12022,P12021,P56341,P46020,P46810,P48600,P48210,P48150,P46530,P46520,P46510,P46500,P46490,P46480,P46470,P46460,P46450,P46440,P46430,P46420,P46410,P46400,P46390,P46380,P46370,P46360,P46350,P46340,P46330,P46320,P46310,P46210,P46030,P46820,P14180,P14170,P14160,P14150,P14145,P14144,P14143,P14142,P14140,P14132,P14131,P14130,P14120,P14115,P14114,P14113,P14112,P14105,P14104,P14103,P14102,P14051,PG4333REG,P48110,P48030,P48020,P48010,P46840,P46830,P14190,P58330,P58215,P13214,P13015,P13715,P13705,P13595,P13545,P13535,P13525,P13515,P58195,P58320,P58310,P58210,PG3103DON,P58190,LPBS_DUMMY,PG4161CENTR,DMSU_DUMMY,P47210,P47080,P47070,P47060,P47050,P47040,P47030,P47020,P47010,P59030,P58220,P58240,P58150,LPED_DUMMY,P58410,P58400,LPCW_DUMMY,P11410,P58385,P58380,P58375,P58370,P58200,P58255,P58185,PG3122LC,P58250,P58230,P58180,P58170,P58160,P58140,P58130,P58120,P58110,P58000,LPCP_DUMMY,P59032,P59031,P58225,P11124,P11121,P11120,PACT_DUMMY,P58350,P58340,P58290,P58280,P58270,LPWA_DUMMY,LPSU_DUMMY,P13213,P13014,P13714,P13704,P13594,P13544,P13534,P13524,P13514,P57211,P57123,P57122,P57121,P57112,P57111,LPLS_DUMMY,P58360,P58260,P4414OC,P13600,P13570,P13420,P13390,P13370,P13345,P13344,P13341,P13335,P13334,P13331,P13325,P13324,P13321,P13316,P13315,P13312,P14052,P14050,P11313,P11312,P11311,P11310,P11406,P11403,P11402,P11401,P11400,PG4414CT,P13635,P13084,P13081,P13056,P13055,P13052,P13051,P13050,P13861,P13860,P13793,P13755,P13754,P13751,P13745,P13744,P13741,P13736,P13735,P13732,P13731,P13730,P13675,P13674,P13671,P13665,P13664,P13645,P13644,P13641,P13085,P14054,P13673,P13663,P13661,P13643,P13633,P13343,P13333,P13323,P13314,P11104,P11101,P11100,PAIS_DUMMY,P11306,P11305,P11303,P11302,P11301,P11300,P11320,P11000,P13235,P13234,P13231,P13226,P13225,P13221,P13220,P13734,P11133,P11132,P11131,P11130,P11129,P11128,P11127,P11126,P11125,P11111,P11109,P11108,P11105,P11138,P11137,P11136,P11135,P11110,P11103,P11102,P13233,P13223,P13083,P13054,P13821,P13820,P13792,P13753,P13743,P11134,P13758,P13756,P13752,P13746,P13742,P13737,P13733,P14055,P14053,P13678,P13676,P13672,P13666,P13662,P13660,P13646,P13642,P13636,P13634,P13632,P13346,P13342,P13336,P13332,P13328,P13326,P13322,P13317,P13313,P13791,P58614,P58613,P58612,P58611,P11123,P58617,P11122,P11405,P11404,P11205,P11202,PAMP_DUMMY,P11152,P11153,P11151,P11150,PAMA_DUMMY,P13238,P13236,P13232,P13227,P13224,P13222,P13086,P13082,P13057,P13053,P13864,P13794,P58615,P14039,P14038,P14037,P14036,P14035,P14034,P14033,P13920,P13760,P13653,P13652,P13651,P13650,P13330,P13140,P13130,P13120,PASV_DUMMY,P14320,P11304,PASU_DUMMY,P11206,P11204,P11203,P11201,P11200,P58619,P58618,P58616,P14040,P30020,P39010,P59042,P59041,P59040,P31000,P34500,P34000,P30010,P30000,P32000,P14061,P14060,PATU_DUMMY,P13100,PG4494REG,P14090,P14080,P14070,P14065,P14049,P14048,P14047,P14046,P14045,P14044,P14043,P14042,P14041,P30600,PG3410SF,PPHV_DUMMY,P30030,P13211,P13012,P13712,P13702,P13592,P13542,P13532,P13522,P13512,P35000,P51319,P51318,P51317,P51316,P51315,P51314,P51313,P51312,P51311,P51310,P51200,P33000,P38010,P37300,P37200,P37000,P51345,P13212,P13170,P13016,P13013,P13010,P13890,P13716,P13713,P13706,P13703,P13701,P13690,P13670,P13596,P13593,P13590,P13546,P13543,P13536,P13533,P13526,P13523,P13516,P13513,P13510,P13440,P13270,P13609,P11414,P13215,P50510,P50500,P50490,P50480,P50460,P50450,P50440,P50430,P50420,P50410,P50400,P50340,P50320,P50310,P50300,P50250,P20500,MJ,PPMV_DUMMY,P51338,P51337,P51336,P51335,P51334,P51333,P51332,P51331,P51330,P13240,P50520,P50350,P50330,P13210,P13011,P13711,P13591,P13541,P13531,P13521,P13511,P52100,P52090,P52040,P52030,P52020,P52010,P50240,P50230,P50210,P50200,P50080,P50070,P50060,P50050,P50040,P50030,P50020,P50610,P50600,P50360,P54520,P54510,P54420,P54410,P54300,P54010,P53900,P53500,P53460,P53450,P53400,P53330,P53320,P53310,P53300,P53280,P53270,P53260,P53250,P53240,P53230,P53220,P53210,P53200,P53190,P53010,P50390,P50380,P50370,P54700,P23040,P29020,P29010,PTVA_DUMMY,PG9928,PG3995VA,PPTR_DUMMY,P51359,P51358,P51357,P51356,P51355,P51354,P51353,P51352,P51351,P51350,P55200,P55190,P55180,P55170,P55160,P55150,P55140,P55130,P55120,P55110,P55100,P55010,P23060,P24010,PSGS_DUMMY,P45410,P45320,P45310,P45210,P45120,P45110,P45020,P45010,PG2225HC,P45510,P21110,P28020,P28010,P21200,P20030,P20000,P21000,P21900,PSAC_DUMMY,P26060,P26050,P26040,P26030,P26020,P26010,P11421,P11420,P24110,P13087,P13060,P13058,P13795,P13757,P13747,P13738,P14056,P13677,P13667,P13647,P13637,P13631,P13430,P13347,P13337,P13327,P13318,P24140,P51373,P51372,P51371,P51370,PG1724PG,P24150,P24130,P23090,P23080,P24120,P13228,PG9907CO1,PSSW_DUMMY,P25110,P25100,P25040,P25030,P25020,P25010,PSSS_DUMMY,P51391,P51390,P23070,P23030,P23050,P23000,P23020,P23010,PG2871REG,PG2871LC,DPG2871LC,P22020,P23110,P23100,P22030,P22010,P22000,PSPG_DUMMY,P13237,P13230,P17210,P17151,P17150,P17480,P17471,P17470,P17460,P17455,P17451,P17450,P17445,P17440,P17437,P17436,P17435,P17434,P17433,P17432,P17431,P17430,P17421,P17420,P17411,P17410,P17250,P17230,P17224,P17223,P17222,P17220,PG9920,P17334,P17333,P17332,P17331,P17330,P17327,P17326,P17325,P17322,P17321,P17320,P17315,P17314,P17313,P17312,P17311,P17310,P17241,P17240,P17221,P17211,P17180,P17103,P17102,P17101,P17100,P17301,P17006,P17005,P17335,BS0002,BS0001,P17395,P17381,P17380,P17373,P17372,P17371,P17370,P17369,P17368,P17367,P17364,P17363,P17362,P17361,P17360,P17347,P17346,P17345,P17344,P17343,P17342,P17341,P17340,P17339,P17338,P17337,P17336,BS001,P17398,P17002,P17397,P17003,P20540,P20530,P46220,P17396,P17365,P17004,PG9944CENTR,PG9943,PG9942,P10118,P10117,P10116,P10115,P10114,P10113,P10112,P10111,P10110,YCASH,TRAVEL,PL0001,P10000,DUMMY-M,DUMMY PL,DUMMY P-L,PG9948FAS,P17540,P17521,P17520,P17519,P20510,P17007,P17572,P17571,P17559,P17558,P17557,P17556,P17555,P17554,P17553,P17552,P17551,P17537,P17536,P17535,P17534,P17533,P17532,P17531,P17510,P17500,P17366,P17001,P20520,P17541,P18205,P18204,P18203,P18202,P18201,P18200,P18182,P18181,P18151,P18110,P18109,P18108,P18107,P18106,P18105,P18104,P18103,P18102,P18101,P18100,P17386,P17385,ZCCO_DUMMY,PGOMF1STAB,PGDUMMIES,P17399,P17358,PG9954,P17573,P18206,P18605,P18604,P18603,P18602,P18601,P18600,P18505,P18504,P18503,P18502,P18501,P18416,P18415,P18414,P18413,P18412,P18411,P18410,P18409,P18408,P18407,P18406,P18405,P18404,P18403,P18402,P18401,P18400,P18207,P18606,P18635,P18634,P18633,P18632,P18631,P18630,P18629,P18628,P18627,P18626,P18625,P18624,P18623,P18622,P18621,P18620,P18619,P18618,P18617,P18616,P18615,P18614,P18613,P18612,P18611,P18610,P18609,P18608,P18607,P18636,PG9960,PG9959RE,PG9959FAS,P18153,P18152,PG9957RE,P18704,P18703,P18702,P18701,P18646,P18645,P18644,P18643,P18642,P18641,P18640,P18639,P18638,P18637,ZCRE_DUMMY;ZAUDIT=ALLOCATION,ALLOCATION1,ALLOCATION2,BUM_ALLOCATION,BUM_ALLOCATION1,BUM_ALLOCATION2,BUM_ALLOCATION3,BUM_ALLOCATION4,BUM_ALLOCATION5,BUM_ALLOCATION6,BUM_ARAP,BUM_ARAP_INVC,BUM_ASSESSMENT1,BUM_ASSESSMENT10,BUM_ASSESSMENT11,BUM_ASSESSMENT12,BUM_ASSESSMENT13,BUM_ASSESSMENT14,BUM_ASSESSMENT15,BUM_ASSESSMENT16,BUM_ASSESSMENT17,BUM_ASSESSMENT18,BUM_ASSESSMENT2,BUM_ASSESSMENT3,BUM_ASSESSMENT4,BUM_ASSESSMENT5,BUM_ASSESSMENT6,BUM_ASSESSMENT7,BUM_ASSESSMENT8,BUM_ASSESSMENT9,BUM_IG_MANUAL,BUM_IG_MANUAL_INVC,BUM_INPUT_ORDER,BUM_INPUT_ORDER_INVC,BUM_INPUT_REV,BUM_INPUT_REV_INVC,BUM_IOBU,BUM_ORDER,BUM_ORDER_INVC,BUM_PC_ORDER,BUM_PC_ORDER_INVC,BUM_REV,BUM_REV_INVC,BUM_RM_RECON,BUM_RM_RECON_INVC,BUM_SBU_TO_OBU,BUM_SBU_TO_OBU_INVC,BUM_ZEROBALANCING,CALC_OBL_PC,CALC_PC_ORDER,DEPRECIATION,IG_CLOSING,IG_DIFF,IG_MANUAL_INVC,INPUT_ORDER_INVC,INPUT_REV_INVC,IOBU,MOVEMENT,SBU_TO_OBU,SSQ_TOT,ALLOCATION3,ALLOCATION4,ALLOCATION5,ALLOCATION6,ARAP,ASSET1,IG_MANUAL,INPUT_FORM,INPUT_OBL_PC,INPUT_OBL_SP,INPUT_ORDER,INPUT_REV,JE,OBL_PC,OBL_SP,ORDER,PCA,PC_ORDER,REV,RM,ROUNDING,WK1,ZEROBALANCING]

CALC = EA_LOGIC

After validating inUJKT. for both ZAUDIT and PRC, we can see base level members of ALL_Datasource and GMS respectively, still when we run the busienss rule for any other member than base level memeber of GMS, the data got posted.

Why?

Regards,

Apoorva

[former_member186338 · Accepted solution]

First, what do you mean by "when we run the busienss rule for any other member than base level memeber of GMS, the data got posted" - data samples, etc...

Second - what is the rule setup?

Vadim

[Former Member · Accepted solution]

Hello Vadim,

My query has been resolved.

I was selecting incorrect member.

But Thanks for all your help.