Tuesday, October 22, 2013

SendTo folder in Windows Server 2008 R2


SendTo folder comes in pretty handy when it comes to running Maxl and ESSCMD scripts in the Oracle Essbase environment and several other regular activities such as sending Mails, zipping, etc.

While some are there in the SendTo folder by default, ESSCMD, Maxl, etc should be added manually in the SendTo folder before we can use it.

If you are looking for “how to add items to the SendTo folder” follow the instructions below. In this example, I am going to add ESSCMD and ESSMSH (Maxl) to the SendTo folder. You can add other elements in the 2008 R2 environment in the same way.

NOTE: SentTo folder is located in C:\Users\whatever_your_username_is\AppData\Roaming\Microsoft\Windows and the AppData folder is “HIDDEN” by default,
therefore,
if you do not see the AppData folder under “whatever_your_username_is”
a. GOTO > Control Panel > Folder Options
b. Under the VIEW tab, click the Radio Button “Show hidden files, folders, and drives” > Apply




Now,
a. Navigate through C:\Users\whatever_your_username_is\AppData\Roaming\Microsoft\Windows and you will be able to see the SendTo folder.

b. Next, find the ESSCMD and ESSMSH (Maxl) – both .exe files. The path should be something like “D:\oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseServer\bin”

c. Copy them under the SendTo folder and you are all set.

Now, if you have a Maxl or Esscmd script that you want to run, you can just right-click it and SentTo proper file type.


Wednesday, September 25, 2013

Hyperion Planning Application Definition

If you had to create exact replica of a Hyperion Planning Application, knowing how to check Application definition of your planning apps comes in very handy.

For example, if you want to know what PlanTypes your planning application has or what kind of Weekly distribution has been set or if your planning application has been set for Multi-currency or not, etc can come very handy.

This is how you can achieve this using Hyperion Shared Services.

The steps:
1. Log in to Hyperion Shared Services.

2. Under "APPLICATION MANAGEMENT" expand
                 Application Groups
                           Planning. (You will see the list of all planning applications that you have)

3. Choose the application by clicking it.

4. On the right, under "ARTIFACT LIST" expand
                  Configuration
                            Properties (You will see "Application Definition" and "Application Settings")
5. Right-click "Application Definition" and "Export to Edit."

6. It will prompt you to SAVE the file in your local drive. The file extension is XPAD, which you can open using any text editor, such as NotePad or TextPad. You can also open it in Excel as "an XML table." In fact, you can open it in Excel and create a table of all your applications for easy access. 

The content of an XPAD file would look something like this - where you would get all the information that you would require to create a planning replica application:



<?xml version="1.0" encoding="UTF-8" ?>
 <application datasource="Candy" instanceName="Default" name="Sample" description="Candy application" project="Planning" calculationModule="BUSINESS_RULE" >
 <PlanningAppType>GENERAL</PlanningAppType>
 <Calendar>
 <BaseTimePeriod>12 Months</BaseTimePeriod>
 <WeeksDistribution>445</WeeksDistribution>
 <AppStartYear>2012</AppStartYear>
 <FiscalYearStartDate>SameCalendarYear</FiscalYearStartDate>
 <StartMonth>Jan</StartMonth>
 <NumberOfYear>9</NumberOfYear>
</Calendar>
 <Currencies>
 <DefaultCurrency>USD</DefaultCurrency>
 <MultiCurrency>N</MultiCurrency>
</Currencies>
 <PlanTypes>
 <ValidForPlan1>Y</ValidForPlan1>
 <Plan1Name>Candy</Plan1Name>
 <ValidForPlan2>N</ValidForPlan2>
 <ValidForPlan3>N</ValidForPlan3>
 <ValidForPlan4>N</ValidForPlan4>
 <ValidForPlan5>N</ValidForPlan5>
</PlanTypes>

</application>