You can find it at edelivery.oracle.com
with the following Location:

http://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=9455004

or

Select a Product Pack: Hyperion Performance Management and Bi

Platform: Microsoft windows 32 bit

click go…

Select Hyperion Performance Management and BI (9.3.1) Microsoft Windows (32-bit)

You can simply copy the LDAP folder from another hyperion server which is in “Good Condition”. Then replace your corrupted folder with the good one. It will definitely run. ^_^

Cheers,

Hanson

Now i realize that you can import and export data forms in planning…

You can use the FormDefUtil.cmd to export and import dataforms.
The default path for version 11.1.1 is on C:\Hyperion\products\Planning\bin
NOte: you should be provisioned as admin to be able to do this

Step 1: open the command prompt
Click start, Run, Type cmd

Step 2: Locate the path of FormDefUtil.cmd in our case it is located in our default path which is C:\Hyperion\products\Planning\bin
type cd C:\Hyperion\products\Planning\bin press enter

Step 3: Export the dataform from the application (This will export all the dataforms)
The correct syntax for exporting the dataform is:

Usage: FormDefUtil [-f:]

In this case I type:
FormDefUtil.cmd export -all localhost admin VSHI

Step 4: You will ask for the password
In my case my i type password

Step 5: Wait for the util to process the command. If you have done successfully.
It will look like below:

[INFO] RegistryLogger – REGISTRY LOG INITIALIZED
[INFO] RegistryLogger – REGISTRY LOG INITIALIZED
C:\Hyperion\common\config\9.5.0.0\product\planning\9.5.0.0\planning_1.xml
displayName = Planning
componentTypes =

priority = 50
version = 9.5.0.0
build = 1
location = C:\Hyperion\products\Planning
taskSequence =

task =

using Java property for Hyperion Home C:\Hyperion
Setting Arbor path to: C:\Hyperion\common\EssbaseRTC\9.5.0.0
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Entering A
udit Client http://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Initializi
ng Manager for the serverhttp://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.manager.AuditContext – Creating N
ew Audit Client Instance …. http://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Audit Clie
nt has been created for the server http://paolynl.misnet.com.ph:28080/interop/Au
dit
Form exported complete.
Form exported complete.
Form exported complete.
No composite form found.
d{ISO8601} INFO Thread-14 com.hyperion.audit.client.runtime.AuditRuntime – Writi
ng Audit Records for migrated Artifacts …
d{ISO8601} INFO Thread-14 com.hyperion.audit.client.runtime.AuditRuntime – Store
d Audited Data Successfully !!!

Step 6: check the dataforms in xml file in the following location:
C:\Hyperion\products\Planning\bin

Step 7: To import to the application the following command is the same:
Usage: FormDefUtil [-f:]

in my case i type:
FormDefUtil.cmd import -all localhost admin VITest

NOte: You will use import instead.

Step 8:Finish check the form in the application

I am having a hardtime looking for essbase and planning knowledge modules using odi.
Here are the links.

The particular PRODUCT PACK for:

Oracle Data Integrator Adapter for Hyperion Planning Release 9.3.1.1 Installation files
Oracle Data Integrator Knowledge Module for Essbase Release 9.3.1.1 Installation files

for Oracle Data Integrator Knowledge Module for Essbase Release 9.3.1.1 Installation files:

* Go to E-Delivery, http://edelivery.oracle.com, and login by providing the requested information.
* On the search page, select the following from the drop down menus:
o Select a Product Pack = Oracle Fusion Middleware
o Platform = select appropriate platform e.g. Microsoft Windows (32-but)
* On the search results page, scroll down and click on the Oracle® Application Server 10g Release 3 (10.1.3) Media Pack for Microsoft Windows (32-bit) link.
* Scroll down to:

*then planning module can also be found on that same page.
gudluck and Cheers!

My sister forced me to write a Turbo C program.
Where i the user can do the following:
a. convert a decimal to octal
b. Convert an octal to decimal
c. convert a decimal to hex
d. convert a hex to decimal

After thinking so many things. And formulating a lot of loops, trying to find out if turbo c has midstrig function that can extract each numbers.
Hehehe it seems to me that i complicate things.

This is the output program after reading books on turbo c:

#include<stdio.h>
main()
{

char choice;
int val;

printf(“Please Enter your Choice”);
printf(“(1) Decimal to Octal”);
printf(“(2) Octal to Decimal”);
printf(“(3) Decimal to Hex”);
printf(“(4) Hex to Decimal”);

choice=getche();

case (1):
printf(“Please Enter a decimal value to convert”);
scanf(“%d, &val “);
printf(“The octal value is %o”, val);
break;

case (2):
printf(“Please Enter an octal value to convert”);
scanf(“%o, &val “);
printf(“The decimal value is %d”, val);
break;

case (3):
printf(“Please Enter a decimal value to convert”);
scanf(“%d, &val “);
printf(“The hex value is %x”, val);
break;

case (4):
printf(“Please Enter a hex value to convert”);
scanf(“%x, &val “);
printf(“The octal value is %d”, val);
break;

default:
printf(“Input Error”);

}

i have learned that turbo c has a format converter for printf and scanf. So it is easy to convert to different number system.
Unlike assembly language that you have to control by bits hehehe.

For those people who are looking for a script to be able to attach database to sql server 2005 here is a sample script:

USE [master]

GO

CREATE DATABASE [AdventureWorksDW] ON

(FILENAME = N’D:\files\databases\adventureworksBW\AdventureWorksDWData.mdf’ ),

(FILENAME = N’D:\files\databases\adventureworksBW\AdventureWorksDWLog.ldf’ )

FOR ATTACH ;

GO

or simply:

USE [master]

GO

CREATE DATABASE [database name] ON

(FILENAME = N’[path\filename.mdf]‘ ),

(FILENAME = N’[path\filename.ldf]‘ )

FOR ATTACH ;

GO

the following [] should be replaced, .mdf is the primary file while .ldf s the log file

About Hyperion Financial Management

Hyperion Financial Management is a centralized, scalable, financial management and reporting solution. With Hyperion Financial Management users can unify their financial information (actuals, budgets, forecasts, statistics) in a single Web-based application. Hyperion Financial Management contains packaged features to support these tasks and practices:

•	Managing compliance with global reporting standards, currency management, automating inter-company activities and producing auditable results.

•	Linking legal and management reporting with operating plans to achieve enterprisewide consistency and visibility.

•	Multidimensional, line-of-business analysis.

•	Improved collaboration through the Web.

•	The addition of key external industry metrics to the system to provide one central point of financial intelligence.

Designed for large-scale, centralized Web deployment, Hyperion Financial Management acts as a shared financial resource for thousands of users across the enterprise. It enables them to collaborate and cooperate in the day-to-day management of business. In the same application, they can product auditable reports and forecasts for external consumers, such as regulatory bodies, financial analysts, stakeholders and business partners.

Financial Management

Current Business Issues Most companies face the following issues with regard to their financial information: 1.  Increased accountability and financial integrity 2.  Higher public scrutiny 3.  Stricter legislation. Sarbanes-Oxley Act.  This act was introduced to enforce stricter accounting requirements on publicly traded corporations.  The area of focus of this act include: a.  Auditor independence. b.  Corporate responsibilities. c.  Financial reporting. As per the Sarbanes-Oxley act, Chieft Executive Officers (CEOs) and Chief Financial Officers (CFOs) are required to sign financial statements to attest their validity. The act requires a shorter reporting time for quarterly and annual financials.  The duration for filing 10Qs, which are quarterly financial statements, has been reduced from 45 to 35 days.  Similarly for 10Ks, which are annual financial statements, the duration has been reduced from 90 to 60 days.  This puts tremendous pressure on companies to reduce the consolidation process duration. 4.  Transforming roles and responsibilities 5.  Increased process efficiency 6.  Higher value put on foresight 7.  Increased competitive pressures and benchmarks

Hyperion Financial Management (HFM)

Hyperion System 9 Financial Management is a comprehensive, Web-based financial systems application.  It delivers global collection, reporting, and analysis in a single, highly scalable financial management solution. Over 900 companies, worldwide, use Financial Management to accelerate financial reporting cycles, and reduce costs of compliance with the Sarbanes-Oxley act, International Financial Reporting Standards (IFRS), and other regulatory requirements. Key Features include: 1.  Complete audit trails, workflow, and security. 2.  Smart dimensionality, that is, the ability to define up to four custom dimensions per account for capturing operational and financial results. 3.  Flexible What-If scenario management. 4.  Extensive customization capabilities including powerful business rules language. 5.  Fully Web-architected as a centralized, scalable application that can be accessed by thousands of users through a Web browser. Key Benefits include: 1.  Improves the financial close and reporting process, and can help reduce internal control risk. 2.  Helps reduce the cost of compliance as stipulated by the Sarbanes-Oxley act, BASEL II, and other regulatory requirements in building a sustainable compliance framework. 3.  Enables users to spend less time on processing and more time on value-added analysis. 4.  Helps deliver a single version of the truth to support financial management and statutory reporting. 5.  Integrates not only with Hyperion products, but also with a company’s existing infrastructure. Chevron Case Study Financial Management helped Chevron face the following challenges: 1.  Meet Sarbanes-Oxley requirements 2.  Streamline the financial consolidation process 3.  Meet reporting needs of employees and managers The results of using Financial Management were as follows: 1.  Eliminated 12 pre-consolidation applications 2.  Consolidated 2,000 financial reports into 600 3.  Eliminated three Microsoft Access databases 4.  Extended ad hoc reporting tools to employees

FINANCIAL MANAGEMENT ADDITIONAL FEATURES

A. Epm Calculation Manager

1. Epm Calculation Manager Definition
   1. Is a graphical EPMA tool for designing, validating, and administering business rules for use in Financial Management and Planning applications.
   2. Sets up reusable components that can be shared in different applications
   3. Works with predefined templates to create rules
   4. Organizes business rules into Rule Sets
   5. Replaces the Rules Editor
2. EPMA Calculation Manager: Benefits
   1. Easy way to create complex financial calculations in Financial Management and Planning

i. Graphical flow provides a better understanding of calculation process.

ii. Reusable rules can be shared among applications.

iii. Existing templates can be used to build rules

1. 1. Central repository of all calculation objects

i. One place to maintain all calculation rules

ii. Organize business rules using folders and rule sets

1. EPMA Calculation Manager: Level of Objects

B. Financial Management Functional Enhancements

1. Equity Pickup

• Is an accounting technique that reevaluates the investments owned by a holding company.

• The technique adjusts the investments in the company’s balance sheet to reflect the current value of the corresponding share in the equity of the subsidiary.

2. Phase Submission Enhancements

• When configuring scenarios, users can enter the Process Management start year with phased submission (Process Management does not apply to years prior to the start year).

• In the Phases Submissions Setup window, users can enter “All” instead of an asterisk (*) to specify all submission groups.

3. Matching Tolerance as % of Transaction

• When specifying a matching tolerance for a period, a user can specify an amount, a percentage, or both for Transaction ID (TID) Tolerance.

• The percentage is applied to the smaller of the entity or partner transaction.

4. Formatting Reports with Oracle BI Publisher

• Oracle BI Publisher report templates enable users to format Financial Management system reports.

• The report templates offer new print options, including PDF, RTF, HTML, and XLS.

Hyperion Reporting analysis Architecture

FINANCIAL MANAGEMENT OVERVIEW:

Hyperion Financial Management is a centralized, scalable, financial management and reporting solution. With Hyperion Financial Management users can unify their financial information (actuals, budgets, forecasts, statistics) in a single Web-based application. Hyperion Financial Management contains packaged features to support these tasks and practices:

•	Managing compliance with global reporting standards, currency management, automating inter-company activities and producing auditable results.

•	Linking legal and management reporting with operating plans to achieve enterprisewide consistency and visibility.

•	Multidimensional, line-of-business analysis.

•	Improved collaboration through the Web.

•	The addition of key external industry metrics to the system to provide one central point of financial intelligence.

Designed for large-scale, centralized Web deployment, Hyperion Financial Management acts as a shared financial resource for thousands of users across the enterprise. It enables them to collaborate and cooperate in the day-to-day management of business. In the same application, they can product auditable reports and forecasts for external consumers, such as regulatory bodies, financial analysts, stakeholders and business partners.

Hyperion Financial Management Features

Hyperion Financial Management contains features to support:

•	A single, unified view of enterprise financial information consolidates key performance and operating metrics from global sources in a scalable, Web-based application.

•	“Virtual close” features trim days and weeks off your close cycle using Web-based intercompany reconciliations and a consistent set of data and business measures.

•	Powerful multidimensional analysis identifies and reports new sources of profitability and cash flow at corporate, cost center, product, brand, customer, and channel levels.

•	Flexible “what if” scenario management feature dynamically consolidates and reports all financial budgets, forecasts and plans, producing new statements as assumptions and facts change.

•	High-volume, preformatted reports deliver timely, accurate financial information for internal management as well as for external regulatory and government bodies, from the same application.

•	Prepackaged features are deployed out-of-the-box, quickly and cost- effectively, including features such as world-class allocations, multicurrency translations, and robust data integration with legacy applications, ERP, and CRM systems.

•	Customizable and extensible application solves your specific issues quickly and cost-effectively, using industry standard tools.

•	Architected for the Web so users can easily and securely access global financial information from any location, using a standard Web browser. Relational data storage ensures mission critical data is available to users 24x7x365.

FINANCIAL MANAGEMENT ARCHITECTURE:

Architecture

Hyperion Financial Management is designed to operate as a multi-tier system.

•	The client tier contains the user interface and the ability to communicate with the application tier. You can display data and metadata, enter data, and maintain metadata in this tier.

•	The Web server tier contains the Web server. You can access the Web-enabled portions of Hyperion Financial Management in this tier. The Hyperion Financial Management Web client contains all functionality available in the Windows client with the exception of security administration.

•	The middle tier contains the domain intelligence and connections to the relational database.

•	The data tier contains the relational database and all Hyperion Financial Management data and metadata.

The following figure shows the Hyperion Financial Management architecture.

High-Level View of Hyperion Financial Management Multi-tier Architecture

HFM Dimensions

Scenario Dimension

The Scenario dimension corresponds to a class of data, such as Budget, Actual, or Forecast. For example, the Actual scenario could contain data from a general ledger, reflecting past and current business operations. The Budget scenario could contain data reflecting the targeted business operations.The Forecast scenario would typically contain data corresponding to predictions for upcoming periods. A Legal scenario could contain data calculated according to legal GAAP format and rules.

You can define any number of scenarios for an application. You use the Manage Metadata module on the Desktop to define attributes for members of the Scenario dimension, such as the default frequency, the default view, and zero data settings. For more information on maintaining metadata, see the Hyperion Financial Management Administrator’s Guide.

You create the calendar that defines how weeks build into months, months into quarters, and so on, independently from the Scenario dimension when you define an application profile. For more information on defining application profiles,

Year Dimension

The Year dimension contains a list of years. You specify a year range when you create an application profile. You then select a year from the Year dimension to process data.

Period Dimension

The Period dimension contains both time periods and frequencies by displaying the time periods in a hierarchy. For example, if the Actual scenario maintains data on a monthly basis, generally 12 periods of data are available for this scenario in a year. You edit periods and frequencies in the application profile. For more information on the application profile,

Entity Dimension

The Entity dimension corresponds to the organizational structure of the company. Entities can represent divisions, subsidiaries, plants, regions, countries, legal entities, business units, departments, or any organizational unit. You can define any number of entities.

The Entity dimension is the consolidation dimension of the system. Hierarchies in the Entity dimension reflect various consolidated views of the data. Various hierarchies can correspond to geographic consolidation, legal consolidation, or consolidation by activity. All relationships among individual components of the members that exist in an organization are stored and maintained in this dimension. Entities in an organization are either dependent, base, or parent entities. Dependent entities are entities that are owned by other entities in the organization. Base entities are entities at the bottom of the organization structure that do not own other entities. Parent entities are entities that contain one or more dependents that report directly to them.

You use the Manage Metadata module on the Desktop to define attributes for members of the Entity dimension, such as the default currency and security class, and whether the entity allows adjustments and stores intercompany detail. For more information on maintaining metadata, see the Hyperion Financial Management Administrator’s Guide.

Value Dimension

The Value dimension contains the input currency, parent currency, adjustments, and consolidation detail. You can store consolidation detail such as proportion, elimination, and contribution detail.

Account Dimension

The Account dimension contains a hierarchy of natural accounts. Accounts store financial data for entities and scenarios in an application. Each account has a type that defines its accounting behavior (for example, Income, Expense, and so on).

You use the Manage Metadata module to define attributes for members of the Account dimension, such as the account type, the number of decimal places to display, and whether the account is a calculated, consolidated, or intercompany partner account. For more information on maintaining metadata, see the Hyperion Financial Management Administrator’s Guide.

Intercompany Dimension

The Intercompany dimension stores all intercompany balances that exist for an account. This is a reserved dimension that is used in combination with the Account dimension and any custom dimension. Hyperion Financial Management can track and eliminate intercompany transaction details across accounts and custom dimensions. You can also run intercompany matching reports to view intercompany transactions.

View Dimension

The View dimension contains various modes of calendar intelligence; for example, Periodic, Year-to-Date, Quarter-to-Date, and so on.

Custom Dimensions

Four custom dimensions are available for analysis of detailed data. You can use custom dimensions to store information such as products, markets, channels, balance sheet movement, or types of elimination. For example, custom dimensions could include Product Line, Region, Channel, or Customers. The Custom 1 through 4 dimensions are associated with accounts to determine the detailed information relevant for each account. Custom dimensions actually store account details.

Selecting Tasks

Data tasks include Process Management, Ownership Management, and Database Management tasks.

Journal tasks include processing journals, and managing journal templates, periods, and groups.

Load tasks include loading application files, such as security, metadata, member lists, rules, data, journal, and intercompany transaction files.

Extract tasks include extracting application files, such as security, metadata, member lists, rules, data, journal, and intercompany transaction files.

Creating a Workspace

You can create workspaces on the Web that contain tasks that you perform frequently as well as data entry forms, data grids, reports, links, and related content. For example, suppose you need to enter intercompany balances in Web data entry forms, review intercompany balances in reports, and translate parent entities in a data grid. Creating a workspace enables you to complete your workflow without navigating among forms, grids, and reports modules.

You can create a public workspace that can be shared with other users, or a private workspace that is not displayed to other users. After you create and save a workspace, the next time that you open an application, you can view and open existing workspaces from the Project View on the left navigation pane.

Setting the Point of View on the Web

The Point of View is a set of dimensions you define that determines the data that Hyperion Financial Management accesses for an application and is displayed in the data grid. The Point of View can contain folders as well as individual dimension members, which indicate that there are additional members for the dimension. You can expand the folders to show additional members in the hierarchy.

Hyperion Financial Management provides initial Point of View settings. When you change the settings, the Point of View is updated with your changes. This User Point of View is available throughout the application session. When you exit the application, the information is saved and can be used the next time that you open the application.

The list of dimensions in the Point of View indicates the dimension that you are selecting in the following ways:

•	The current dimension is represented by text, while the other dimensions are represented by links.

•	The current dimension is enclosed by small, triangular characters.