EPM 10 Input schedule and Default package execution rule

[former_member228398]

Hi  Vadim,

I have seen strange behavior of my data . User has uploaded data on "PROJ" catg. but after execution of default , its changed to "ACTUAL" catg.

Attached is the BPC data change report log in text file. Data should be on Proj. How system save this data to "ACTUAL" category.

%Activity%	%AddlInfo1%	%AddlInfo2%	%Date and Time%	%Value%	%BFL_CATEGORY%
Logic Script Execution	DEFAULT		30.12.2014 16:25:54	10,000,000.00	ACTUAL
EPM Add-in Input			30.12.2014 16:25:53	-10,000,000.00	PROJ

I have attached the text file of data change BPC audit report.

Regards,

Milind.

defulat.txt.zip

[former_member186338]

As I already mentioned, please provide FULL text of default.lgf file!

Vadim

P.S. And BPC version!

[former_member228398]

Hi Vadim,

Our BPC version is CPM BPC 800 , SP-10 .

There is nothing in my default.lgf. Its a blank.

Regards,

Milind.

[former_member186338]

Please show the screenshot of your "empty" default.lgf. Or simply delete default.lgf at all.

Vadim

[former_member228398]

Hi Vadim,

Following commented code is there in default.lgf. You please open my attachment in excel file.

I think its a bug. Now when I removed 0 version data from cube and re-enter my input schedule and re-process the DMP. Result is correct. But why system is behaving like this. I need to analyze it.

//*XDIM_ADDMEMBERSET BFL_ACCOUNT = 221004,221006,900002,221002,900003,221016
//*XDIM_MEMBERSET BFL_CATEGORY = MASTER
//*XDIM_MEMBERSET TIME = %TIME_SET%
//*WHEN BFL_ACCOUNT
//*IS *
//*REC(FACTOR = -1,BFL_CATEGORY = "MASTER")
//*ENDWHEN
//*COMMIT

//*XDIM_ADDMEMBERSET BFL_ACCOUNT = 900001,211001
//*XDIM_MEMBERSET BFL_CATEGORY = ACTUAL
//*XDIM_MEMBERSET TIME = %TIME_SET%
//*WHEN BFL_ACCOUNT
//*IS *
//*REC(FACTOR = -1,BFL_CATEGORY = "ACTUAL")
//*ENDWHEN
//*COMMIT

[former_member186338]

"You please open my attachment in excel file." - what do you mean by this?

In general, test the input schedule - without (or empty) default.lgf you will have no extra records!

Vadim

[former_member228398]

Hi Vadim,

If you check the record in text file,  User entered following record using input schedule

EPM   Add-in Input			30.12.2014 16:25:53	-10,000,000.00	PROJ

But at 16:25:54 , following record get created in BPC cube

Logic   Script Execution

DEFAULT

30.12.2014 16:25:54

10,000,000.00

ACTUAL

How system change category from PROJ to ACTUAL.  I have checked all the DMP logs and BPC Data change log of particular user. I found this trace in BPC data change report.

Hope this clears you.

Regards,

Milind

[former_member186338]

Unfortunately there is no log of default.lgf changes... Looks like 30.12.2014 the default.lgf was different.

Check now and you will see no extra records!

Vadim