Find Which Table(s) Contain a Column and the INFORMATION_SCHEMA Namespace.

To find which table(s) contain the PersonID column try this:

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%PersonID%'

In the AdventureWorks DB this is what you see:


So of course you can search for any column, not just PersonID.

Another interesting tidbit is that any ANSI compliant DBMS provides the INFORMATION_SCHEMA namespaces. From this namespace you have access to the metadata on any DB object. You can look up information on Stored Procedures and Functions using INFORMATION_SCHEMA.ROUTINES or use any of the many different objects within this namespace: COLUMNS, ROUTINES, CHECK_CONSTRAINTS, PARAMETERS, TABLES, etc.

Enjoy

Modifying Forecast Input Templates

OPEN INPUT TEMPLATE FOR EDITING

1. eTools -> Open Dynamic Templates
2. Input Schedules -> 09 Input Templates
3. Open 'Forecast Input Template 2009.xlt'

UPDATE FORECAST TEMPLATE TO REFLECT NEW MONTH OF ACTUALS

1. Change Cell A4 and BA6 to the new FCST Month

MODIFY EVGTS FORMULAS

1. If we are modifying to prepare for October Month End, then we will copy Cells Q15:Q233 to R15:R233
2. Update Cells R12 and R13 to say ACT and OCT in Black Font

MODIFY EVSEND FORMULAS

1. If we are modifying to prepare for October Month End, then we will copy Cells BI15:BI233 to BJ15:BJ233

Opening a Period for Forecasts

. Run the BPC Admin Tool
. Click Manage Security
. Expand Member Access Profiles
. Select Category Upload Switch
. Click Modify member access profile
. Click on BPC Access tab
. Find the Member row (i.e. AprFcst) and change its Access to Read & Write
. Click Next
. Click Apply

Adding New Rates in BPC

To add new rates:

1. Login to the Rate application in BPC
2. eSubmit -> Open Schedule Library
3. Open Rate Input Schedule.xlt
4. In Current View, change Category to ACTUAL and Time to 2009.TOTAL
5. Click Expand All
6. Enter new rates for the month affected
7. eSubmit -> Send and Refresh Schedules
8. Select Active worksheet and click Refresh