Problem There are several aspects that can take a toll on performance for your Analysis Services cubes.
I tweeted about ORM last week, and since then several people have asked me to clarify what I meant. I have actually previously written about ORM , but it was in the context of a larger discussion about SQL and I shouldn't have confused the two issues.
Data transfer object ( DTO ) [ 1 ] [ 2 ] is a design pattern used to transfer data between software application subsystems. DTOs are often used in conjunction with data access objects to retrieve data from a database . [ 1 ] [ 2 ] The difference between data transfer objects and business objects or data access objects is that a DTO does not have any behavior except for storage and retrieval of its own data ( accessors and mutators ).