cancel
Showing results for 
Search instead for 
Did you mean: 

DMEE Tree out put is comming single line

Former Member
0 Kudos

Hi Team,

I have done the DMEE tree configuration but output(flat file i.e text file) is comming only first line of the payments i.e f110 first document details.

can anyone help on this where i did mistake and where i need to change it.

Regards,

Raman

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi Raman,

Try this configuration

DMEE TREE PROPERTIES:- sort/key fields

    STRUCTURE FIELD      SORT FIELD  LEVEL

1.   FPAYH                         ABSBU          1

2    FPAYH                         DOC1R          2

Hope this will helps you.

Regards,

Lakshman

Former Member
0 Kudos

Hi Raman ,

Can you please check sort/ key field at higher level of DMEE file . as below screen

former_member193513
Contributor
0 Kudos

Hi Raman

Sorry for confusing you .

Please ignore creation of technical element

the given screen shot was the config in my client

I have given it only for reference. Try to create on header and line item as per your format

Regards

Prasad

Former Member
0 Kudos

Hi Prasad,

below is the DMEE tree config which i have done .i want total amount in aggregation how ever am not getting the field in aggregation.

please check why it's generating single line and how to make aggregation i.e sum of all the documents value.

output values

IN08,20141202,0.00,IN08,20141202,GB01,,,8000.00,INR,IN08201400,IN08,20141202,GB01,,,1000.00,INR,IN08201400,IN08,20141202,GB01,,,2000.00,INR,IN08201400,

but all are coming single line.

even i have created item as a node 2.

Former Member
0 Kudos

Hi ,

I could able generate the file separate lines but in header level i kept total amount means i need to get all the payment values when i try to put in aggregation am not getting the field.

How to put the aggregation filed and how to get the total amount. it should come 11000 but it's coming zero values could you please help on this.

IN08,20141202,0.00, 0.000000,

IN08,8000.00,INR,IN0820140000522014,3,

IN08,1000.00,INR,IN0820140000532014,3,

IN08,2000.00,INR,IN0820140000542014,3,

Regards,

Raman

former_member193513
Contributor
0 Kudos

Hi Raman

If you want to have the aggregation work, in the item details for the filed amount give refernce id as amount

And after that go back to the header item and in total amount filed select the aggregation in the mapping structure

Give the reference id and aggregation value as 1

save and activate the dmee

Hope this will helps

Regards

Prasad

Former Member
0 Kudos

Hi Prasad,

Please give any screenshot how to do it.

Regards,

Raman

former_member193513
Contributor
0 Kudos

Hi Raman

Please find the attachment

.

Hope this will helps you

Regards

Prasad

Former Member
0 Kudos

Hi Prasad,

Thanks for your help.

I will check and confirm.

Regards,

Raman

former_member193513
Contributor
0 Kudos

Hi Raman

As i understood, you have created one header one segment group and one segment

Where  is the level1 that you have assigned.. is it the header

Can you please share the config, so that it would help us to resolve the issue

Thanks

Prasad

Former Member
0 Kudos

Hi Prasad,

Header level i have given level one i don't have system at this movment.

Regards,

Raman

former_member193513
Contributor
0 Kudos

Hi raman

Its okay .. May be if you can do the config in the below attached way it will work

Give a try as above and share feedback

In the above screen shot take batch header as line item

Regards

Prasad

Former Member
0 Kudos

Hi Prasad,

Thanks for the help can you tell me what is the level for batch and file header?

Regards,

Raman

former_member193513
Contributor
0 Kudos

Hi Raman

I have given file header as level 1 and batch as level 2

Let me know if you need further details

Regards

Prasad

Former Member
0 Kudos

Hi Prasad,

can you plese tell me what is the use of technical segment, composit and segment. why we use those.

Regards,

Raman

former_member221515
Active Contributor
0 Kudos

Hello Raman,

Can you please tell me process for configuring DMEE file output. Please let me configuration steps.

Also I would like to know DMEE file output end user steps.

=

Deepak

former_member193513
Contributor
0 Kudos

Hi Raman

As you are saying that the output is coming in single line, instead of two lines.. I would like to understand the DMEE structure that you have configured

Did you create more than one level for  DMEE

How many segments and segments groups you have and what is the level that you have maintained for those

Let us know the config that you did for DMEE or share few screen shots, so that we can help you out

Thanks

Prasad

Former Member
0 Kudos

Hi Prasad,

I have created one header,one segment group and one segment only in segment having level 2.

Regards,

Raman

Former Member
0 Kudos

Hi Raman,

Check the Sory key defined in the DME Tree. Also check if the Levels are correctly defined in the DME tree.

BR

Amitash

Former Member
0 Kudos

Hi Amit,

i have created level one for general data and payments for level 2 that's.

could you please elabarate it.

Regards,

Raman

former_member193513
Contributor
0 Kudos

Hi Raman

Check the Levels in the DMEE properties

What is the repetition factor maintained in that

Also as suggested by others, please check the sort Key

hope it will helps

Regards

Prasad

Former Member
0 Kudos

Hi Prasad,

I have tried the sort key FPAYH-LFDNR when i use it it's generating blank output.

please suggest.

Regards,

Raman

cgilberg
Active Participant
0 Kudos

Hi Raman,

this likely has to do with the sort field in the DMEE properties. I suggest to use FPAYH-LFDNR.

Best Regards,

Christoph

Former Member
0 Kudos

Hi Chirstoph,

i have created level one for general data and payments for level 2 that's.

could you please elabarate it.

Regards,

Raman

cgilberg
Active Participant
0 Kudos

Hello Raman,

so level 1 is like one-time header information and not going to be repeated? In this case, I suggest to use FPAYH-LAUFD for level 1 and FPAYH-LFDNR for level 2; this will repeat level 2 for every payment.

Best Regards,

Christoph

Former Member
0 Kudos

Hi Christoph,

I have tried the sort key FPAYH-LFDNR when i use it it's generating blank output.

please suggest.

Regards,

Raman

Former Member
0 Kudos

Hi,

i'm getting the output single line with all the data. i want once first record completed it should come in second line.

see the output.

IN08.20141202.IN01.....00000000000000001000.00..IN0820140000462014.IN08.20141202.IN01.....00000000000000001000.00..IN0820140000472014.IN08.20141202.IN01.....00000000000000001000.00..IN0820140000482014.

Former Member
0 Kudos

Hi,

i'm getting the output single line with all the data. i want once first record completed it should come in second line.

see the output.

IN08.20141202.IN01.....00000000000000001000.00..IN0820140000462014.IN08.20141202.IN01.....00000000000000001000.00..IN0820140000472014.IN08.20141202.IN01.....00000000000000001000.00..IN0820140000482014.

Regards,

Raman