Howard @ MSFT selling BI

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

A good best practice to avoid problems upstream.

NT AUTHORITY\Authenticated Users

• KTL Solutions - Crystal Converter 2.0
• Bluefoxsoftware - White Tiger
• Sonata - Migration Service Offering
• Hitachi - Migration Service Offering
• Vision Harvest - Migration Service Offering
• Online Conversion Services:  RptToRdl at http://www.rptordl.com ($25-$149 per report)
• DataReference at http://www.datareference.com ($20 per report)

A man in a hot air balloon, realizing he was lost, reduced altitude and spotted a woman below. He descended further and shouted to the lady "Excuse me, can you help me? I promised a friend I would meet him an hour ago, but I don't know where I am" 

The woman below replied, "You're in a hot air balloon, hovering approximately 30 feet above the ground. You're between 40 and 41 degrees north latitude and between 59 and 60 degrees west longitude." 

"You must be in IT," said the balloonist. 

"Actually I am," replied the woman, "How did you know?" 

"Well," answered the balloonist, "everything you have told me is technically correct but I've no idea what to make of your information and the fact is I'm still lost. Frankly, you've not been much help at all. If anything, you've delayed my trip." 

The woman below responded, "You must be in Management." 

"I am," replied the balloonist, "but how did you know?" 

"Well," said the woman, "you don't know where you are or where you're going. You have risen to where you are due to a large quantity of hot air. You made a promise, which you've no idea how to keep, and you expect people beneath you to solve your problems. The fact is you are in exactly the same position you were in before we met, but now, somehow, it's my f***ing fault..."  

Dim wshShell
set wshShell = WScript.CreateObject("WScript.Shell")

if (wscript.Arguments.Count < 2) then
    wscript.echo "Missing Domain User Password parameter."
    wscript.quit
end if

'wscript.echo "Opening Internet Explorer as " & wscript.Arguments(0) & "\" & wscript.Arguments(1)

wshShell.Run "cmd.exe /c ""title StartIE & runas.exe /user:" & wscript.Arguments(0) & "\" & wscript.Arguments(1) & " ""%ProgramFiles%\Internet Explorer\IEXPLORE.EXE"""""

wscript.Sleep(1000)

wshShell.AppActivate "StartIE"

wshShell.SendKeys wscript.Arguments(2) & "{ENTER}"

Save this script then create a shortcut with this as the target

C:\<path>\StartIEAsUser.vbs <domain>  <user> <password>

Here is some useful info from the Xbox360 Marketing Team with the release of Resident Evil 5

• Make moaning and gasping sounds when you breathe through your mouth. It adds great effect. Your jaw should hang slack at most times. If you must make other noises, talk in gibberish or moan louder/higher. Moaning always works.
• Shamble, don't walk. Lean forward and almost fall with every step. Adding a limp or dragging one leg works great as well. Swing your arms limply, like you don't ever use them.
• When passing people, growl or groan at them and wave your arms. Some higher-level zombies tend to moan for "BRAINS!!!" as well.
• Be stupid. The average zombie has an IQ barely above freezing temperature. They will run into walls, trip, fall, and can't work with their hands.