Large queries and network traffic
Queries on large Analysis Services cubes with freeform reporting can increase network
traffic. This can impact on distributed Analysis Services Solutions.
|
Maintenance of Analysis Services information
Managing changing names in a view for Microsoft’s Analysis Services solutions generally
requires manual updating and an element of risk. The updating process can be significant
if there are a large number of servers, databases, cubes, dimensions, members and/or
worksheets. |
Freefrom reporting can be slow and there is no data input
Most Analysis Services solutions do not allow for inputting on free-form reports,
thus restricting ease of use and presentation where data capture is required. This
often results in more views being required to cater for the differing requirements
for inputting and reporting. |