Skip to Content
avatar image
Former Member

BCS - Reporting methods

Gurus,

can you tell me whats the difference between the database list and reporting in the BCS infocube which is transactionl cube as i see values different in each formats

thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2007 at 12:45 PM

    In the database lists, the system displays all postings on the selected consolidation units regardless of whether they are valid in the selected consolidation group or not. As a consequence, it is rather difficult to compare the values with the group values in the reporting.

    Consider the following rules for the group reporting (Queries on the virtual cube for totals or documents with use of at least one characteristic restrictions are analyzed per characteristic of the consolidation group role.

    <b>Data of the posting levels 00, 01 and 10</b>

    The program only selects those data records for which applies: The consolidation unit is contained in the consolidation group. Accounting Technique is Purchase. The period in the data record is between the first and end consolidation time of the respective consolidation group.

    <b>Data of posting level 20</b>

    The program only selects those data records for which applies: Both the consolidation unit itself and the partner unit as well are contained in the consolidation group. Accounting techniques of both are Purchase. The period in the data record is between first and end consolidation time of both the consolidation unit and the partner unit in the respective

    <b>consolidation group Data of posting levels 02, 12, 22 and 30</b>

    The program only selects those data records which are posted in the selected consolidation group or in a consolidation group subordinating to it. Purchase method as well as first and end consolidation time are not considered.

    Hope it Helps

    Chetan

    @CP..

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2007 at 05:56 AM

    Hi Peter,

    As far as I understand you, you are interested in difference in data when you look directly at content of the totals cube through, for example LISTCUBE, and

    list of totals records in the consolidation monitor.

    Have I got you right?

    If yes, then:

    physically the totals cube contains so called Reported financial data -- you see it in RSA1 or LISTCUBE.

    Reports in BCS show data after consolidation activities. Consolidation entries are stored separately, in documents ODS, not in the totals cube.

    Moreover, reporting in BCS is made through the virtual cube with a functional module which applies some logic in retreiving info.

    That may lead to differences in question.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded