Its getting late, so please excuse me if this is obvious:
From transaction code DB02 can I just use the Sample size (as the number of rows in the table) and then whatever dimension I wish to analyze use the distinct value column? To determine cardinality as the ratio of the Distinct Value: Sample Size.
Also to confirm that I should be using the F fact table as the table that I analyse. Thanks in advance.