Limited records displayed in a view

[Former Member]

Hello,

I'm trying to see the table contents of a view in DB connect. It only returns back 20 records. Is there any way to change it to show all the records that are present in the view. I'm trying to figure out some missing data in my ODS and CUBE.

When I see the view in SQL, it does show that the records are present and the total number of records as 100 (just a arbitary figure). When i check my ODS, it does show that 100 records were transferred, but when i do a check for some specific data, it fails to show it and i cannot get it when i run my query.

Any thoughts?

Sam

[former_member184494 · Accepted solution]

SAM,

in the requests tab of your ODS .. look for the column on Records updated - that will tell you if the records were aggregaated in some way...

It could be that 100 records were transferred but then 20 records could have been updated by way of overwriting etc.. check the key fields you have defined for your ODS - if possible match it with that in the DB and seeif the number of records are the same,.....

Arun

Hope it helps..

[Former Member · Accepted solution]

Arun,

I changed one of the data fields to Key fields in the ODS. I emptied the ODS and Cube. I then ran a full load process chain on the ODS and cube. This is what I'm getting:

ODS:

transferred records: 1326069 ( = to the number of records in SQL)

added records: 1325357 (712 records less)

cube:

transferred: 1325357

added: 805738

I'm running the query on my Cube. How do i find out the reason for just 805738 records being added instead of 1326069?

Regards,

Sam

[Former Member · Accepted solution]

Hi,

Are you 100% sure that there are no start routines in update rules. That is one place where the number of records getting into the cube can undergo a change.

With Regards,

[Former Member · Accepted solution]

Hi,

There might be some update rules/START ROUTINE in your ODS/Cube.

Thats why transfered records are more than added records.

Hope it helps....

[Former Member · Accepted solution]

Hi,

I checked my Cube again. It was missing one info object that was present in the ODS. After i added it and ran the init load, all the records were transferred and added. Now I need to figure out the 712 missing records in the ODS. I can see the records in PSA, but somehow they are not getting added to the ODS. My guess is that it might need another key field in the ODS. when it is transferred to the ODS, some of the records are getting overwritten instead of 2 separate records.

Would clicking on 'Unique Data Records' in the ODS settings help?

Thanks

Sam

[Former Member]

Hi,

Are you using a view to extract data from a database or a table?

Try to view the active ODS table, which will be in this format /BIC/A<ODS NAME>40 using SE11 and find out if the records are there in the ODS physically.

With Regards,