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

Unable to determine consolidation Area for Databasis AF

Hi All,

I wanted to check BCS results in BW I found the following errors in running query:

1. Error reading the data of InfoProvider BCS_C1V11 (Virtual cube)

2.Unable to determine consolidation Area for Databasis AF

Can anybody advise, what sould be the probable reasons? I regenerated the consolidation areas, still its same error. Any thoughts, what I should look into.

Thanks and Regards,

Ashwin Nagar

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 13, 2008 at 03:42 AM

    Hi Ashwin,

    You need to specify BCS mandatory fields when doing a listcube from the virtual cube.

    Period

    Year

    Controlling Area

    CS Chart

    CS Version

    BCS Version (or any other custom versions)

    Fiscal Year Variant

    Group Currency

    If you are trying to get consolidated results, make sure cons group is a field for display from the cube.

    Also, if running for a consolidation group, you must enter the cons group you want plus all groups which roll into it.

    For example, if you have

    CG 1
    - CG 2
    - - CG 3
    - CG4

    and you want to get results for CG1, you need to enter CG1, CG2, CG3, CG4.

    This is why List of Totals Records is preferred.

    Hope that helps 😊

    - Chris

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 20, 2008 at 02:54 AM

    Hi Ashwin,

    I have the same problem. Do you resolve this thread?

    Thanks and Regards,

    Gloria

    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.