Skip to Content

BPC Validation Report

Hello

I have put a control on the work statut that work find

When I do a esubmit>Validate data if there is an error a message appear that tell me I have no validation report and that administration report are maintain by administrator.

What shall I do to build a validation report ?

Thanks for help

Regards

Anne Forcinal

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2008 at 05:26 AM

    Check page 41 of the SAP_BPC_5_1_Office_UG.pdf, or the BPC online help (search for validating -- data submissions) for a complete description of how the eSubmit - Validation Submission works.

    It requires that you have work status submission working properly in your application, as well as an account called VALIDATION in your account-type dimension. The children of this account need to be your individual validation rules. Logic needs to be set up to calculate the value of each of these accounts, such that if the value = 0 the rule passes. Therefore, by adding up all these rules, the total VALIDATION account must also = 0 to pass the complete validation.

    There are two business rules tables for Validation Rules & Validation Rules Details (see pp 77-78 of the admin guide) that can be used to calculate these accounts.

    Related to all this are the work status settings for your application, where you set the validation node that's evaluated (the intersection of all dimensions that are NOT your work status dimensions) by the validation rules.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2008 at 05:30 AM

    Sorry, I forgot to answer your question!

    I don't believe that a validation report is required to perform the validation itself. If it is required, I've never seen what it looks like, or its purpose.

    What you can build, as a validation report, is a report which shows each of your validation accounts. The value should = 0 if the validations are successful.

    What's also very helplful is a work status submission report, that shows each entity (or whatever is your work status drive dimension), and then the work status, last update time, owner, etc. This lets you see at a glance how each entity is doing in terms of submission, approval, etc.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Tim,

      the office_ug mentioned that one should validate the data before submitting it, i am wondering how validation can even be done if data is not submitted into the database?

      having said that, i am trying to simulate a simple validation and work status update exercise, my settings are as followed:

      work status setting:

      account - no - validation

      category - yes

      datasrc - no - totaladj

      entity - owner

      intco - no - all_interco

      rptcurrency - no - lc

      time - yes

      validation rules:

      validation account - remark - validation operand - other - other - applicable periods - validation tolerance

      validation - testing validation - = - blank - blank - 0

      validation rules details:

      validation account - account1 - flow1 - sign1 - account2 - flow2 - sign2 - remark

      validation - sales - blank - 1 - cost - blank - 1 - testing validation

      work status:

      work state - dm ...docs - controlled by

      unlocked - all ... all - both

      submitted - all ... all - both

      approved - all ... all - both

      i am just trying to validate that my "sales" and "cost" entries are the same, i tried validating before and after submitting my data using evsen(10,"finance","sales) and evsen(10,"finance","cost") respectively with the other cv values being budget, input, worldwide1, non_interco, subtotal, lc - 2007.total1 - periodic.

      i received the message "submitted data did not pass validation. you may need to resubmit data" on both ocassions.

      any pointers?

      cheers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.