Question:
Hi
I tried searching on forum and posting in sem forum but didnt get any reply.
I am reading data from within the BW system and display them in the Business Explorer (Bex) as well as in the manual planning of the SEM-BPS system.
Here the displayed data is not identical although the layout definitions and the selection condition definitions are identical.
thanks in adv
Answer:
Hi
I tried searching on forum and posting in sem forum but didnt get any reply.
I am reading data from within the BW system and display them in the Business Explorer (Bex) as well as in the manual planning of the SEM-BPS system.
Here the displayed data is not identical although the layout definitions and the selection condition definitions are identical.
thanks in adv
Some Analysis/Reason-
Transactional InfoCubes are characterized by the fact that data requests are only completed with a delay. The threshold value for executing a rollup is 50000 data records. The dimension of this value might result in the following: Over a longer period of time, the current data will be updated correctly in the InfoCube, however, it will not be displayed in queries.
Solution-
In order to make sure that the current data is always displayed in the queries, you need to include an additional variable from the SAP Business Content to your queries. To do this, proceed as follows:
1. Make sure that the Most current data variable (0S_RQMRC) from SAP Business Content is activated since otherwise it will not be displayed in the BEx Analyzer.
You can activate the variable in the Administrator Workbench in the area Business Content. You find variables under Object types => Query element => Variable.
2. Start the BEx Analyzer and select a query for processing.
3. In the list of the InfoObjects, select the automatically created dimension data package and then the characteristic Request ID (0_REQUID).
4. Select the Most current data variable (0S_RQMRC) which is assigned to the characteristic and drag it into the Filter field or into the User-defined characteristics field.
5. Save the changed query.
Execute query to get ur desired results and m sure its gonna match ur SEM BPS layouts result as well.
Hope it Helps
_________________
Chetan
@ CP...
Answer:
Thanks Chetan
Is there any automated way to convert cube from Basic to transactional and vice versa
At present its done manually ,Users dont want manual intervention
thanks
Answer:
Thanks Chetan
Is there any automated way to convert cube from Basic to transactional and vice versa
At present its done manually ,Users dont want manual intervention
thanks
Yes ,It can be automated with Process Chain
use FM(Functional Module)
RSAPO_SWITCH_BATCH_TO_TRANS -converting to Transactional
RSAPO_SWITCH_TRANS_TO_BATCH -Converting to Basic loading allowed
In addition ABAP report SAP_CONVERT_TO_TRANSACTIONAL can be used to convert cube to Transactional
Hope it Helps
_________________
Chetan
@ CP...
Answer:
Thanks CHETAN
Search functionality of these forum does work great,saved my time.
Answer:
Thanks CHETAN
Search functionality of these forum does work great,saved my time.
Welcome
Hope every one follows u.
would save BIG TIME...
_________________
Chetan
@ CP...
Answer:
[quote]Yes ,It can be automated with Process Chain
use FM(Functional Module)
RSAPO_SWITCH_BATCH_TO_TRANS -converting to Transactional
RSAPO_SWITCH_TRANS_TO_BATCH -Converting to Basic loading allowed
In addition ABAP report SAP_CONVERT_TO_TRANSACTIONAL can be used to convert cube to Transactional
[/quote]
Is this true for BW cubes or it is only true for APO/SEM cube
regards
phemrajani
Answer:
Yes ,It can be automated with Process Chain
use FM(Functional Module)
RSAPO_SWITCH_BATCH_TO_TRANS -converting to Transactional
RSAPO_SWITCH_TRANS_TO_BATCH -Converting to Basic loading allowed
In addition ABAP report SAP_CONVERT_TO_TRANSACTIONAL can be used to convert cube to Transactional
Is this true for BW cubes or it is only true for APO/SEM cube
regards
phemrajani
Dear phemrajani,
It holds true for Transactional Cubes(APO & SEM) only.
Hope it Helps
_________________
Chetan
@ CP...