Chrome OS Tips

Alt + Ctrl + T will put Chrome OS into shell mode in VirtualBox

BPC Server Version

BPC 7.5

7.5.102 : SP01
7.5.103 : SP02
7.5.104 : SP03
7.5.105 : SP04
7.5.106 : SP05

BPC 7.0

7.0.114 : SP05
7.0.115 : SP06
7.0.116 : SP07

Clearing All Rows From All Tables

This couple of SQL statements will delete all the rows from all tables.

1. It disables referential integrity
2. DELETES or TRUNCATES each table
3. Enables referential integrity
4. Reseeds rows with identity

-- disable referential integrity
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
GO

EXEC sp_MSForEachTable '
IF OBJECTPROPERTY(object_id(''?''), ''TableHasForeignRef'') = 1
DELETE FROM ?
else
TRUNCATE TABLE ?
'
GO

-- enable referential integrity again
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
GO

-- This will reseed each table [don't run this exec if you don't want all your seeds to be reset]
EXEC sp_MSForEachTable '
IF OBJECTPROPERTY(object_id(''?''), ''TableHasIdentity'') = 1
DBCC CHECKIDENT (''?'', RESEED, 0)
'
GO

Thanks to Mauro Cardarelli's post

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

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.