cancel
Showing results for 
Search instead for 
Did you mean: 

BCS: unable to determine consolidation area for data basis B1

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Eugene, Hi Jing,

I am also facing the same problem. This problem I am facing only recently when I created one query using item and hiearchy in row.

Before, this everything was working properly.

A bit strange that sometime some of the old queries work properly until I have not tried to open the new query.

Please advise.

Best Regards,

UR

Former Member
0 Kudos

Hi UR,

It's a bit strange, but in the most of such cases the upgrade of SAPGUI to the newest version does help!

Former Member
0 Kudos

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.

Former Member
0 Kudos

Dear Eugene,

you are right. My hierarchy is built on the version of 200. Is there any solution to solve this controversy? Thanks.

Jin Ming

dan_sullivan
Active Contributor
0 Kudos

It might be possible to assign special version 100 to the hierarchy created in special version 200 to avoid copying it.