Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Archive for the ‘PeopleSoft’ Category

Why I do not use PowerConnect to access PeopleSoft Tree

Posted by Dylan Wan on March 16, 2011

1. It does not allow you to use parameters to the PeopleSoft connect. It may be changed later. However, it was a big issue when we try to address customer issues.

2. It requires EFFDT as an input.
It expects that people change the EFFDT using Mapping Editor. How can a business user does that every month?

3. It asks for a Tree Name. Many PeopleSoft tree structure supports multiple trees. Tree is just a header of the hierarchy. Whenever you add a new Tree, you need to create a new mapping!!

It does not make sense to use PowerConnect due to the customer demands. All above requirements are from customers.

We have no choice but stop using it.

It is a nice feature, but it was not designed for a prepackaged apps.

Advertisements

Posted in BI, BI Application, Business Intelligence, Data Warehouse, ETL, Infomatica, OBIEE, PeopleSoft | Leave a Comment »

Hyperion Essbase Dimension Terminology

Posted by Dylan Wan on June 20, 2008

I found the the language used in Hyperion Essbase documentation is very useful for describing the dimension hierarchy. To communicate effectively, sometime we need precise teams to describe things. The terms defined in the Hyperion Essbase documentation helps.

Read the rest of this entry »

Posted in BI, Business Intelligence, essbase, hyperion, Oracle, PeopleSoft | Tagged: , , , | 3 Comments »

Oracle BI Applications 7.9.5 is out

Posted by Dylan Wan on May 30, 2008

Oracle BI Applications 7.9.5 is released early this month. Here is a quick summary of the features introduced in this release and where you can get more information about it.

Read the rest of this entry »

Posted in BI, BI Application, BI Work, Business Intelligence, Data Warehouse, ETL, Infomatica, OBIA, OBIEE, Oracle, Oracle BI Suite EE, PeopleSoft, Siebel Analytics | Tagged: | 3 Comments »

ABC Analysis in Inventory Management

Posted by Dylan Wan on March 11, 2008

 I did some study on the ABC Analysis in Inventory Management.  It is also useful in business analytics.  I will cover what it is and how it is supported in various ERPs. Finally, how it may be used in analytics application. Read the rest of this entry »

Posted in BI, BI Application, BI Work, Business Intelligence, Data Warehouse, EBS, Oracle, PeopleSoft, Supply Chain Intelligence | 10 Comments »

Oracle BI Applications 7.9.4 is available on OTN

Posted by Dylan Wan on January 8, 2008

The latest version of Oracle Applications is now available in Oracle Technology Network.

http://www.oracle.com/technology/software/products/ias/htdocs/101320bi.html

Here is the direct link to software.

Here are some of the new features of this releases:

Read the rest of this entry »

Posted in BI, BI Application, BI Work, Business Intelligence, OBIEE, Oracle, Oracle BI Suite EE, PeopleSoft | Leave a Comment »

BI Applications and Embedded BI, Part 2

Posted by Dylan Wan on December 5, 2007

This is a topic I wrote in six month ago. In the Part I of this series of articles, I mentioned that a warehouse like architecture is required in a heterogeneous environment. I want to elaborate more about this. In the future posts, I will also describe the integration technology I learned for supporting the embedded BI.

Read the rest of this entry »

Posted in BI, BI Work, Business Intelligence, Data Warehouse, DBI, hyperion, Oracle, PeopleSoft, Siebel Analytics | Tagged: , , | Leave a Comment »

PeopleSoft EPM

Posted by Dylan Wan on November 1, 2007

PeopleSoft Enterprise Performance Management was the pre-packaged BI applications for PeopleSoft application.  It has been in market for nearly 10 year.  I recently learned its history, product coverage and architecture from my colleagues. Read the rest of this entry »

Posted in BI Application, BI Work, Business Intelligence, Data Warehouse, Infomatica, PeopleSoft | Leave a Comment »