Enable Offline Planning for Hyperion Planning

1. Install the offline component of Smart View

The executable offline.exe can be found in HYPERION_HOME\Planning\bin\SmartView. Double click on the executable to install the offline component.

-After install you would have an offline folder with the following directory structure

<Drive_letter>\Hyperion\offline-|
                                                 |-\Bin
                                                 |-\JRE150_11
                                                 |-\lib
                                                 |-\myanalytics
                                                 |-\offlinedata
                                                 |-\uninstall
                                                 |-\installLog.txt

2. Provision the user for offline access

In Shared Services check that the user has been provisioned with the 'Offline User' role for the Planning
application to be accessed.


3. Enable the Planning Application for offline access

To enable an application for Offline Planning, the administrator has to ensure that the Planning application property "ENABLE_FOR_OFFLINE" is set to true. This property is located within "Administration" -> "Manage Properties" -> "Application Properties"

4. Enable Forms for Offline access

In Planning, connect to the Planning Application. Select Administration, Manage Data Forms, Edit the forms to be accessed via Excel; on the Properties tab, make sure that 'Enable Offline Usage' is selected.

5. Create the Data Source connection

In Excel select Hyperion, Connection Manager. Click Add and select 'URL Provider'. From the Provider drop-down list select Hyperion Provider. In the Location text box enter:
http://servername:8300/HyperionPlanning/SmartView.
Expand Servers, expand you server, expand the application you want to access, select the appropriate Plan Type and click Next. Enter a name and description for this connection. Provide the user name and password.
With 11.1.1, APS can also be used to connect to Planning and to take forms offline. 

6. Now at Excel the webform name will show-up in the take offline list.


Thanks,
Suneel

EPMA Server logs locations

Below are the locations of the EPMA

File	Name	Pre 11.1.2 (HYPERION_HOME)	Post 11.1.2 (ORACLE / Middleware)
EPMA-Workspace Context Config	HYSL-WebLogic.conf mod_wl_ohs.conf WorkspaceConfig.xml	C:\Hyperion\common\httpServers\Apache\2.0.59\conf\ HYSL-WebLogic.conf	C:\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component\ mod_wl_ohs.conf C:\Oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\xml\ WorkspaceConfig.xml
Dimension Server Config.	BPMA_Server_Config.xml	C:\Hyperion\products\Foundation\BPMA \AppServer\DimensionServer\ServerEngine\bin\BPMA_Server_Config.xml	C:\Oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\AppServer\DimensionServer\ServerEngine\bin\ BPMA_Server_Config.xml
Data Sync Config.	dme.properties	C:\Hyperion\deployments\WebLogic9\servers\EPMADataSynchronizer\webapps\DataSync\WEB-INF\classes\ dme.properties (When web server is Weblogic)	C:\Oracle\Middleware\user_projects\epmsystem1\config\EPMA\DataSync\ dme.properties
Web Server Config.	AwbConfig.properties	C:\Hyperion\deployments\WebLogic9\servers\EPMAWebServer\webapps\awb\WEB-INF\conf\ AwbConfig.properties (When web server is Weblogic)	C:\Oracle\Middleware\user_projects\epmsystem1\config\EPMA\WebTier\ AwbConfig.properties
Dimension Server Log	dimension_server.log DimensionServer.log	C:\Hyperion\logs\epma\dimension_server.log	C:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\epma\DimensionServer.log
Data Sync Log	dme.log datasync.log	C:\Hyperion\logs\epma\dme.log	C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\EpmaDataSync0\logs\datasync.log
EPMA Log	epma.log	C:\Hyperion\logs\epma\epma.log	C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\EpmaWebReports0\logs\epma.log
Web Tier Activities Log	EPMAWebServer.log EpmaWebReports0.log	C:\Hyperion\deployments\WebLogic9\servers\EPMAWebServer\logs\EPMAWebServer.log	C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\EpmaWebReports0\logs\EpmaWebReports0.log
EPM Config Utility Log	configtool.log	C:\Hyperion\logs\config	C:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\config
Data Sync Pre-Translation Logs	File name ends with "_preTransOut.txt"	C:\Hyperion\deployments\WebLogic9\servers\EPMADataSynchronizer\webapps\DataSync\WEB-INF\temp (When web server is Weblogic)	C:\Oracle\Middleware\user_projects\epmsystem1\tmp\oracle\temp
Data Sync Post-Translation Logs	File name ends with "_postTransOut.txt"	C:\Hyperion\deployments\WebLogic9\servers\EPMADataSynchronizer\webapps\DataSync\WEB-INF\temp (When web server is Weblogic)	C:\Oracle\Middleware\user_projects\epmsystem1\tmp\oracle\temp
EPM System Registry	epmsys_registry.bat	C:\Hyperion\common\config\9.5.0.0\epmsys_registry.bat	C:\Oracle\Middleware\user_projects\epmsystem1\bin\epmsys_registry.bat

Thanks
Suneel