Skip to Content
author's profile photo Former Member
Former Member

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Oct 07, 2008 at 02:14 PM

    It is my understanding that the 0refper is factored into reporting with BCS virtual infocube. It may not be applicable for BCS datamarting.

    The reference period/year feature allows for reporting for a certain timeframe using a hierarchy of another timeframe. In other words, you could report on the p9 balances with the p6 hierarchy for comparison purposes, if needed, or the p6 balances with the p9 hierarchy if needed.

    The virtual infocube logic looks at the hierarchy for the reference period/year to determine the relevant posting level 20 and 30 records for the cons group selected in the query.

    When BCS datamart is used, the virtual InfoCube logic is only applied during the population of the datamart in order to assign the correct cons group for each record.

    The only alternatives I can think of is to have an alternative datamart or report from the BCS virtual infocube.

    Add a comment
    10|10000 characters needed characters exceeded

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.