Page 138 - DCAP606_BUSINESS_INTELLIGENCE

Unit 9: Advanced Dimensional Design

[Product].[Product by Category].Level IS [Product].[Product by Notes
Category].[Category] OR
[Product].[Product by Category].Level IS [Product].[Product by
Category].[Subcategory]

You need to select the type of action that you want to create.
Figure 9.1: Activity Tab Toolbar

Source: http://i.msdn.microsoft.com/dynimg/IC574400.gif
9. In the Action Content section of the editor, verify that URL is selected from the Type list.
The Action Expression text box includes the string that will be passed to the application
that is begun by the action.

10. In the Action Expression text box, enter the following MDX expression:
“http://search.live.com/results.aspx?q=”
+ [Product].[Product by Category].CurrentMember.Name
+ “&form=QBLH”
Now before you can execute the action, you need to deploy your project. After the project is
successfully deployed, you can browse the cube and execute the URL action that you just created.

9.3.3 Creating Drillthrough Actions

Drillthrough actions supply fast access to lowest grade of details stored in a cube. When you
create a drillthrough action, you choose dimension attributes and assesses that are returned as
columns of data when the action is performed. When a client examining summary value executes

LOVELY PROFESSIONAL UNIVERSITY 133