Sharepoint as a Collaboration and Productivity Tool

As we implement our Business Intelligence Sharepoint team site I have discovered that being new to Sharepoint the main challenge is to figure out how to maximize the functionality of each Sharepoint component (web part) type, here’s some suggestions that can be useful if you find yourself on the same spot:

Advertisements

This blog is moving to a new home!

From May, 2010 now new content will be published here, our new home is at:

http://www.shangyezhineng.com/blog/

You can also subscribe to our RSS feed through FeedBurner:

商业智能 Shangyè Zhìnéng (BI) The Independent Business Intelligence Blog

Sharepoint doc library files imported through windows explored are all checked out

I run into this when migrating our file server content into the Sharepoint BI Team Site,  it had to do with two settings (versioning and require checkout) that cause all files I copied into our document library through WebDAV and Windows Explorer to be checked out to my user. This was solved by temporarily turning off these settings while I imported the files again and then turning them back on:

sharepoint_allfilescheckedout

Let RSS be the backbone of your Sharepoint site

I really like the way Sharepoint sites allow you to set email alerts and use RSS feeds to track updates to keep on top of edits and additions to document library, blogs and all other those cool webparts. The only issue with email and RSS is that you have to add an RSS feed for each of those items that you want users of your site to be able to track. Bluedog Limited’s SyndicationGenerator is a web part RSS feed generator that allows you to aggregate multiple feeds into a single one that can be subscribed to by your readers, check it out…
http://www.bluedoglimited.com/Downloads/pages/SyndicationGenerator.aspx

Now about the RSS as a backbone idea… when you have distributed, matrixed or simple a new team that is just forming this kind of visibility into all aspects of your sharepoint site is key to keep everybody informed asynchronously and can be a great teambuilder when combined with twitter feeds or other micro-blog service (which can be added to the Syndication webpart too!).

DataStage: ParamName does not reference a known parameter of the job

Today I got an error that reads like this:

JobControl (@<JOB_NAME>): Controller problem: Error
calling DSSetParam($<PARAMETER_NAME>), code=-3
[ParamName does not reference a known parameter of the job]

After a quick debug/issue tracking session on Director I found out that
one of the jobs in my master sequence was missing all of our standard
parameters with database user, schema and password, since we define
them at the project level all I had to do is click on All to
default and the problem was promptly fixed.

PeopleSoft Enterprise Performance Management Warehouse Schema Naming Standards

The nicest thing about PeopleSoft after the whole PIA Metadata-driven interface and its impact on data quality is how meticulous PeopleSoft engineers are about documentation and sticking to naming standards, here’s a simplified diagram of the wharehouse architecture and the naming standard for objects in each section of the schema:

peoplesoft epm schema naming standards

peoplesoft epm schema naming standards

PeopleSoft EPM:Applying Maintenance Packs and Bundles (Updates)

We had one or two issues related to DataStage ETL maps that were skipped when we applied MP5 and multiple bundles on our development environment.  To prevent this issue from happening again I decided to re-install all of our ETL maps from scratch using a Sharepoint wiki to keep track of the update level applied to each of our projects (Main + CS & HCM Integration Updates), order of the files. The format is simple and looks very much like a check-list where the team member applying the patches initials or types in his or her name as each file is imported.  Check it out:

[Project] EPM90_OWE_MDX
Common + HCM OWE + HCM MDX Cummulative Maintenance Pack 5 (MP5) (Feb 28, 2009)
COMMON
File
Contents
Applied By
Common_Utilities_E_E1.dsx

Common Utilities

Ignacio
Common_E.dsx

Common Jobs for SETUP_OWE,SETUP_DIMENSION_MAPPER,
COMMON_DIMENSIONS,GLOBAL_DIMENSIONS

Ignacio
OWE_E.dsx

All E OWE Jobs for all Warehouses

Ignacio
HCM
File
Contents
Applied By
WHR_OWS_E.dsx

E – SETUPS and OWS Jobs

N/A
WHR_MDW_LOCAL_DIMS_E.dsx

E – LOCAL DIMENSIONS

Ignacio
WHR_COMPENSATION_MART_E.dsx

E – MDW Jobs (SKU)

Ignacio
WHR_LEARNING_AND_DEVELOPMENT_MART_E.dsx

E – MDW Jobs (SKU)

N/A
WHR_RECRUITING_MART_E.dsx

E – MDW Jobs (SKU)
Ignacio
WHR_WORKFORCE_PROFILE_MART_E.dsx
E – MDW Jobs (SKU)
Ignacio