In Performance Modeler we can easily create a drill-through from a link. Refer here for creating link.

Double click the link and in properties window select Yes for Generate Drill through objects?

93

Define the drill-through target view in Drill Through Options, click on 52 icon.

Move the dimension to desired section using arrow on the right side.

94

Open the target cube of the link (we will drill from this cube), right click on the value and select drill.

95

It will open up the source cube of the link.

96

Remember to give the user access to drill through process and cube.

97

Creating drill through from Server Explorer (Architect / Perspectives) requires more steps. First create view on the source cube of the link (the view that will be drilled to).

98

Right click on the target cube of the link (we will drill from this cube), select Drill, select Create Drill Process.

99

Select default element

100

Select Datasource Type: Cube View and click Browse to select the view that we have created.Click OK and Click Finish.

101

Type the process name and click OK.

102

Right click on the target cube of the link (we will drill from this cube), select Drill, select Create Drill Assignment Rules. ‘Average Monthly Revenue’ is the measure to drill from and ‘NewStorePlanToStoreCostDrill’ is the drill process we defined above. Click Save and close.

103

Right click on ‘Average Monthly Revenue’ and select Drill.

104

It will open up the view that has been defined.

105

Leave a Reply

Your email address will not be published. Required fields are marked *