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.
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.
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,
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...
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.