Howard @ MSFT selling BI

I always forget this syntax to get previous member in MDX

([DimName].[HierarchyName].CurrentMember.PrevMember, [Measures].[MeasureName])

the trick is you need a slipstream version of SP2.

Here is how to do it

Microsoft Office PerformancePoint Server 2007 Service Pack 3 hits RTM on schedule and is available for download from the Microsoft Download Center.

· Download sites: PerformancePoint Server 2007 SP3 (x86), PerformancePoint Server 2007 SP3 (x64)

· Documentation:  Service Pack 3 for Microsoft Office PerformancePoint Server 2007, IW documentation is being published.

On a SharePoint integrated mode report server, Report Builder 1.0 or Report Builder 2.0 access is granted to SharePoint users who have either Contribute or Full Control permission levels.

1. check the sharepoint log (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS if you get the error Excel Services can not use credential delegation when it is configured to use a trusted subsystem with Windows SharePoint Server
2. change Excel Services to use Delegation Mode

stsadm -o set-ecssecurity -accessmodel delegation -ssp SharedServices1

stsadm -o execadmsvcjobs

iisreset

Pass this string: &rs:ClearSession=True to the Section in a PPS RS Report Setings.

Here is how you do it.

Create the report action in the cube

Servername: <servername>:<port>

Report path: reportserver?http://<servername>/Reports/ReportsLibrary/<reportname>.rdl

Parameter Name: <name>

Parameter Value: UrlEscapeFragment( [Dim].[Attribute].CurrentMember.MEMBER_CAPTION)

This will pass the value as a string.

In the report, create a parameter in the report data area

- General: name, prompt, text, visible

- Available values: none

- Default values: none

In the row groups, group properties, filters, add

- Expression: [Dim] =

- Value: @ParamName

Please find links for BI VPC R7.1

http://download.microsoft.com/download/E/5/0/E508CE7B-2726-4B6D-813A-033D78072E83/BI VPC R7.1.part01.exe

http://download.microsoft.com/download/E/5/0/E508CE7B-2726-4B6D-813A-033D78072E83/BI VPC R7.1.part02.rar

http://download.microsoft.com/download/E/5/0/E508CE7B-2726-4B6D-813A-033D78072E83/BI VPC R7.1.part03.rar

http://download.microsoft.com/download/E/5/0/E508CE7B-2726-4B6D-813A-033D78072E83/BI VPC R7.1.part04.rar

http://download.microsoft.com/download/E/5/0/E508CE7B-2726-4B6D-813A-033D78072E83/BI VPC R7.1.part05.rar

http://download.microsoft.com/download/E/5/0/E508CE7B-2726-4B6D-813A-033D78072E83/BI VPC R7.1.part06.rar

http://download.microsoft.com/download/E/5/0/E508CE7B-2726-4B6D-813A-033D78072E83/BI VPC R7.1.part07.rar

• Install SQL Server 2008 SP1
• Install RS Add in to Sharepoint (if not already installed)
• Install Report Builder 2.0 Click Once