How  can I list all the inactive objects of a cube. Is there any transaction code for it?

To check inactive objects,

Goto SE11->Utilities->Inactive Objects.
Goto SE38->Utilities->Inactive Objects.

To check all the objects (pgms, tables, classes, FM etc) of server, if they are active or not:

There is NO ONE Table which will get you all the info.

1. REPOSRC

For programs, above is the tablename.

R3STATE is the field for status.

Note :
If a program is in ACTIVE state first, and then inactive (due to some modifications), then this table will contain TWO entries for it.

a) A = active
b) I = inactive

2. Same Table for FUNCTION MODULES.

In the case of FM,
You will have to check the INCLUDE name for the corresponding FM.

eg. ZAM_FG01 = function group
ZAM_F06 = Function Name.
LZAM_FG01U02 = include name for this FM.
(it can be 02, 03, 01 etc.)

3. For Tables : DD02L
Field name = AS4LOCAL

(There will more than 1 record, if table is in inactivated state)

A Entry was activated or generated in this form
L Lock entry (first N version)
N Entry was edited, but not activated
S Previously active entry, backup copy
T Tempory version when editing

4. SVRS_GET_OBJECT_STATE
We can also use the above FM.

For the field object type, the following is necessary:

Program : REPS
Table = TABU

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP Business Warehouse Books
SAP BW Books - Certification, Interview Questions and Configuration

SAP BW Tips
SAP BW Tips and Business Information Warehouse

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com