Question:
SEM gurus,
I am a BW consultant and trying to find some basic knowledge about SEM cubes.
Our SEM team has completed BCS config steps .
Q1. I saw cube ZBCS_C111 and virtual cube ZBCSVC111. I understand that queries are created on Virtual cube instead of basic cubes.
Why?
Q2. What is the purpose of various cubes that are created in BCS?
Some have extension OV11-12-13 etc
some have extension CV11-12-13 etc
some have extension C11-12-13 etc
Thanks for your replies.
BW_tester
Answer:
You can not create the BCS reports on transactional cube. You can create it only on Virtual cube, since the necessary logic is added thru program in there.
Answer:
Thanks for your reply.
I was able to create and run the query on ZBCS_C111. It is a transactional cube.
Can you please explain why I should no create and run query on Transactional cube directly and I should access it via virtual cube (function Module ).
Thanks for your interest.
Answer:
Hi,
That is the way BCS has been setup.
In virtual cube there is a abap program which is helping specifically helps the query job.
This is not there in transaction cube.
Regards,
Answer:
The BCS virtual cube has logic relevant for consolidations. For true accounting consolidations, the reports must be executed for a Cons Group. However, the data is not stored by group but by Cons unit. Therefore, the logic first looks at the Cons Group hierarchy for the specific time of the report and determines what cons units are a part of that group. Then the records for these units are retrieved. The next logic of the virtual cube looks at the partner of the retrieved records for posting level 20. If the partner is also a unit within the group, then it is included in the results. If not, it is excluded.