cancel
Showing results for 
Search instead for 
Did you mean: 

Dimension member formula removed after importing master data

former_member228522
Active Participant
0 Kudos

Hello,

I am using CPMBPC801 SP4 currently.

I am facing a problem like Dimension member formula removed after importing master data from flat file using data manager package.

Whenever I update master data for a dimension which has dimension member formula, then Dimension member formula removed automatically. I need to rewrite formulas again. Could anyone please help me to resolve this issue.

Best Regards,

Deepak

Accepted Solutions (1)

Accepted Solutions (1)

former_member228522
Active Participant
0 Kudos

Could anyone have idea to resolve above issue.

Best Regards,

Deepak

former_member228522
Active Participant
0 Kudos

Issue has been resolved. Below is the solution

1) If master data flat file has FORMULA column with blank value then Dimension member formulas will remove after updating master data from flat file.

2) If master data flat file has FORMULA column with values then Dimension member formulas will not remove  after updating master data from flat file.


3) If master data flat file does not have FORMULA column then Dimension member formulas will not removed after updating master data from flat file.


Best Regards,

Deepak

Answers (2)

Answers (2)

former_member228522
Active Participant
0 Kudos

Hello,

I have used both options for importing master data from flat file: UPDATE and OVERTIRE

in both cases member formula's got deleted.

Deepak

Former Member
0 Kudos

Are you using update or overwrite option when you import?

former_member228522
Active Participant
0 Kudos

Hi Andy,

I am using update option when import.

Deepak