Question:
Hello,
I need help. Is there a way to identify the total number of records loaded in a certain infocube?
I have an existing infocube and it contained 3 - 5 years worth of data. I would like to know the total number of records in the said cube.
Is there a way?
Thanks
ishpoof
Answer:
hi,
Create a query on that infocube in order to fetch all records and in excel you can see the result and then you can get the number of records.Here the effort will be only to create a query and waiting time to execute the query.
Hope so this helps.
aasr.
Answer:
Another way would be:
SE16
If the cube is a non-business content enter
/BIC/F<name of cube>
Click on number of entries
If the cube is business content cube enter
/BI0/F<name of cube>
Answer:
Use Listschema to find the fact table and then display the number of records in it
ALRIGHT