We have a multi provider which is based on four cubes stock,sales,production,purchase.
When we try to run the report it is taking very huge time and it consumes around 3 GB space in Dialog work process..
We have another cube which is based on Purchase,production and stock cube .. it is taking around 2 mins to run...
Can anybody tell me why its taking huge time and memory for our newly created cube ????... there is not much data in sales cube .. infact we have just filled that cube in last week..
We have not yet created Aggrigates for our sales cube..
Please help me out...
Message was edited by: