Enables you to define the mapping between multi-dimensional and relational databases. You must call the SetDrillThrough method for each map or unmap action.
Expression.SetDrillThrough(MapORUnMap as Boolean, String RelationalQueryName As String, DimensionOrRelationalTopicName as String, FactName as String)
MapORUnMap As Boolean—Specify the boolean argument (true or false), to map or unmap dimensions to topic names. Use a boolean value of true, to map a dimension and a topic. Use a boolean value of false, to unmap a dimension. When maps are created, an internal link is made.
RelationalQueryName As String—Specify the relational query name as a string from which you want to map or unmap a topic.
DimensionOrRelationalTopicName As String —Specify the dimension or relational topic name as a string that you want to map or unmap. The topic name and dimensional level name must have identical names to set up a mapping or unmapping.
FactName As String — Specify the topic name as a string used to map to the corresponding OLAP measure.
An expression that returns a Drill Through object
This example shows how to use the SetDrillThrough method to map the Store dimension and topic:
ActiveDocument.Sections["OLAPQuery"].SetDrillThrough( true,"Query2","Store","Sales Fact")