DSO error No data in active table

[Former Member]

Dear Experts,

I have loaded data from PSA to DSO in BI 7.0

And i can see data in New table/BIC/AZCRM_DSO40.But when i check active table or changelog there is o entries.

please help what would be error.

Thanks!

Rajesh

[Former Member · Accepted solution]

Hi,

After activating data would be available in active table and change log table.

Please activate ur request.

Regards,

Gaurav

[former_member203104 · Accepted solution]

Hi,

Please activate the request, from manage tab of the DSO.

After activation the data will be moved from new table to active table.

Thanks

[srikanth_rapur2]

Hi

When you load the data in DSO, 1st it will move into new data table after activating the DSO this load will move into the active data table and change log table,and the load in the new data table gone.

regards

sap

[KodandaPani_KV]

HI,

activate the request then check in active data table

DSO have 3 tables

1. new data table - before activation data contain, after activation no data.

2. active data table - after activation data contain -  check the query symbol on request

3. change log table - it holds changed and modified records it will maintain 0RECORDMODE function.

only active data table available for reporting.

changed records will get form the change log table.

Thanks,

Phani.

[Former Member]

Hi,

Kindly activate the data request. Post that, Under "request available for reporting" a symbol will appear which means that the data has been moved to Active table and is available for reporting at further levels.

And you can then check for contents in the active table of the DSo, you should get the records.

Change log: Contains the change history for the delta update from the DataStore object into other data targets, such as DataStore objects or InfoCubes. It makes sense in case of delta uploads.

Regards,

hemlata

[Former Member]

hey Rajesh,

Unless you activate your DSO data, it remains in New Data table. You have activate it for it to come to Active Data table. Change Log table on the other hand holds changes. So even after you activate, it will be empty unless you load changes records to your DSO.

Hope this helps!

Thanks,

Sheen

[former_member199945]

Hi,

Need to activate the request , after activating request you will get report symbol under manage screen beside request no, this will conform that data is available for reporting.

Thanks.