Skip to Content
avatar image
Former Member

BCS: unable to determine consolidation area for data basis B1

Dear gurus,

I have two consolidation areas B1 and Y1 on the same data basis B1. I want to report the data of consolidation area Y1. I created a query which had the restrictions on consolidation chart of accounts, fiscal year variant, version, fiscal year, posting period and group currency. But when I opened the query with BEx Analyzer, the error prompted like below:

Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION

Error reading the data of InfoProvider ZCB_B1V11

Unable to determine consolidation area for data basis B1

The row of the query is Item. I found if I activated the hierarchy of Item, this error occured and if deactivated the hierarchy of Item, the error disappeared.

Please advise. Points will be awarded if helpful.

Thanks in advance.

Jin Ming

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 20, 2007 at 04:42 PM

    Hi Jin Ming,

    Something is wrong with your hierarchy.

    In my case items hierarchy works fine.

    May propose two cases:

    1. Which version of your hierarchy, defaulted 100 or not? If not - wait for trouble.

    2. Hierarchy are global for all consolidation areas. If you hierarcical structures in different cons areas assigned to different special versions, the I'd not exclude some controversies between globality and special version pecularities.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 21, 2007 at 03:27 AM

    Hi Jin Ming,

    Try to copy the hierarchy version 200 to version 100 in RSA1 and then syncronize this 100 version from BW to BCS.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded