I have been able to create the cube structure and a successful connection while creating a local cube using data from the oracle database.

But when i compile my code it gives me the following error-fact table not found.

I have created ony 1 dimension ... The dimension tables are physically present in the oracle database...

I don't know what to do abt the fact tables... Do I have to create even the fact table physically in the oracle database...

Pls help me out...

Thnx
Loyd