on 10-15-2013 1:12 PM
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
Hi Abraham,
Would you please share your business rule.
Regards,
Kalyan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
Hi Abraham,
Please, post the script.
B.R. Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
9 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.