I ran the RSRV test for the "Database Information about InfoProvider Tables" to check the Fact Table/Dimension table entries and their percentages with respect to fact table.
But the test did not return the intended results. I had about 25 records in the Infocube. i ran the test and got the results. no problem. After that, I loaded another 30000 odd records. If I run the RSRV test now, its still showing 25 records. but by doing SE16 of all the tables, I see the correct numbers.
I deleted all the requests from the Infocube, loaded it again multiple times... Still the same problem. I refreshed InfoCube statistics. I modified the infocube by adding another characteristc, reactivated it, loaded data, refreshed stats. still the same problem... still its showing 25 records...
I assume its the buffer problem in my system, but has anyone else experienced it?
I havn't tested with other cubes.
Thanks
Gova