How to find quickly total volume of data in all DSO's & CUBE's in the system? Instead of checking the total data in DSO/CUBE one by one want to see no the data in all the DSO/CUBE?
if your DB is oracle then please seek basis help and check at Tx - DB02. Here all tables(Fact /active/change log tables) are displayed with their occupied and remaining space details.
Otherwise you can just check the Active tables and Fact tables of Infocubes. But for Infocubes that would not have any use, as InfoCube and Dimension tables have only SID-s and key figure values anyways due to the Star Schema.
Also check:
2761002 Naming convention of BW InfoObject and InfoProvider tables
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.