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:
- Login with DDIC
- Go to su01
- Specify user ID
- Change
- Go to Profiles tab
- enter SAP_ALL or whatever objects
- Save
- 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
SAP Cryptographic Software (XceedZip.dll, Anti-Cross Site Scripting and AmyUniPDF)
To download the XceedZip.dll, Anti-Cross Site Scripting and AmyUniPDF files for BPC go to:
SAP Service Marketplace > SAP Support Portal > Software Downloads > Software Download Center > Installations and Upgrades > Browse our Download Catalog
On the page displayed you will find a link to SAP Cryptographic Software.
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
- Description: MOSS Web App – 80 (Consider TurtlePoint Web App – 80)
- Port: 80
Application Pool
- App Pool Name: MOSS Web App – 80 (Consider TurtlePoint Web App – 80)
- Account: spAppPool
Database Name and Authentication
- 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
- Title: Turtle Point
Template Selection
- Collaboration > Blank Site
- Activate these Site Collection Features
- SharePoint Server Enterprise Site Collection
- SharePoint Server Publishing Infrastructure
- SharePoint Server Standard Site Collection
- Publishing Approval Workflow if desired
- Activate these Site Features
- SharePoint Server Enterprise Site
- SharePoint Server Publishing
- SharePoint Server Standard Site
- Team Collaboration Lists
Primary Site Collection Administrator
- 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:
- Search scopes
- Search pages
- Search tabs
- Results pages
- Assign scopes to result pages
- Results tabs
- 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
- From the Search Center
- Site Actions
- Create Page
- Enter a Title, Description and change the URL if desired
- Select (Welcome Page) Search Page
- Click Create
Create a New Search Tab
- Edit the new search page just created
- Click Add New Tab
- Enter a name for the tab
- Specify the name for the search page just created (ex. MySearchPage.aspx)
- Enter a tooltip
- 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.
- From the Search Center
- Site Actions
- Create Page
- Enter a Title, Description and change the URL if desired
- Select (Welcome Page) Search Page Results
- Click Create
- Edit the new page
- On the Search Box > Modify Shared Web Part
- Expand Miscellaneous
- Enter the name of the new search page created above in ‘Target search results page URL”
- Note you will come back after creating the Advanced Search page, to enter it’s URL in the “Advanced Search page URL”
- Click Apply
Assign Scopes to Result Page
- Continue editing the new results page
- On the Search Core Results web part > Modify Shared Web Part
- Expand Miscellaneous
- Enter the name of the Search Scope created above.
- Click Apply
Create a New Results Tab
- Still editing the new results page just created
- Click Add New Tab
- Enter a name for the tab
- Specify the name for the search page just created (ex. MySearchPageResults.aspx)
- Enter a tooltip
- Click OK
Create an Advanced Search Page
- Navigate back to the initial Search Center so you are not looking at a results page
- Site Actions > Create Page
- Enter a Title, Description and change the URL if desired
- Select (Welcome Page) Advanced Search
- Click Create
- Click Add a Web Part
- Check ‘Advanced Search Box’
- Click Add
- On the ‘Advanced Search Box’ > Modify Shared Web Part
- Expand Scopes
- Check ‘Show the scope picker’
- Change the ‘Display Group’ to the correct one
- Click OK
- Edit the New Results Page previously created
- On the Search Box > Modify Shared Web Part
- Expand Miscellaneous
- Enter the name of the advanced search page created in ‘Advanced Search page URL”. Be sure to include the entire path.
- Click Apply
- Edit the New Search Page previously created
- On the Search Box > Modify Shared Web Part
- Expand Miscellaneous
- Enter the name of the advanced search page created in ‘Advanced Search page URL”. Be sure to include the entire path.
- Click Apply
Be sure the check-in and publish all new and edited pages.
