BCS - Reporting methods
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
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