To create new DSO follow the steps like below..
1. Choose the Option to create Datastore Object from the Context Menu from your Info area
once you choose Option Infoprovider under Modelling Tab.
2. Give the necessary Technical Detail based on the requirement. Give appropriate
description that can provide what for the Object is built.
3. Only check the Box for Set Quality OK by Unchecking remaining boxes under SETTINGS.
.
4.For selecting required Key fields and Data fields , can be taken
help of Data Source as Template.This can be achieved by choosing
Infosources option from the middle of your screen . Once you select
the appropriate Data Source from the POPUP screen(0CO_OM_CCA_9) ,
you will see all the details of your Data Source as groups like Characteristics,
Key Figures, Time Characteristics and Units.
If not available Insert necessary objects like below.
5. Select necessary combination of Key Fields from Characteristics and Drag
them under Key FIELDS of your DSO definition..
6. Similarly Drag remaining Characteristics , Key Figures drag them to the
DATA FIELDS based on your requirement..
6A. Fiannly it should like..
7. Activate the DSO.
8. Choose Create Transformation option from the Context Menu of your
newly created DSO.
9. Choose DataSource as Object Type then give details for Source
and Datasource name as required.If you are not sure about Datasource,
can be selected by using Drop Down Box like below.
Then choose option Continue to go Transformation Details.
10. Map all the fields from LEFT to Right by matching Descriptions as
Technical names are different.
11. Activate the Transformation after completion of Mapping.
12. Create Info Package and execute the same from Scheduling Tab.
13. Monitor the progress by choosing Monitor from the Tool Bar.
14. Create DTP for your DSO and Activate the same.
15. Execute the DTP and get the success status.
16. Activate the Successful Data Request by choosing
MANAGE OPTION from the context menu and again
choose ACTIVATE button at the bottom.
Once you get the popup select the request and click on.
Start Button which at the bottom of the screen.
17. Get the status by clicking Refresh Button frequently.
If the Activation is successful the request will disappear
from the popup.
18. Close the popup and get back to previous screen. If you
want to see the contents of your DSO , select Content Tab
and choose Active Data option . It will take you to different
screen and press F8 , then you will see the details of your DSO.
Output of DSO content..
1. Choose the Option to create Datastore Object from the Context Menu from your Info area
once you choose Option Infoprovider under Modelling Tab.
2. Give the necessary Technical Detail based on the requirement. Give appropriate
description that can provide what for the Object is built.
3. Only check the Box for Set Quality OK by Unchecking remaining boxes under SETTINGS.
.
4.For selecting required Key fields and Data fields , can be taken
help of Data Source as Template.This can be achieved by choosing
Infosources option from the middle of your screen . Once you select
the appropriate Data Source from the POPUP screen(0CO_OM_CCA_9) ,
you will see all the details of your Data Source as groups like Characteristics,
Key Figures, Time Characteristics and Units.
If not available Insert necessary objects like below.
5. Select necessary combination of Key Fields from Characteristics and Drag
them under Key FIELDS of your DSO definition..
6. Similarly Drag remaining Characteristics , Key Figures drag them to the
DATA FIELDS based on your requirement..
6A. Fiannly it should like..
7. Activate the DSO.
8. Choose Create Transformation option from the Context Menu of your
newly created DSO.
9. Choose DataSource as Object Type then give details for Source
and Datasource name as required.If you are not sure about Datasource,
can be selected by using Drop Down Box like below.
Then choose option Continue to go Transformation Details.
10. Map all the fields from LEFT to Right by matching Descriptions as
Technical names are different.
11. Activate the Transformation after completion of Mapping.
12. Create Info Package and execute the same from Scheduling Tab.
13. Monitor the progress by choosing Monitor from the Tool Bar.
14. Create DTP for your DSO and Activate the same.
15. Execute the DTP and get the success status.
16. Activate the Successful Data Request by choosing
MANAGE OPTION from the context menu and again
choose ACTIVATE button at the bottom.
Once you get the popup select the request and click on.
Start Button which at the bottom of the screen.
17. Get the status by clicking Refresh Button frequently.
If the Activation is successful the request will disappear
from the popup.
18. Close the popup and get back to previous screen. If you
want to see the contents of your DSO , select Content Tab
and choose Active Data option . It will take you to different
screen and press F8 , then you will see the details of your DSO.
Output of DSO content..
No comments:
Post a Comment