FDM - HFM adapter

                                                         Register HFM adapter

1. First extract hfm adapter to the following location::

D:\Hyperion\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents

 

2. Open FDM application then first import adapter. Browse the FM11X-G5-E file from shared Components.

3. Once import done, the Register adapter with fdmFM11XG5E.dll from the Shared Components\AdapterComponents\fdmFM11xG5E

4.  Then create Machine profile with source and Target Server details

5.  After creating application if FDM application giving issue to integrate with HFM application, then we need to enable same number of custom dimensions on FDM application. Then we can see Target Period, Year etc from FDM.

Thanks,

Mady

FDM application 11.1.2+

                             How to create FDM application in 11.1.2.1+

1.       FDM works on 32-bit mode only even if you have installed on 64-bit machine.

2.       Create schema on oracle database with below::

Privileges::

CREATE SESSION,CREATE VIEW,CREATE TYPE,CREATE TABLE,CREATE CLUSTER,CREATE TRIGGER,CREATE SEQUENCE,CREATE INDEXTYPE,CREATE PROCEDURE,CREATE ANY SYNONYM,DROP ANY SYNONYM,UNLIMITED TABLESPACE

Roles: Connect, Resource and DBA.

3. We can check connect of FDM schema connectivity using udl32 file.

• Create a text file and save as with udl32 extension.
• Launch a command prompt.
• Execute the following command like below::

C:\WINDOWS\SysWOW64\Rundll32.exe "c:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile c:\testconn.udl32

4. Udl32 file will open now. You can check connectivity.

5. Create FDM application with same schema details.

6. Check the upsLBMgr.exe process in Task Manager which shows the application creation progress

7. If you get “Object variable or with block variable not set”

• Check FDM service account has permissions.
• If you are giving UNC path (if it is load balance), check folder permissions and try / and \
• If you are UNC Path, try with drive name while creating application later you can change to UNC path.
• If FDM version 11.1.2.1, we need to apply patch. Patch number—12795642
• If FDM 11.1.1.4 version, we need to apply patch. Patch number--13336220 (PSU 102)

Thanks,

Mady

How to connect to Shared Services from second time from Hyperion 11.1.2.0+

             How to connect to Shared Services from second time from Hyperion 11.1.2.0+

Some scenarios::
1. when we will do configuration first time, we will give Shared Services schema/Database details, then from next time onwards we directly get components page. we never get Shared services page until unless Sahred Services Schema / Database is not able to connect

2. If you want to change Shared Services Schema or Database

3. If you are facing Failed to Navigate to system registry error:::
Failed to navigate from registry-state.displayName: Error while initializing registry. See logs for more details.

Just follow the steps below::
1. Open a command prompt
2. Navigate to EPM_ORACLE_HOME/common/config/version_number
3. Launch configtool.sh|.bat -enableRegTask
4. On the “Shared Services and Registry Database Configuration” page, select Connect to a previously configured Shared Services database and re-enter the database connection information

If you want to edit it at any cost, just find reg.properties file for Shared Services, delete password or just rename the reg.properties file after taking backup.

Thanks,
Madhu

1. 
   

How to execute a command from another machine remotely?

How to execute a command from another machine remotely?

1. Make sure both computers are in same workgroup or domain.

2. Enable Admin share in both computers.

Go to Start à Control Panel à System and Security à Windows firewall à Allow a program through Windows Firewall

 Search for File and Printer Sharing and check the boxes to Enable Admin$

Do the same in Server also. 

 Check whether we are connected to server or not. Go to Start and Search using the below,

\\<servername>\c$ (It will prompt for username and password to login to the server)

Try to connect to cmd using the below cmd:

 Check IP Address using ipconfig command

 Now we are working in server remotely.

I am trying to execute one batch file. I am executing one batch file to refresh the cube using CubeRefresh.cmd

One more thing we can observe:

In the server Service one temporary service will be running while executing PsExec commands. It will be stopped and deleted automatically after execution process done.

Happy to share about O2B Utility ----- Designed by Rahul Sharma

O2B Utility

Let's start working on O2B Utility:

http://hyperionplanningandmore.blogspot.in/2014/09/lets-start-working-with-o2b-utility.html

What is O2B and How useful ???

http://hyperionplanningandmore.blogspot.in/2014/09/what-is-o2b-and-how-its-useful-to-me.html

How to deploy it to Weblogic:

http://hyperionplanningandmore.blogspot.in/2014/09/deployment-of-o2b-on-weblogic.html

How to deploy it to Apache:

http://hyperionplanningandmore.blogspot.in/2014/09/o2b-deployment-on-apache-tomcat.html

DBRefresh:

http://hyperionplanningandmore.blogspot.in/2014/09/o2b-creating-trigger-how-many-times-my.html

Thanks,

Mady

Stream Exception: javax.xml.stream.XMLStreamException: Premature end of file encountered -- Weblogic Forced Shutting down

Weblogic Forced Shut down some times.......

Some time, suddenly weblogic will go down while doing deploy to application server in hyperion configuration. Error msg seems like below,

                                   

Go and Check in the following location, 

C:\Oracle\Middleware\user_projects\domains\EPMSystem\config\fmwconfig

Check system-jazn-data.xml file has data or not, as shown below screen (it is 0KB here)

In the below, you can find backup file of the same file. So rename one file as system-jazn-data.xml and start weblogic again

Now check, Weblogic will be in Running mode after some time

Thanks,

Mady

Financial Close Management installation and Configuration in 11.1.2.3 - SOA to existing domain

Financial Close Management installation - SOA to existing domain

first of all, why i am talking about SOA while talking Financial close Management, because we must install SOA to install Financial Close Management.

Second one, 

Already if we have existing hyperion environment with weblogic server, so we can deploy SOA to existing domain. While installing SOA, but it will create separate managed server for like soa_server1(default). We need to start Managed server separately. It won't start with normal start of Weblogic admin server.

Deploy SOA to existing domain:

Situation: 

1. Installed and Configured Hyperion suite(Essbase, Planning, HFM, FDM, FR etc)

2. we have existing weblogic domain (EPMSystem)

3. Installed SOA on the top of EPM Suite.

Configuration SOA:

Go to Start --> All Programs --> (SOA folder) --> Configure Application Server

Select second option, Extend an existing Weblogic domain

Select existing Weblogic domain EPMSystem( which is used for EPM suite)

Select Oracle SOA suite, Oracle WSM Policy Manager and Click Next

Click Next with default settings

Wizard will checks JDBC connections, Click Next

Set Password for SOA Infrastructure, User Messaging Service, OWSM MDS Schema, SOA MDS Schema by selecting and click Next

Wizard will check JDBC connections, click Next if test Successful

click Next with default settings

click Extend to start deployment

Domain Extension applied successfully.

Next tasks:

Once deployement done, Start soa_server1 Managed server using the below command:

Note: 

1. Make sure you installed HFM, FDM, FR to support for FCM.

2. Make sure Weblogic domain started.

3. Make sure soa_server1 managed server started.

Create Weblogic User:

1. Log into Weblogic console

http://<servername>:7001/console

2. click on Lock and Edit

3. Click on Security realm

4. click on myrealm

5. select tab Users and Gropus

6. Create user with name of Shared Services.

Click on New to create new user. Password must contain numeric, letters. special char(optional).

NOTE: FCM does not support using HSS Native Directory Users. However for testing, training or demo environments ONLY, native users can be added to both the HSS Native directory and the Weblogic native directory.

In a Production environment, only MSAD or other LDAP External Directories are supported for FCM.

Now login to workpsace and try to access Financial close from Navigate --> Applications.

While accessing if it asks for login. Enter username and password which we created in weblogic.

Enjoy FCM.

Thanks,

Mady