Feeds:
Posts
Comments

Archive for July, 2010

The alternative way is to access the cube through HTTP. For example, to connect to “MyMachine” from the MDX sample application, you should be able to connect to the Analysis Services server using “http://MyMachine/olap/msmdpump.dll” as a server name.
 
The blog below explains it all:
 
 
 

Read Full Post »

There are 3 types of actions that you can configure:
– General action
– Drillthrough action
– Reporting action
 
Good examples of the above are provided in the Adventure Works DW 2008 sample cube.
 
An example of a general action is City Map.  When you browse a list of cities in the cube and you want to know the city map, you right click on to the cell member then select "View map for … ".  It will then pop up a URL link that you specified to view the map on the Internet.
 
Action expression:
 
// URL for linking to MSN Maps
"http://maps.msn.com/home.aspx?plce1=" +
 
// Retreive the name of the current city
[Geography].[City].CurrentMember.Name + "," +
 
// Append state-province name
[Geography].[State-Province].CurrentMember.Name + "," +
 
// Append country name
[Geography].[Country].CurrentMember.Name +
 
// Append region paramter
"&regn1=" +
 
// Determine correct region paramter value
Case
    When [Geography].[Country].CurrentMember Is
         [Geography].[Country].&[Australia]
    Then "3"
    When [Geography].[Country].CurrentMember Is
         [Geography].[Country].&[Canada]
         Or
         [Geography].[Country].CurrentMember Is
         [Geography].[Country].&[United States]
    Then "0"
    Else "1"
End
 
// The "plce1" parameter represents a named location.
// The "regn1" parameter indicates the region in which
// the named location is located.
// 0 = North America
// 1 = Europe
// 2 = World Atlas
// 3 = Australia
// 4 = Brazil
 
 
Drillthrough action is straightforward. You specify which measure group member and columns you want users to drillthrough.
 
 
Reporting action is an action which takes you to view the Reporting Services report. This action requires both Reporting Services and the Reporting Services sample reports be installed on the local machine or server.
 
Server name: localhost
Report path: ReportServer?/AdventureWorks 2008R2/Reseller Sales
Report format: HTML5
 
Parameters (optional):
Parameter Name: ResellerReseller. The parameter name must match the parameter name in the Reporting Services report.
Parameter Value: UrlEscapeFragment([Reseller].[Reseller].CurrentMember.UniqueName). It won’t work if you don’t use the UrlEscapeFragment function.
 
Caption is MDX: true
Caption: "Store Contacts for " + [Reseller].[Reseller].CurrentMember.Member_Caption + "…"
 
 
 

Read Full Post »

The following blog explains it all
 
 
 

Read Full Post »

%d bloggers like this: