by Jon H. Williams
on 2013/10/13
Symptom
ERROR:
Code............................................. -2147467259
Description...................................... [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
At line: 90
Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile
Component........................................ upsWObjectsDM
Version.......................................... 1112
Thread........................................... 78068
In Windows, for FDM, use the correct architecture to create a 32-bit DSN
steps
Prerequisite: Fully functional 64-bit Windows server (e.g., Windows Server 2008 R2).
Create a 32-bit DSN by launching a 32-bit version of the Data Source Administrator.
%windir%\SysWoW64\odbcad32.exe
Either of SQL Native Client or 32-bit POracle database ODBC drivers are required
[continue reading…]
{ }
by Jon H. Williams
on 2013/10/08
Tim Tow’s Outline Extractor Released
On Saturday, July 13, 2013, an outline extractor which only works with 11.1.2.x and higher and provides XML output was released. For those of us who used the old Visual Basic extractor provided by Olap Underground and maintained by Tim Tow’s organization, this is good news.
Joe Aultman presents the importance of being automated in chapter 9 “System Automation The Groovy Way” which jump-starts automation techniques for finance and IT professionals with an example of building an outline extractor in 7 steps.
As Tim noted, “You still have to do something with the XML format for it to be useful.”
via Tim Tows Hyperion Blog: Next Generation Essbase Outline Extractor Released!.
{ }
by Jon H. Williams
on 2013/10/08
Documentation Feedback
Send feedback on Oracle EPM product documentation to the email address and follow EPM Information Development on these social media sites:
{ }
by Jon H. Williams
on 2013/08/17
{ }
by Jon H. Williams
on 2013/08/17
Period close in the extended enterprise transitions with intensive processes through ledger\sub-ledger close, data loads, data mapping, and the consolidations, reconciliations, tax, treasury and reporting essential to achieve financial close. Timely results delivered on a daily or weekly basis provide control of compliance and truth while the business conducts audit, analysis and regulatory functions. Oracle’s Financial Close Suite integrates existing:
- consolidation administration
- governance, risk and compliance
- tax provisioning
- data assurance
- document filing and administration
- financial and management reporting
- enterprise resource planning
in automated and managed close that finance users can manage in sustainable accurate and auditable processes.
As ARM and FCM extend the Oracle Fusion Middleware SOA Suite for EPM System products, an experienced resource is recommended to navigate the layers of compexity and challenges to creating an effective FCM/ARM implementation alongside the usual Oracle EPM products.
Having recent and comprehensive experience with implementing Oracle Hyperion Financial Close Suite, I am enthusiastic about the dynamic opportunity for addressing regulatory, compliance and reporting challenges with this solution.
This post is part one of a primer on FCM implementation.
[continue reading…]
{ }
by Jon H. Williams
on 2013/08/17
SQL Server: Search Every Table And Field
An important query to have in your toolbox will search through tables and fields.
One may Set a search string.
One may Create a stored procedure.
steps
Follow the external link.
Copy.
Follow the instructions.
description
There are times when getting granular on the backend is a good thing.
external links
Search every table and field in a SQL Server Database Updated | Tim Gaunt.
{ }
by Jon H. Williams
on 2013/07/17
Oracle Exalytics In-Memory Machine X3-4 arrived
The new release continues the pre-integration of business intelligence systems with in-memory database software.
external links
Read the press release or a good summary: by @ERoske.
{ }
by Jon H. Williams
on 2013/06/29
command line for taking ownership and adding full control of directory
An important part of non-standard locations with complicated products is appropriate control of the installation and temorary file directories. There are several ways to quickly validate file and folder permissions, especially when multiple users are involved in setting up installation or patching files on multiple environments. This works for making the service account an owner with full control:
TAKEOWN /s /f "C:\Temp" /r /d y
TAKEOWN /s /f "C:\Temp" /r /d y
TAKEOWN /s /f "C:\Temp" /r /d y
TAKEOWN /s /f "C:\Temp" /r /d y
TAKEOWN /s /f "C:\Temp" /r /d y
TAKEOWN /s /f "C:\Temp" /r /d y
TAKEOWN /s /f "C:\Temp" /r /d y
ICACLS \\\c$\Temp /grant domain.com\serviceaccountname:(OI)(CI)F
ICACLS \\\c$\Temp /grant domain.com\serviceaccountname:(OI)(CI)F
ICACLS \\\c$\Temp /grant domain.com\serviceaccountname:(OI)(CI)F
steps
Prerequisite: Local or Domain Administrator access
Begin by modifying the code above in a text editor for the target environment.
Execute via cut and paste to cmd, or as part of more complicated scripted process.
description
Take ownership and add full control on a directory in Windows 2008 R2 Server.
Next would be to turn off read-only.
external links
None at this time
{ }
by Jon H. Williams
on 2013/06/28
LCM imports from file system of FCM 11.1.2.2.350
An import of templates fails when there are two ro more users with identical first and last names in Microsoft Active Directory. Error in migrating artifact, "/Templates/Quarter Close". Multiple users were found (on row 101, column name Approver1, column number DV). Artifacts should be imported in correct order and dependent artifacts or attributes should be available.
steps
Prerequisite: Oracle Enterprise Performance Management System, Release 11.1.2.2, with FCM on Build Version 11.1.2.2.350.1772
Begin by using LCM to export Application Groups > Financial Close > Financial Close Management from Hyperion Shared Services Console.
Import artifacts in the correct order.
If there are two users in a user directory that have the same first and last name, the LCM import will fail.
description
Typical steps in migrating between DEV, QA & PROD require the use of LCM. It would be unusual to expect the combination of first and last name to be unique for each employee listed in the user directories.
This is probably a bug.
external links
None at this time
{ }
by Jon H. Williams
on 2013/06/10
adapter function fails in freshly-upgraded FDM application
steps
Prerequisite: Fully functional Financial Consolidation application to which to connect.
Select Tools > Clear Error Log
Logoff
Logon
Begin by selecting Metadata > Control Tables
Click Ok on any messages
Click in a cell under Target Year; If values are returned, the connection to an HFM application is active.
Otherwise select Tools > View Error Log
Use the output to identify the issue.
The number of active custom dimensions in the FDM Adapter must match the number of custom dimensions in the HFM application
Connect to Oracle Hyperion FDM Workbench
Expand the Dimensions of the Target System Adapter
Right-Click Custom1 and check Active
Repeat for Custom2, Custom3, Custom4
Set the System Code and Save
[continue reading…]
{ }