Data Doubling in the Cube

[Former Member]

Dear Experts

When I am running Account Based Calculation through Data Manager Package, transaction data in the cube is double. Hence my end reports are wrong.

I run the optimization package and no change in the data. I also checked the Business rule to make sure none of the rule make the system to do doubling the data.

The logic is not set up as default logic.

I am experiencing the problem when I run it for period 2, it is OK with period 1.

How can I solve the problem.

My model is YTD in BPC NW 10.

Kind Regards

Abraham

[Former Member]

Hi Abraham,

Would you please share your business rule.

Regards,

Kalyan.

[Former Member]

Hi Kalayan

Thanks for the response

The business rule is to calcculate the Cash Flow which big enough to share

In summary Following fields are populated

1. Source Account

2. Source Flow (Movement Calculation)

3. Destination Account (Cash flow account) does not have RATETYPE property.

4. Destination Flow

5. Destination Audit (memeber have the property A, IS Consolidated (Y), IS converted (N)

6. Reverse Sign (aganist opening flow)

7. Apply YTD (No)

Hope this helps.

Abraham

[Former Member]

Hi Abraham,

If there are too many rules, it would be better to reduce the rules to few and run the package the check the result. The best approach to identify your issue would be add one rule at a time and then run the package after each rule addition. Also remember to clear the CF accounts before every run, this way you will be able to identify if any particular rule is the source of ur problem.

Regards,

Kalyan.

[former_member186338]

100% agree with Kalyan. There is no magic solution to solve the issue!

Vadim

[Former Member]

thanks Vadim

[former_member186338]

Hi Abraham,

Please, post the script.

B.R. Vadim

[Former Member]

Hi Valdim

Thanks for the response

Logic for Account based Calculation

*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = %CATEGORY_SET%
CURRENCY = %RPTCURRENCY_SET%
TID_RA = %TIME_SET%
CALC = CF
OTHER = [ENTITY = %COMPANY_SET%]
*ENDRUN_PROGRAM

CF is the ID for Business Rule.

Logic for runnung currency conversion

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

CURRENCY = USD,EUR

TID_RA = %TIME_SET%

OTHER= [ENTITY = %COMPANY_SET%]

RATEENTITY = Global

INCREMENTAL_MODE=I

*ENDRUN_PROGRAM

Hope this helps