howard's profileHoward @ MSFT selling BIPhotosBlogLists Tools Help

Blog


    November 09

    SharePoint 2007 on Windows Server 2008 R2

    the trick is you need a slipstream version of SP2.

    Here is how to do it

    October 15

    PPS SP3 Released

    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.

    RB 2.0 Access in Sharepoint integrated mode

    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.

    October 02

    BI Publisher

    Found this cool tool that automates publishing BI content and moving content from dev to test to production.
    September 18

    Excel Services Refresh Fails

    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

    July 03

    Force Reporting Services to clear the session cookie

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

    July 02

    SSAS cube report actions with Parameters

    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

    April 14

    Add all authenticated users

    A good best practice to avoid problems upstream.

    NT AUTHORITY\Authenticated Users

    April 07

    Crystal Report (.rpt) to Reporting Services (.rdl)

    April 06

    IT vs. Management

    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..."  

    History of BI

     

     

    March 23

    Run IE as user script

    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>

    March 13

    Tips on How To Act Like A Zombie

    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.
    March 03

    How to add a Document Icon to a Sharepoint Library

    Here are the steps to add an icon for .pdf files.  Change as appropriate for other file types.

    1. Save the image you wish to see as the PDF document icon to "\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Images\pdf.gif" - Images should be 15x15 pixels in size. (However the 17 x 17 icon from http://www.adobe.com/misc/linking.html works fine)
    2. Edit  "\Program Files\Common Files\Microsoft Shared\Web server extensions\12\Template\Xml\DOCICON.XML"
    3. Add the following line <Mapping Key="pdf" Value="pdf.gif"/>
    4. run iisreset
    February 26

    MDX Dashboard Filters

    Tired 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 2007

    Been 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 Scorecards

    You 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 fix

    Here 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”).