Load Data From FDMEE To ARM Error:” Export terminated due to mismatched currency buckets.”


When loading data to ARM  from FDMEE getting the error message:
Export terminated due to mismatched currency buckets “XXXXXX”. Ensure that Financial Data
Quality Management, Enterprise Edition Category names match ARM currency/buckets.

Error

To Fix-

Verify that currency bucket in ARM match currency in FDM:

Check currency mappings in FDMEE:

1. Log into Workspace

2. Navigate->Administer-> Setup->  Category Mapping ->  Application Mapping

3. Ensure that Target Application is “Account Reconciliation Manager”.

4. Make sure that you have appropriate Categories Setup.

FDMEE_Category

Thanks,

~KKT~

Advertisements

HFM – Relationship between DOWN and POWN System Accounts


Relationship between POWN and DOWN system accounts-

 

  • Percentage of Direct Ownership of the Entity can be retrieved from the system account [Shares%Owned]. Direct Ownership (DOWN) is exactly that. For example, entity A directly owns 80% of entity B’s shares.
  • Percent Ownership (POWN) is not direct, it is a calculated value based on the shares owned by the entity marked as “holding”. If the entity GROUP owns the entity HOLDING, and HOLDING owns shares of entities A, B and C, then the system will calculate how much of A, B and C GROUP owns. That is POWN. The percentage is then used to determine how much of the values in  A, B and C should be consolidated in GROUP (the PCON value).
  • The example below illustrates the relationships between POWN and DOWN.
    In metadata, the entity structure shows that the parent Europe has children 1A, 1B, 1C and 1D. 1A is the holding company for Europe

EPMA_DIM

Direct Percentage of Ownership is set up using a Data Grid with the following:
– 1B is owned by 1A 80%
– 1C is owned by 1A 70%
– 1D is owned by 1B 20%
– 1D is owned by 1C 20%

HFM_Grid

Using Ownership Management, the system calculates Percent Ownership (POWN) for the children of Europe as follows:
– 1A 100%
– 1B 80%
– 1C 70%
– 1D 30%

HFM_OwnershipThe calculated POWN is relative to Europe. The value of 30% for entity 1D is calculated as follows:


1B is owned 80%, which owns 20% of 1D      80% * 20% = 16%
1C is owned 70%, which owns 20% of 1D      70% * 20% = 14%

16% + 14% = 30%

In summary, DOWN represents the percentage of direct ownership and POWN represents the ultimate percentage of ownership.

 

Thanks.

 

Smartview Concept- Point of View, Adhoc Grids and Functions


There is often confusion about what Point of View Manager in Smartview is for, so let me explain a few points.

  1. Firstly, POV Manager sets the connection’s Background Point of View. This POV is used primarily for SmartView functions.
    An HsGetValue function for HFM, for example, when created using Function Builder, specifies all 12 dimensions. However, it is possible — and for performance reasons, often preferable — to omit some dimensions. The function will assume the member set in the Background POV for omitted dimensions.
  2. Saving a POV by dragging it to a worksheet in POV Manager does not set that Point of View for the sheet — remember, Points of View are related to the Connection, not a particular worksheet.
    When you save a POV in this way, a copy of it is saved in the worksheet. It will be saved in the Excel file when you save the workbook and it can be retrieved in future sessions by dragging it from the sheet back to the Active POV within POV Manager.
  3. Once you have created an Adhoc Query or Free Form Query, the grid has its own Point of View, represented on the POV Toolbar. For Essbase, Planning, and HFM prior to 11.1.2.1, the starting point for this Point of View is the Background Point of View. (For HFM the starting point is the user
  4.  which is retrieved from the server.) Once the Adhoc has been created, the grid is independent of the Background POV. You must make any future changes to it via the POV Toolbar.

1. To create a new Adhoc Query with specific Point of View (Essbase, Planning)
Firstly set the Point of View in POV Manager (in Active). No need to drag or save the Point of View.
Click Hyperion -> Refresh to create the new Adhoc grid. The starting Point of View will match the one you set in POV Manager.

2. To change the Point of View of an existing Adhoc Query
Use the POV Toolbar relating to the grid.

3. To save a Point of View for re-use
1. Set up the desired Point of View in POV Manager
2. Drag the Active POV into an open worksheet in the left-hand pane
3. The Point of View will now be saved along with the workbook.
To use it in the future, after opening the workbook and connecting, drag it from the worksheet to the Active folder in the left-hand pane of POV Manager.

4. To set a default Point of View (to avoid having to set the POV every time you start SmartView)

Note: from 11.1.2.1 it is not longer necessary to do this, as the user POV is stored on the server and retrieved upon connection.

First save the Point of View into Personal.xls as described in 3 above.
On opening Excel and connecting, copy and paste this Point of View from Personal.xls to Active in POV Manager.

If you do not see Personal.xls listed in POV Manager:
1. Point to Tools -> Macro -> Record New Macro…
2. In the Record Macro dialog box, select ‘Personal Macro Workbook’ in the drop-down menu
3. Choose OK
4. Choose Tools -> Macro -> Stop Recording.
Personal.xls will now be listed in POV Manager.

When you close Excel, you may be prompted to save the Personal Macro workbook. Choose Yes to ensure your Default Point of View is retained.

 

Do Revert in case of any queries.

 

FDMEE- load exchange rates from flat file to HFM application


It can actually be performed as a simple data load from flat files. In the data load mapping, you could use * to * mapping for the custom1 and custom2 dimensions which will allow the system to directly take the currencies from the source flat file itself.

If the “Intersection Validation” option is set as YES in the target application options then the above method will fail. The following workaround has to be used in that case

1. Please select the data load rule that imports and exports the exchange rates to HFM application
2. Select the “Target Options” under the specific data load rule.
3. Set the “Check Intersection” option to NO and “Drill Region” option to NO and save the changes
4. Let the “Check Intersection” option and “Drill Region” option in the “Target Application” option be YES
5. Now execute the data load rule and check if you are still facing any issues.

Revert back in case of any queries.

Thanks.

HFM – Creating Classic Financial Management Applications in 11.1.2


Creating Application Profiles

Before creating an application, you create an application profile that defines its languages, calendar, frequencies, and periods.

Select Start > Programs > Oracle EPM System > Financial Management > Financial Management.

Screenshot for Step

The Financial Management Desktop login dialog box is displayed.

Perform the following actions:

a. Enter the following login information:

Domain User Password

b. Click Logon.

Screenshot for Step

The Financial Management Desktop login dialog box is displayed.

In the Tasks pane, select Define Application Profile.

Screenshot for Step

The Create New Application Profile page is displayed.

Select Create a New Application Profile, and click Next

Screenshot for Step

The Languages page is displayed.

In Row 1, enter English, and click Next.

Screenshot for Step

The Time Periods page is displayed.

Perform the following actions:

a. Select Standard Calendar.

b. Select Include Quarters.

c. Select Include Months.

d. In the Start Month list, select January.

e. In the Start Year box, enter 2011.

f. In the Number of Years box, enter 10.

g. Click Next.

Screenshot for Step

The Frequencies table is displayed.

Perform the following actions:

a. Enter the following frequency descriptions for the View dimension:

View View Description

b. Click Next.

Screenshot for Step

The Periods page is displayed.

In the Periods list, perform the following actions:

a. Select Quarter1 and, in the description box, enter Quarter 1.

b. Select January and, in the description box, enter January.

c. Repeat steps a and b to add descriptions for February and March in Quarter1 and descriptions for Quarter2, Quarter3, and Quarter4 and April through December.

d. Click Next.

Screenshot for Step

Perform the following actions to save the profile:

a. Click Browse and navigate to C:\Hyperion\Products\FinancialManagement\Client.

b. In the File Name box, enter TrainingApp.

c. Click Finish.

Screenshot for Step

The application profile is saved successfully with a PER extension.

Click OK.

Creating Financial Management Applications in Classic Administration

After creating the application profile, you create a Financial Management application named TrainApp. You base the TrainApp application on the TrainingApp profile that you created.

On your desktop, perform the following actions:

a. Double-click the Workspace icon.

b. Enter user name trnadmin and password hyperion.

c. Click Log On to log on to Workspace.

Screenshot for Step

In Workspace, select Navigate > Administer > Classic Application Administration > Consolidation Administration > Create Application.

Screenshot for Step

Perform the following actions:

a. Enter or select the following information:

Field Value

b. Click Create.

Screenshot for Step

Verify that the application was created successfully.

Screenshot for Step

You successfully created the TrainApp application.

Opening the Application and Reviewing the Application Metadata

After creating the application, you open it and review the application metadata.

Select Navigate > Applications > Consolidation > TRAINAPP.

Note: You may have to click Refresh on the Consolidation submenu to load the TRAINAPP application.

Screenshot for Step

Select File > New > Data Form.

Screenshot for Step

Select the POV tab, and click the Search icon for the Year dimension.

Screenshot for Step

Verify that the Year dimension contains the members specified in the TrainingApp profile.

Screenshot for Step

Click the Period dimension, and verify that it contains the members specified in the TrainingApp profile.

Screenshot for Step

Click the View dimension, and verify that it contains the members specified in the TrainingApp profile.

Screenshot for Step

Note: The Periodic member contains the lowest-level frequency (MTD) that you defined for the View dimension.

You completed the tutorial. You can now create a metadata file and load the metadata file into the application

Smart View Support Matrix and Compatibility


1. What is the current version of Smart View?

Current version of Smart View is 11.1.2.5.510, released in October 2015.

2. In the release compatibility tab of the support matrix, what does Smart View 11.1.2.5+ mean?

It means Smart View 11.1.2.5.000 and higher.  Any release of Smart View 11.1.2.5.000 or higher is supported with the data source provider mentioned in the release compatibility matrix.  The latest release on the code line is recommended for customers.

3. Does the latest version of Smart View support 11.1.1.x releases of EPM suite (Planning, HFM, etc.)?

Smart View releases beginning with 11.1.2.5.000 support EPM 11.1.1.4.x.  Earlier versions of EPM are not supported.  Customers need to upgrade to a higher version of EPM suite, preferably 11.1.2.3.500, the latest.

4. Does Smart View support Internet Explorer 10?

Smart View 11.1.2.5.000 (and higher) supports IE10, as long as the underlying product or provider supports IE10.  For example, HFM 11.1.2.3.500 supports IE10 so Smart View supports IE10 in that context.  For older versions of HFM, IE10 support is not certified.

5. Does Smart View support Internet Explorer 11 against HFM?

IE11 is currently certified only with products in EPM System 11.1.2.4. In this release of EPM System you must use Smart View 11.1.2.5.400.

There is a limited support for IE11 with EPM 11.1.2.2.500 and 11.1.2.3.500.

6. Does Smart View Support Office 2013?

Yes.  Smart View Release 11.1.2.5.000 onwards supports Office 2013.

7. Does Smart View support Office 365?

Smart View is ONLY supported for Desktop versions of Excel, Word, PowerPoint and Outlook included in any Office 365 plan and which are locally installed on any supported Windows Operating System.

Office 365 is a subscription-based online office and software-plus-services suite which offers access to various services and software built around the Microsoft Office platform.  Other services include Lync web conferencing, Exchange online, Sharepoint, SkyDrive and Skype.  The licensing determines what component or service is included as part of a bundle.

Microsoft Office Web Apps are a part of most Office 365 plans. Office Web Apps allow users to open Word, Excel and PowerPoint documents, among others, using a web browser.  However Office 365 on the web is intended for reading (full fidelity) and limited editing.  Office Web Apps do not have extensibility (add-in) model and there are no plans for one. Smart View is NOT supported for Office Web Apps which are part of Office 365.

Office 365 was made available in 2011 when Microsoft Office 2010 was the latest Office Suite.  Smart View supports Microsoft Office 2010.  Microsoft Office 2013 is supported starting with Smart View Release 11.1.2.5.000.

8. Which versions of Oracle Business Intelligence Enterprise Edition (OBIEE) does Smart View support?

8. Which versions of Oracle Business Intelligence Enterprise Edition (OBIEE) does Smart View support?

Compatible OBIEE Server Release
Smart View Release  11.1.1.7.0 11.1.1.7.1 (No patch) 11.1.1.7.10 (FA-REL8) 11.1.1.7.140527  11.1.1.7.150120 11.1.1.9.0
11.1.2.2.310 Yes No No No No No
11.1.2.3.000 Yes No No No No No
11.1.2.3.000 PSE_16909989 Yes Yes No No No No
11.1.2.5.000 Yes Yes No No No No
11.1.2.5.200 No Yes Yes No No No
11.1.2.5.210 No Yes Yes Yes Yes No
11.1.2.5.215 No Yes Yes Yes Yes No
11.1.2.5.400 No Yes Yes Yes Yes No
11.1.2.5.410 No No No No No Yes
11.1.2.5.500 No No No No No Yes
11.1.2.5.510 No No No No No Yes

 

 

 

 

 

 

 

 

 

 

 

 

9. Does Smart View Support Google Docs?

Smart View is a COM add-in for MS Office Suite of products and as such, cannot not have any integration, with Google docs.  Google Docs (includes Docs, Sheets, and Slides) is a free, web-based office suite offered by Google within its Google Drive service.

In order to provide functionality similar to Smart View a new application will have to be created possibly using Google Apps Script.  Google Apps Script is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and third party services and build web applications.

It is to be noted that Google docs does have limitations such as:

  • Sheets – 200 sheets per workbook, with 400,000 cells in all
  • Docs – 1,024,000 characters, regardless of the number of pages or font size
  • Slides – Presentations created in Google Slides can be up to 50 MB – about 200 slides.

These are practical limitations for Smart View users who have a large number of cells in a typical workbook.  In some cases the number of sheets in a workbook does exceed 200 or documents can have more than 1,024,000 characters in a document, which is not allowed in Google Sheets and Google Docs respectively.

Once these limitations are addressed and if Google Apps Script (or newer technology) is able to provide the same rich functionality that COM add-ins such as Smart View provide, Oracle will re-visit this topic for consideration.

 

 

EPMA – Interrupted Application Deployment


Friends this issue occur to me many times and really Wiered  to see this happening so thought of adding the post for all.

Sometimes when you deploy an application, the deployment gets interrupted. When this happens, your application will basically be non-responsive. However, there is a way to resolve the issue right in Workspace in 11.1.2.3.

Step 1: Identifying the issue

For this post, I decided to purposefully interrupt an application deployment. Of course, you should never do this ever, ever, ever. The repercussions are unspeakable. So I’ve done it for you so you can learn how to fix it.
After interrupting the deployment, I went back into the application library to my app AEPMASO. Here is what you see when this happens.
As you can see in the properties section the status of my application is Deployment Pending. This is bad because if you try to redeploy your app, it’s not possible. And you don’t have the default 480 minutes to wait for the deployment timeout.

Step 2: Run application diagnostics

But what you can do is run Diagnostics to fix the issue. This is available in the application’s right-click menu. Once you get to the Application Diagnostics interface, choose Select All to run all the listed tests. They run fairly quickly, and you should see that Deploy pending is listed as Failed. Click on that particular test to bring up the Test Details on the right.

Now you have the option to update the state of the application to not deployed. Of course, you can also set it as deployed, but if it hasn’t, you shouldn’t do that. Select the first option and click Apply. Then confirm that you want to update your application in the Warning popup.
In our case select only “Incomplete pending deployment” option and click apply.
Note- Please have a epma schema backup and Planning or HFM schema backup before proceeding forther.
The tests should automatically run again and now you should get an overall status of Completed Successfully if that was your only problem.

Step 3: Deploy your application

Now when you go back to the application library you should see the new status for your application.
If you right-click your application, the option to deploy will now be available.
That’s how you can release your application from Deployment Pending.

Configure ERPi 11.1.2 to Load Data into Financial Data Quality Management from EBS


The following White Papers in this KM article will cover the following topics:

* Installation of ERPi and ODI
* Configure the ODI Software Component for ERPi
* Configuration and Initialization of ERPi
* Using ERPi for EBS/FDM Data Loads into HFM

— Configure and use ERPi 11.1.2 to Load Data into Financial Data Quality Management from EBS —

Installation of ERPi and ODI

  1. Install the ERPi Component
  2. Install the ODI Component

Click here to download the ERPIStage1

Configure the ODI Software Component for ERPi

  1. Create the ERPi Master Repository
  2. Configure the Topology Manager
  3. Create Logical Schemas
  4. Create Physical Schemas
  5. Create the Logical/Physical Context
  6. Configure the ERPi Work Repository
  7. Create a Physical Agent
  8. Configure the Operator
  9. Import the Scenarios

Click here to download the ERPIStage2

Configuration and Initialization of ERPi

  1. Create ERPi Source Systems
  2. Initialize ERPi Source System

    Click Here to download the ERPIStage3

Using ERPi for EBS/FDM Data Loads into HFM

  1. Create a Link inside of ERPi to the HFM Application
  2. Create an Import Format
  3. Create a Location
  4. Create the Metadata
  5. Create the Member Mappings
  6. Create a Data Rule

Click Here to download the ERPIStage4

 

 

Revert back in case of any queries.

Thanks.

 

 

Where Are the Logs for ERPI Integrator and its Associated Products Stored?


Where are the logs for ERPI and its associated products stored?

There are various different logs associated with ERPI and the products that it leverages. The location of the logs also varies in each release. The details below are per release and within that per product.

11.1.1.3
ERPI
HyS9aifWeb-sysout.log – Hyperion\Logs\Services
The logging level can be changed on the source system page from 1-5
ODI
Aif_<>.log – System Temp
FDM
Username.err – FDM Application Folder\Outbox\Logs
In the ERPI Adapter additional logging can be enabled on line 35 of the GetData Action script. Modify the value  RES.FDMFalse to RES.FDMTrue. This creates a log file called ERPI-Fin-A in the Outbox\Logs folder.
EPMA
HyS9EPMAWebTier-sysout.log – HyperionHome\Logs\Services
HyS9EPMAWebTier-syserr.log – HyperionHome\Logs\Services
DimensionServer.log – HyperionHome\Logs\EPMA
HFM
HsvEventlog.Log – HyperionHome\Logs\HFM
Planning
HyS9Planning-sysout.log – HyperionHome\Logs\Services
HyS9Planning-syserr.log – HyperionHome\Logs\Services

11.1.2
ERPI
HyS9aifWeb-sysout.log – MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\services
ODI
Aif_<>.log – System Temp
FDM
Username.err – FDM Application Folder\Outbox\Logs In the ERPI Adapter additional logging can be enabled on line 35 of the Connect Action script. Modify the value  RES.FDMFalse to RES.FDMTrue. This creates a log file called ERPI-Fin-A in the Outbox\Logs folder.
DimensionServer.log – MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\epma
HyS9EPMAWebTier-sysout.log – MIDDLEWARE_HOME\user_projects\empsystem1\diagnostics\services
HyS9EPMAWebTier-syserr.log – MIDDLEWARE_HOME\user_projects\empsystem1\diagnostics\services
HFM
HsvEventlog.Log – MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\HFM
Planning
Application Server– MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/services
Other Planning Logs– MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/planning

 

11.1.2.1
ERPI
HyS9aifWeb-sysout.log – MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\services
ODI
Aif_<>.log – System Temp
FDM
Username.err – FDM Application Folder\Outbox\Logs
In the ERPI Adapter additional logging can be enabled on line 35 of the Connect Action script. Modify the value  RES.FDMFalse to RES.FDMTrue. This creates a log file called ERPI-Fin-A in the Outbox\Logs folder.
EPMA
DimensionServer.log – MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\epma
HyS9EPMAWebTier-sysout.log – MIDDLEWARE_HOME\user_projects\empsystem1\diagnostics\services
HyS9EPMAWebTier-syserr.log – MIDDLEWARE_HOME\user_projects\empsystem1\diagnostics\services
HFM
HsvEventlog.Log – MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\HFM
Planning
Application Server– MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/services
Other Planning Logs– MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/planning

 

11.1.2.2
ERPI
ERPIntegrator.log – Oracle/Middleware/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs
ODI
Aif_<>.log – System Temp
FDM
Username.err – FDM Application Folder\Outbox\Logs
In the ERPI Adapter additional logging can be enabled on line 35 of the Connect Action script. Modify the value  RES.FDMFalse to RES.FDMTrue. This creates a log file called ERPI-Fin-A in the Outbox\Logs folder. Additionally in the Connect Action after line 25 you can add the value objERPI.showSQL = True This will write out the SQL being run by the adapter.
EPMA
DimensionServer.log – MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\epma
HyS9EPMAWebTier-sysout.log – MIDDLEWARE_HOME\user_projects\empsystem1\diagnostics\services
HyS9EPMAWebTier-syserr.log – MIDDLEWARE_HOME\user_projects\empsystem1\diagnostics\services
HFM
HsvEventlog.Log – MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\HFM
Planning
Application Server– MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/services
Other Planning Logs– MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/planning

Running the ziplogs utility should provide a copy of most of these logs.

objERPI.showSQL = True

 

11.1.2.3

ERPI Server Log
ERPIntegrator.log – Oracle/Middleware/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs

PROCESS LOG
<applicationRootFolder>\Outbox\Logs
FDM User Error Log
Username.err – FDM Application Folder\Outbox\Logs
ERPi-Fin-E1 Log: FDM application Folder\Outbox\Logs\ERPi-Fin-E1.log
EPMA
DimensionServer.log – MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\epma
HyS9EPMAWebTier-sysout.log – MIDDLEWARE_HOME\user_projects\empsystem1\diagnostics\services
HyS9EPMAWebTier-syserr.log – MIDDLEWARE_HOME\user_projects\empsystem1\diagnostics\services
HFM
HsvEventlog.Log – MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\HFM
Planning
Application Server– MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/services
Other Planning Logs– MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/planning

Running the ziplogs utility should provide a copy of most of these logs.

Error “Unknown Error Procedure…….clsFMAdapter.fConnect” When Connecting from FDM to HFM


When browsing from FDM to HFM receiving the error
Unknown Error Procedure…….clsFMAdapter.fConnect

The error log contains the error
‘Array’ is Nothing’

Error:
Code…………9
Description…..3 – System.ArgumentNullException: Value cannot be null.
Parameter name: Argument ‘Array’ is Nothing.
at Microsoft.VisualBasic.Information.LBound(Array Array, Int32 Rank)
at fdmFM11XG6C.clsHFMadapter.fBuildDimensionCache(Int32 lngDimensionID)
Procedure…….clsHPDataAccess.fBuildDimensionCache

 

The main cause for this error is that The HFM application currently does not have metadata for all dimensions.

Populate the HFM application with metadata so it has at least one member in each dimension.