User login

Blogs

sudhir's picture

Ten Mistakes to Avoid for Data Warehouse Project Managers -<Part -2>

 

3. Failing to Involve the Business People

sudhir's picture

Ten Mistakes to Avoid for Data Warehouse Project Managers -<Part -1>

Most organizations treat project management as an administrative function. A project manager often “manages” multiple projects. However, a more accurate way to define a project manager would be to say that he or she “administers” multiple projects because he/she is rarely involved in any daily project activities. The project teams merely report to him/her. Project managers, assuming that data warehouse projects are like any other project, are often surprised when their data warehouse project spins out of control.

sudhir's picture

The integration of business intelligence and knowledge management

Enterprise executives understand that timely, accurate knowledge can mean improved business performance. Two technologies have been central in improving the quantitative and qualitative value of the knowledge available to decision makers: business intelligence and knowledge management. Business intelligence has applied the functionality, scalability, and reliability of modern database management systems to build ever-larger data warehouses, and to utilize data mining techniques to extract business advantage from the vast amount of available enterprise data.

Peter B. Giblett's picture

Adding Competitive Intelligence to your Corporate Toolbox

BI & Enterprise Performance Management is becoming important to corporate development. One of the most powerful capabilites that can be added is Competative Intelligence.Should your organisation consider the use of Competative Intelligence? Yes

How to Enable Assumptions at the Entity Level in Capital Expense Planning

When using multiple entities, you must update data forms and business rules to ensure that
business rules apply to different departments.
Updating Data Forms to Use Multiple Entities
➤ To update data forms to use multiple entities:
1 In Planning, edit these data forms to update the Point of View dimensions:
● 01. Global Capital Assumptions
● 15A. Global Capital Assumptions - Depreciation only
a. Select Administration > Manage Data Forms.
b. Select the data form to edit, such as 01. Global Capital Assumptions, then click Edit.
c. Select Page/Point of View Layout.

Adding a Project Dimension in Capital Expense Planning

You can add a Project dimension with information that fits your business needs.
Creating the Project Dimension
Depending on whether you have a Performance Management Architect application or a Classic
Application.
With Performance Management Architect Applications
➤ To create a Project dimension in Performance Management Architect Applications:
1 In the Performance Management Architect Master View, create a generic Project dimension and a Dimension Alias with these properties:
● Dimension Name: Project
● Dimension Class: Generic
● Dimension Alias: Project

Predefined Business Rules in Capital Expense Planning

Planners use predefined business rules to calculate capital expense data.

CalcDepr
Description
Calculates depreciation.
Formula
SET CREATENONMISSINGBLK ON;
SET UPDATECALC OFF;
SET AGGMISSG ON;
VAR periodOffset = 0;
VAR deprMethod = 0;
VAR deprRate = 0;
VAR deprConvention = 0;
VAR numDeprPeriods = 0;
VAR totDeprPeriods = 0;
VAR persIn1stYear = 12;
VAR priorAccumDepr = 0;
VAR periodicPriorAccumDepr = 0;
VAR basicCost = 0;
VAR salvageVal = 0;
VAR deprAmt = 0;
VAR deprAmtLast = 0;
VAR persInSection = 0;
VAR life = 0;
VAR lifeIndex = 0;
VAR isAnnual = 0;

Syndicate

Syndicate content