cancel
Showing results for 
Search instead for 
Did you mean: 

How to check the data for a particular request id for a standard DSO

Former Member
0 Kudos

Dear BI Experts,

We have a standard DSO with delta loads in our project.

We got a requirement from the client that they need the data (records) for a particular request id .

I have checked in the display data of DSO and there is no Request id field and calday field.

Can you please tell us how to check the data for a particular request id for a standard DSO.

Thanks and Kind Regards.

Sunil

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Sunil,

Please try this.

1. Goto RSA1> Search for your DSO> Manage > Copy the Request ID from the 'Requests' Tab

2. Click on Contents> New Data > Fill the Field Name "SID" with "Request ID that is copied" > Execute

Hope this helps.

Regards

Sai

Former Member
0 Kudos

Hi Sunil ,

we can check data based on request wise in DSO only in change log table .

Change log table have activation request number so you can find the activation request number with respect to

loading request number then check in Change log table based on request number.

If we activate e muntiple loading request in single activation process , so we will get single activate request number for all with respctive multiple loading request number.

Thanks

Hanumanthu

Former Member
0 Kudos

hi sunil,

As per my knowledge, we cant see the dso data with particular request wise like in cube..., but it is possible through change log..,

or else you can create one standard cube on top of that dso.. and at dtp level choose extraction mode as delta and check " Get new data req. by req" and execute....

Now at cube level you can see the data with particular request...

Thanks,

Malathi..,

ravi_chandra3
Active Contributor
0 Kudos

Hi ,

If u want to view the data as per the data request , then select the required DSO-->RC-->MANAGE, under the REQUEST TAB, u can able to view the request with the data.

If u want the same requirement in the REPORT , then on the Infprovider panel, select the reqest characteristic and drag and drop it to the rows. and create the variable .

Hope u got it,

Thanx & Regards,

RaviChandra

Former Member
0 Kudos

RIGHT CLICK ON DSO and click on manage tab.All the request id with the recodrs of data load will get displayed.Then choose the specific ID which you want and click on content.After that click on Active data at the bottom of the screen.You will get a selection screen,choose the required fields and you will get the data for that id.

Former Member
0 Kudos

Thanks...