Advanced Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 436

4. In the Additional Properties section, the Maximum Rows setting is
very useful for the designer to limit the maximum number of rows
that can be returned for a drill-through action. This is important be-
cause a cell, especially a top-level cell, could be aggregated from
millions of fact table rows. Setting the maximum rows value is always
a good practice to protect your server from accidental or malicious
operations, which will consume huge server resources. If the prop-
erty is not set, the default max drill-through row count from server
property Olap\Query\DefaultDrillthroughMaxRows is used. The de-
fault value of the setting is 10000. In the Maximum Rows text box,
type in 5000 as shown in Figure 9-44 . Deploy the project to save the
action to the server.
Figure 9-44
You can now view the drill-through results in the cube browser.
5. Click the Browser tab to open the Cube Browser. Since the action for
Finance details is on the measure group Financial Reporting, you
need to drag and drop Measures.Amount in the Financial Reporting
folder to the OWC's Detail Fields ara. Right-click on the cell and you
will see Drillthrough … as a menu item on the pop-up menu, as
shown in Figure 9-45 , indicating you can invoke the Drillthrough ac-
tion for the cell. Before you actually invoke the action, you should
limit your drill-through to a much narrower data region to prevent the
action from returning all fact tables rows if no maximum row count
limit is specified.