Dear Gurus,



I have a SQL server Database (Datamart), I got the info via Impromptu
and PowerPlay Transformer, but I have big response times only for the
open data source, we are using a view to simplify the extraction with
Impormptu (IQD), we are trying to access a view with 17,000,000 records
and daily we have and aditional 400,000 every day.



The time to build the cube aprox. is two hours, but in many cases the
process increase in 400%, so we didnt know why??? we are trying to
manage the cubes in an incremental way so the time to build with or
without the incremental option its the same...



If you have some method to access this information in a better way
let me know.



Any help we gratefully appreciate.



Regards,



Guillermo


--
Posted via http://dbforums.com