Duplicated records when adding Time Characteristics into infocube

[Former Member]

Hi experts,

I created ZPA_C01 infocube copy from standard one, 0PA_C01 (HR - Headcount and Personnel Actions). I added the following time characteristics to ZPA_C01  infocube: 0FISCPER, 0FISCPER3 and 0FISCYEAR. I need them with reporting purposes.

Then I assign value to these new characteristics through a formula (or even forcing them to a constant value) in transformation rules between 0HR_PA_0 infosource and ZPA_C01 infocube.

When I run DTP in order to transfer info from PSA table to ZPA_C01 infocube, records get duplicated in data target as they are shown in the attached picture.

Can you please explain the behavior and how to solve the situation?

Thanks in advance.

Regards,

Juana

[ccc_ccc · Accepted solution]

Hi Juana,

The records which are 000000 (FISCPER) and other extracted before assigning constant values, please check how many DTP requests in infocube manage.

Thank you,

Nanda

[Former Member · Accepted solution]

Hi Nanda,

Thanks for the response.

The attached image (in the original post) shows the result of a unique DTP execution. By the time I took the picture, ZPA_C01 infocube only contained one request.

In fact, in infocube "Manage" option it can be seen that added records are always twice the transferred ones.

When you see data in data target, there are records with 0FISCPER, 0FISCPER3 and 0FISCYEAR populated with a value and others empty in 0FISCPER3 and 0FISCYEAR and 000000 for 0FISCPER.

After DTP execution from 0HR_PA_0 infosource to ZPA_C01 infocube, there are always two records per employee and 0CALMONTH. One with values in time characteristics and other one with no value/000000 as it is shown in the image.

Please, advice.

Thanks in advance.

Ana

[ccc_ccc · Accepted solution]

Do you see any multiple rule groups transformation?

Regards,

Nanda

[Former Member · Accepted solution]

I maintained the same configuration of standard data flow from 0HR_PA_0 infosource to 0PA_C01 infocube. My transformation is a copy of the standard transformation between menctioned objects.

If I delete transformation rules that assign value to 0FISCPER, 0FISCPER3 and 0FISCYEAR, issue disappear. In this scenario, amount of transferred records is the same as added ones.

But if I activate transformation rules for new time characteristics, records get duplicated.

Regards,

Ana

[ccc_ccc · Accepted solution]

I think might be multiple rule groups please check in datasource --> infosource transformation and infosource-->data target transformation.

Please check if any start/end routines.

Regards,

Nanda

[Former Member · Accepted solution]

You were right. There are multiple rule groups in transformation between infosource and infocube. I set the same formula for three time characteristics in all groups, then run dtp and as a result I got just one record per employee and calmonth.

Please advice me about the correct way of using rule groups.

Best regards,

Ana

[ccc_ccc · Accepted solution]

Hi Juana,

Happy to hear.

you can learn more about rule group when you google as like below.

SAP BW rule groups in transformation.

Thank you,

Nanda

[Former Member · Accepted solution]

Yes, I know, of course. I already did it.

Just asking if standard group applies to all groups. I mean, you configure general rules that applies to all rule groups in "standard group" and the you configure specific rules in others rule groups. Is it correct?

Thanks for your help.

[ccc_ccc · Accepted solution]

As per my understand ,

"standard group" also one of the rule group and default rule group only difference between "standard group" other rule groups is, we cannot delete "standard group", however we can delete other groups.

so whatever you written in standard group will applicable to that rule group only .however start/end routine will apply to all rule groups.

Thanks

Nanda