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

Restatement Functionality when reporting is in different box then consol

Hello All,

We want to achieve restatement functionality but our reporting is in different box meaning consolidation is in one box & reporting is in BI box where virtual multiprovider will not exist.

Question is what are the possible ways to achieve this, please let me know if you think of any?

Thanks & Regards,

SMP

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 07, 2010 at 01:15 PM

    I suggest you use a BCS datamart. This reads records from the totals cube using the BCS virtual cube logic (functional module) and populates a basic cube. This basic cube could then be copied to the reporting environment. The restatement records would be applied correctly and thus reporting with or with out these restatement records may be achieved.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 07, 2010 at 07:42 AM

    For sure, you need a virtual cube to perform your consolidation reporting, especially the restatement mode

    Can you please detail a little bit your scenario, because I don't really figure out how you have splitted the two boxes...

    Add a comment
    10|10000 characters needed characters exceeded

    • But in both Boxes, you are using SEM-BCS transactional infocubes, right ?

      If yes (which is for me mandatory), you need to generate the virtual cube in the reporting box at least to perform the consolidation reporting. Actually, the issue is not the mutliple hierarchy option, but the consolidation logic in general. You will not be able to retrieve consistent data if you base your reporting on a basic cube or a transactional cube. The full concept of BCS is highly based on the virtual cube and its function modules. Basic examples : you can have the date of acquisition / date of divestiture in a cons group, the accounting techniques or the reporting mode correctly applied in the reporting ONLY IF you use the BCS virtual cube.

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.