Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Purpose of reference period (0REFPER) and year in BCS?

Hi Everyone,

What is the purpose / benefit of using 0refper when reporting?

We have been testing some scenarios today and cannot see any beneficial use:

We loaded RFD (PL00) for periods 0-9

We loaded to the reporting cube (NB we run reports on a reporting cube NOT the BCS transactional cube)

Upon loading to the reporting cube, Consolidation group is populated for all records

We changed the hierarchy for period 6

We loaded again to the reporting cube

The Consolidation group changed for records from period 6 onwards

We loaded some Intercompany postings in p6 and ran eliminations

We loaded to the reporting cube

Upon loading to the reporting cube, Consolidation group is populated for all records

We changed the hierarchy in p6

We loaded again to the reporting cube

The consolidation group changed for records from period 6 onwards

These results were regardless of the value of 0refper

Therefore my question is does 0refper only provide a snapshot of data ata certain time?

eg if we repeated the scenario above and loaded with 0refper = 9, we would have the original Consolidation groups

then if we changed the hierarchies for any period (eg 6) and loaded with 0refper = 10, we would have the new consolidation groups.

If this is correct, what is the benfit of this functionality?

replied

When executing query using virtual infocube it is important to choose reporting mode restatement. Have you tried this?

I have successfully used )refper but it has been some time ago with release 4.0.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question