| howard's profileHoward @ MSFT selling BIPhotosBlogLists | Help |
|
November 09 SharePoint 2007 on Windows Server 2008 R2the trick is you need a slipstream version of SP2. October 15 PPS SP3 ReleasedMicrosoft 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. RB 2.0 Access in Sharepoint integrated modeOn 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. October 02 BI PublisherFound this cool tool that automates publishing BI content and moving content from dev to test to production.
September 18 Excel Services Refresh Fails
July 03 Force Reporting Services to clear the session cookiePass this string: &rs:ClearSession=True to the Section in a PPS RS Report Setings. July 02 SSAS cube report actions with ParametersHere 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 April 15 Report Builder 2.0 Click Once
April 14 Add all authenticated usersA good best practice to avoid problems upstream. NT AUTHORITY\Authenticated Users April 07 Crystal Report (.rpt) to Reporting Services (.rdl)
April 06 IT vs. ManagementA 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..." March 23 Run IE as user scriptDim wshShell if (wscript.Arguments.Count < 2) then '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> March 13 Tips on How To Act Like A ZombieHere is some useful info from the Xbox360 Marketing Team with the release of Resident Evil 5
March 03 How to add a Document Icon to a Sharepoint LibraryHere are the steps to add an icon for .pdf files. Change as appropriate for other file types.
February 26 MDX Dashboard FiltersTired a clicking and adding children to your Dashboard Filters. Use this MDX expression. This will get the 'All' member, the District level and its children. What's great is that it is dynamic, so if another Store gets added to a District it will be updated with the new data. Descendants([Store].[Geography].[All], [Store].[Geography].[District], SELF_AND_BEFORE) Add Advanced Search to a Top Level Team Site in MOSS 2007Been messing around with search now that PPS is a MOSS e-cal feature. Still got a ways to go to guru status, but this little nugget is most useful. http://blog.funknstyle.com/?p=578 Basically, you create a Search Center, get the URL for the advanced search page, and paste it into the Custom Scopes of the Top Level site search settings. January 12 Member Properties in ScorecardsYou can access member properties as a target of a KPI using an MDX expression like [Product].[Product].CurrentMember.Properties("Member Property") January 07 SSRS2008 Sharepoint Integrated Mode fixHere are some notes on SSRS2008 in an integrated mode: 1. When integrating Reporting Services you will need to install the rsSharePoint.msi in order to set the configuration properties in SharePoint and use the Report Viewer. 2. Before you install it, go into Component Services and select DCom. a. Right click IS_WamReg → Properties. b. Open the Security tab and under custom security, add your SharePoint and Reporting Services service accounts giving them launch and activate permissions. c. If necessary, you can also give them remote launch and remote activate permissions. d. Reset IIS ( open command window and type iisreset ) 3. Next install rsSharePoint.msi using the following command: msiexec /I yourfilepath\rsSharePoint.msi SKIPCA=1 (that is a capitol letter “i” after the “/”). 4. Switch to your %temp% directory and run the following command: rscustomaction.exe /I (again a capitol letter “i”). |
|
|