cancel
Showing results for 
Search instead for 
Did you mean: 

Virtual cube not populating the Consolidation group values

Former Member
0 Kudos
99

Hi All,

I am having a issue and need your help.

Facts

Two Hierarchies and separate set of consolidation groups under that respectively

Virtual cube 0BCS_VC11 earlier had data with consolidation group values for all posting levels.

I deleted the firsth hierarchy and corresponding consolidation group under that as I wanted the consolidation group under 2nd hierarchy to be populated in virtual cube 0BCS_VC11 and still the consolidation group belonging to the 2nd Hierarchy is not coming in virtual cube.

Hence I deleted the entire data from 0BCS_C11 and ran the entire consolidation cycle.

After this I checked the records in 0BCS_VC11 (Virtual cube) and found that I am not getting even a single record with consolidaton group selected in the output . If I dont choose consolidation group in the output then I am getting the values for all posting level.

Pl help me out.

Regards

Shivaprasad

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member209721
Active Contributor
0 Kudos

Hi SrinivasanG,

I must admit that I have some difficulties to understand your case... it is not really clear.

However, I understand the global issue, which is linked to the use of the SEM-BCS Virtual cube and the consolidation groups. Regarding that, a few important things you have to know :

1) the Virtual cube doesn't contain any data, it only interprets data from the Transactionnal cube using ABAP code

2) For PL00, 01, 10 and 20, the consolidation group is never physically written in the records : it is deducted by the virtual cube depending on the reporting mode you use and the hierarchy/cons group you select

3) If you want to remove companies or consolidation groups, most of the time you need to use COI activities

Hope it helps

Regards,

Thibaud

Former Member
0 Kudos

Hi Collet,

Thanks for the reply.

My issue is Point no 2.

For posting level 00, 01 and 10 the virtaul cube is not deducing the consolidation group. Only for posting level 30 the consolidation group is being deduced.

What can I do to deduce the consolidation group for posting level 00, 01, 10 and 20.

Regards

Srinivasan

former_member209721
Active Contributor
0 Kudos

When you do a List of totals records, select the Repoting logic "Standard"

It should make appear the cons group in the records

former_member194418
Participant
0 Kudos

Hi Srini,

I do have exactly same issue over here. Everything is working fine via UCWB or UCMON and list of totals. But when using databse list via RSA1 and including the cons group hierarchy in output, I get no values. When leaving that out of selection in RSA1, I do get all data as required. I mean I do select the cons group for data processing, but for output processing (that annoying "select all characteristics" things) I do not select it in order to see data.

Can you confirm that your issue is similar?

regards, Clemens

dan_sullivan
Active Contributor
0 Kudos

With respect to COLLET Thibaud reply, it is correct, but it helps to include a cons group in the selection.

The same goes for RSA1, it is necessary to include reporting mode standard and helpful to include cons group in selection.

Former Member
0 Kudos

Hi All,

Thanks for all your responses.

The current setting is like this.

For 0Company (Cons.Unit) I have two hierarchies created in the system.

1. As per Holding and Subsidiary Pattern. Where I have 3 Consolidation Groups in the hierarchy. i.e. H1 > S1->S2

2. I also have another Hierarchy for Cons.Unit which is based on continents. i.e. C1 --> Asia --> India

I run all the tasks based on my first hierarchy which is based on my holding co.structure

I run tasks at Cons.Group Level S2 (from data collection to COI) and move up to Level S1 and H1.

My Requirement is:

If I have to run a report at Cons.Group Level S2, I want to see all the entries from PL 00 to PL30 within this group

But currently it displays only PL30 transactions.

But at the same time, if i run by giving the cons.group "India" , I am getting entries for PL30 for the cons.units within the group which is also part of Cons.Group "S2".

How do i get a report for Cons.Group "S2" which displays all the transactions (PL00 to PL30)?

Thanks

Srinivasan G

former_member1379680
Contributor
0 Kudos

Srinivasan G,

Create a reporting cube and when it is populated, the Cons Groups are assigned to the records.

then you can run your reports on "S2"

Beware that if you then change a hierarchy in prioir periods (as you seem to have done) you will need to re-populate the reporting cube.

There are 2 helpful documents on help.sap.com on using the reporting cube and multiprovider/delta pair solution, but unfortunately they have no direct link so you'll need to search for them.

the first document covers BCS 4.0

the second is an additional document for BCS 6, this document must be read in conjunction with the first document.

Former Member
0 Kudos

Hi Srinivasan,

Did you try to use the 'Standard' reporting mode - it's at the bottom of the screen where totals records (UCMON) are shown?

Former Member
0 Kudos

Hi Eugene Khusainov and others

The issue is resolved.

Thanks for your quick responses. I had also raised this to SAP and they have told what is to be done.

Actually I have 2 hierarchies created for cons.units.

In one hierarchy I have put tick mark against "FCEP" column for all the Cons.Units in the master data config. of cons.unit.

This hierarchy is the consolidation pattern hierarchy which I am using for running for tasks.

In another hierarchy which i have created continent wise for reporting, I have not enabled the tick mark against "FCEP".

What SAP says " When the tick is enabled in the cons.group, this field (Cons.Group) will not be read by the reporting virtual cube in reporting, whereas the other cons.group in which the tick mark is not there, will be read by the virtual cube duirng run time.

Hence this issue was there and once i removed the tick, then the group started showing in the virtual cube.

SAP is really tricky to understand.....!!!!!

Regards

Srinivasan G