BPC Processor Preferences

Based on this SQL Server Central post: a processor with more cores is better for Data Warehouses / Decision Support Systems (smells like OLAP). And at this time an Intel processor is better for a transactional system (OLTP).

Changing R/3 SAP GUI Permissions

Recently I needed to apply an SAP Note to our BPC NW environment. To do this, I had to create a new ‘admin’ user and run the Notes Assistant under that new account. Before I could run the Notes Assistant, I need to grant access to the snote transaction in SAP GUI. This is how I did it:

  1. Login with DDIC
  2. Go to su01
  3. Specify user ID
  4. Change
  5. Go to Profiles tab
  6. enter SAP_ALL or whatever objects
  7. Save
  8. Exit

BPC Dimension Members and Office Version

To specify which version of Excel is used when working with Dimension members look at the tblDefaults table with the row containing KeyID MEMBERSHEET_VERSION.

You can change this to 2007 or 2003

Make sure to install MS Data Connectivity Components on the application server as well. See Note: 1289927 and this link: http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8
C28-4598-9B72-EF94E038C891&displaylang=en

Updating BPC Service Pack (Server Package) Work Instruction

Document Server Manager settings

Make a copy of BPC web.config
Make a copy of server level .NET Framework v.2.0 machine.config and web.config

Verify the Office and admin clients can connect

  • Run a report
  • Manage dimensions

Restart all servers before applying any updates to ensure nothing is locked or open.

Make backup of AppServer DB

Run Startup.exe

Some BPC NW Commands

In SAP GUI using se80 will show tables.

These table prefixes mean the following:

  • uj – BPC related
  • uja – AppSet
  • ujj – Journal
  • uje – Security

rsa1 – Data Warehousing Workbench: Modeling (view AppSet, dimension attributes and raw data here)
su01 – Create Users
snote – Run Note Assistant

SAP Supported SQL and Windows Server Versions for BPC

Windows Server

BPC 7.5 SP04 or later:

Windows Server 2008 R2 Standard or Enterprise Edition with or without Hyper-V
Windows Server 2008 Standard or Enterprise Edition with or without Hyper-V, or
Windows Server 2008 Data Center with or without Hyper-V
Windows Server 2003 Standard or Enterprise Edition SP2
Windows Server 2003 Standard configured on the SQL database or OLAP server components only
Windows Server 2003 R2 Standard or Enterprise Edition SP2

SQL Server

BPC 7.0 and 7.5 support:

SQL 2008: SP2 with Cumulative Update 1 for SP2.
SQL 2008 R2: Cumulative Update 5.

“The ABAP server specified in the server configurtion file is not reachable

Problem

When trying to log into the launch page on BPC NW 7.5 I receive either a timeout error or this:

  • The ABAP server specified in the server configurtion file is not reachable

Investigating further I find I cannot login to SAP Login

When trying to login to SAP Logon 710 I get:

partner ‘192.168.1.40:sapdp00’ not reached.
WSAECONNREFUSED: Connection refused

SAP Support suggested:

Connection refused errors are normally triggered in two situations:

– There is a firewall in the way of the connection rejecting the
communication
– The service is not running on the server

It seems that the problem here is that you are not being able to reach
the server. If you try to do a telnet test like:

telnet 192.168.1.40 3200

Are you able to open the port or you receive an error too?

I in fact cannot telnet to port 3200

Solution

  • Open SAP Management Console
  • SAP Systems > SPC > dublin 0 (our ABAP / NW server)
  • Right click on dublin 0
  • Click Start…

SP 2010: Create New Web Application and Site Collection

Create New Web Application

IIS Web Site

  1. Description: MOSS Web App – 80 (Consider TurtlePoint Web App – 80)
  2. Port: 80

Application Pool

  1. App Pool Name: MOSS Web App – 80 (Consider TurtlePoint Web App – 80)
  2. Account: spAppPool

Database Name and Authentication

  1. DB Name: MOSS_WebApp_Content

MOSS_WebApp_Content DB created
MOSS Web App Web – 80 Site created
MOSS Web App – 80 App Pool created

Create New Site Collection

Title and Description

  1. Title: Turtle Point

Template Selection

  1. Collaboration > Blank Site
  2. Activate these Site Collection Features
    1. SharePoint Server Enterprise Site Collection
    2. SharePoint Server Publishing Infrastructure
    3. SharePoint Server Standard Site Collection
    4. Publishing Approval Workflow if desired
  3. Activate these Site Features
    1. SharePoint Server Enterprise Site
    2. SharePoint Server Publishing
    3. SharePoint Server Standard Site
    4. Team Collaboration Lists

Primary Site Collection Administrator

  1. TURTLELLCAdministrator

No new database, web site or app pool created

Building a Search Center

To build a Search Center create a new site, selecting Enterprise > Search Center with Tabs.

Once the site is built, configure the following items:

  1. Search scopes
  2. Search pages
  3. Search tabs
  4. Results pages
  5. Assign scopes to result pages
  6. Results tabs
  7. Advanced Search Pages

Create a Search Scope

Scopes can be created either at the Site Collection level using SharePoint Central Administrator or at the Site Collection thru Site Actions > Site Settings > Search Scopes.

If you need to narrow a scope down to folder level, then use the Site Actions > Site Settings approach. If your scopes are broader and can be handled with Content Sources and Metadata Properties then use the SharePoint Central Administration approach.

Create a New Search Page

  1. From the Search Center
  2. Site Actions
  3. Create Page
  4. Enter a Title, Description and change the URL if desired
  5. Select (Welcome Page) Search Page
  6. Click Create

Create a New Search Tab

  1. Edit the new search page just created
  2. Click Add New Tab
  3. Enter a name for the tab
  4. Specify the name for the search page just created (ex. MySearchPage.aspx)
  5. Enter a tooltip
  6. Click OK

Create a New Results Page

Search pages and tabs work in pairs, for every search page, there must be a matching results page and for every search tab, there must be a matching results tab. A unique results page allows the assignment of unique scopes to a search.

  1. From the Search Center
  2. Site Actions
  3. Create Page
  4. Enter a Title, Description and change the URL if desired
  5. Select (Welcome Page) Search Page Results
  6. Click Create
  7. Edit the new page
  8. On the Search Box > Modify Shared Web Part
  9. Expand Miscellaneous
  10. Enter the name of the new search page created above in ‘Target search results page URL”
  11. Note you will come back after creating the Advanced Search page, to enter it’s URL in the “Advanced Search page URL”
  12. Click Apply

Assign Scopes to Result Page

  1. Continue editing the new results page
  2. On the Search Core Results web part > Modify Shared Web Part
  3. Expand Miscellaneous
  4. Enter the name of the Search Scope created above.
  5. Click Apply

Create a New Results Tab

  1. Still editing the new results page just created
  2. Click Add New Tab
  3. Enter a name for the tab
  4. Specify the name for the search page just created (ex. MySearchPageResults.aspx)
  5. Enter a tooltip
  6. Click OK

Create an Advanced Search Page

  1. Navigate back to the initial Search Center so you are not looking at a results page
  2. Site Actions > Create Page
  3. Enter a Title, Description and change the URL if desired
  4. Select (Welcome Page) Advanced Search
  5. Click Create
  6. Click Add a Web Part
  7. Check ‘Advanced Search Box’
  8. Click Add
  9. On the ‘Advanced Search Box’ > Modify Shared Web Part
  10. Expand Scopes
  11. Check ‘Show the scope picker’
  12. Change the ‘Display Group’ to the correct one
  13. Click OK
  14. Edit the New Results Page previously created
  15. On the Search Box > Modify Shared Web Part
  16. Expand Miscellaneous
  17. Enter the name of the advanced search page created in ‘Advanced Search page URL”. Be sure to include the entire path.
  18. Click Apply
  19. Edit the New Search Page previously created
  20. On the Search Box > Modify Shared Web Part
  21. Expand Miscellaneous
  22. Enter the name of the advanced search page created in ‘Advanced Search page URL”. Be sure to include the entire path.
  23. Click Apply

Be sure the check-in and publish all new and edited pages.