tag:blogger.com,1999:blog-28156391538157552222024-03-21T22:09:57.565-04:00Jessica's Hyperion EPM BlogJessica's Hyperion EPM Bloghttp://www.blogger.com/profile/05297079265675559638noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2815639153815755222.post-42470456877032198812011-03-25T08:00:00.000-04:002011-03-25T08:00:35.135-04:00Simplified Essbase Administration - Part III<strong>Have multiple applications? Not sure how to transfer or import data to multiple applications that contain different members/dimensions?</strong> <br />
<br />
If you need to map multiple members from a source application to an equivalent member in a target application, you must first define the source members. <br />
<br />
<span style="color: black;"><strong>I. Define Source Members</strong></span><br />
<br />
Option 1 – Shared alternate hierarchy<br />
<br />
a. Create new parent member with the same member name as the target application and set property to ignore to prevent duplication of data<br />
b. Add existing members as children of new parent member<br />
<br />
- Requires additional maintenance of the dimension structure<br />
- Does not compromise data retrieval<br />
- May increase calculation time <br />
<br />
We all want our end-users to be self efficient and I think they may be able to figure out the mapping once they drill-down the hiearchy. I have used alternate hierarchies in large applications and I have yet to compromise calculation time.<br />
<br />
Option 2 – User Defined Attributes<br />
<br />
a. Assign UDA’s to source members<br />
b. Create a new member and set property to ignore to prevent duplication of data<br />
c. Develop a calc script fixed on the UDA and populate the Sum of the UDAs to “new member”<br />
<br />
- Requires additional member property maintenance<br />
- Does not compromise data retrieval<br />
- Does not compromise calculation time<br />
<br />
If data is constantly re-stated, re-classed or adjusted you must remember to re-calculate. Throw in a batch script and call it a day – I’m just saying. <br />
<br />
Now, the sophisticated/advanced Essbase user will cleverly filter their retrievals on UDA’s and magically list the accounts that make up the mapping.<br />
<br />
Option 3 – Attribute Dimension<br />
<br />
a. Create attribute dimension property<br />
<br />
The attribute dimension gives you the same results as the alternate shared hierarchy, behaves similar to UDA’s. What is the difference? <span style="background-color: yellow;">Attributes may significantly compromise report retrievals</span>.<br />
<br />
Which one is the best option? <br />
<br />
Every environment is different. Performance is significantly dependent on the application configuration and I strongly recommend you test.<br />
<br />
<span style="color: black;"><strong>II. Data transfer and Data Export Options</strong></span><br />
<br />
Now, we are ready to explore options on how to populate data from the source application to the target application. The options are as follows:<br />
<br />
Option 1 – @XREF built in function transfers data from source to target application via calc script<br />
<br />
- Excellent option for consistent structured hierarchies<br />
- Leverages built-in calculation functions<br />
- Data flows seamlessly if the structures are one in the same<br />
- Can be easily batched<br />
<br />
If you fix at level 0 in a common dimension i.e. @LEVMBR(“ENTITY”,0) and it is not an exact mirror of the source application, duplication of data will result at the level where the dimension hierarchy differ. Therefore, the member names and levels must be identical.<br />
<br />
The granular the fix statement, the quicker the performance.<br />
<br />
Option 2 – Report Script Exports data to a flat file (see Simplified Essbase Administration Part II)<br />
<br />
- Export data from specific Alias tables, UDA, levels<br />
- Specify export column/row format<br />
- Exclude members from a dimension <br />
- Re-name members<br />
- Can be easily batched<br />
<br />
Report script performs efficiently when focused on smaller data sets. Larger data sets may take longer to process. <br />
<br />
The rename built-in function works brilliantly if you need to map specific members to an additional dimension member in the target application i.e. source member 1234 must map specifically to target member 4567 and COLA {“RENAME” “1234”} “4567 COLA” . This option is best used if the mapping is consistent; however, unique to specific members in a different dimension. This data file can be easily parsed using the Split function within a data load rule.<br />
<br />
Option 3 - DataExport – Exports data to a flat file<br />
<br />
- Exports data to text file extremely fast<br />
- Leverages built-in calculation functions<br />
- Can be easily batched<br />
<br />
DataExport outperforms report scripts. It is engineered to export data in the order that it is organized in the database. Whereas, report script performance is dependent on coding and may retrieve the same blocks multiple times. <br />
<br />
<span style="background-color: yellow;">DataExport does not support attributes, aliases, member re-name and data format options.</span><br />
<br />
Every environment is different. Performance is significantly dependent on the application configuration and I strongly recommend you test.<br />
<br />
This is the beauty of Essbase, the options are available at your disposal. <br />
<img alt="Ponder" border="0" src="http://smileys.emoticonsonly.com/emoticons/p/ponder-1378.gif" title="Ponder emoticon" /> It is up to the individual to creatively leverage the tool.Jessica's Hyperion EPM Bloghttp://www.blogger.com/profile/05297079265675559638noreply@blogger.com1tag:blogger.com,1999:blog-2815639153815755222.post-362317790050021802011-01-22T14:22:00.002-05:002011-01-22T14:34:43.450-05:00Simplified Essbase Administration – Part IIData export via Essbase Report Script Object <br />
<br />
Not sure how to export data for a specific Alias table, UDA, exclude members from a dimension or perhaps you need to Re-name a member for transformational purposes? <br />
<br />
Below is a simplified “ Basic Master Report Script”. It is a simple as it seems below<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7D27RZWgGexCFmOVo0JpRUAbRHjSmX_Y4Tkg60zdCNaKFZhiFky8URsoWdVOZn_vVQEeOtuAV71Qc1MUSu-6GtR8LDj0NpVjgEVgNQLTtZp-YQ1MpNEoOMmEW9E4_Of9GNc8fp_v-IqwY/s1600/ReporScript.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="588" s5="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7D27RZWgGexCFmOVo0JpRUAbRHjSmX_Y4Tkg60zdCNaKFZhiFky8URsoWdVOZn_vVQEeOtuAV71Qc1MUSu-6GtR8LDj0NpVjgEVgNQLTtZp-YQ1MpNEoOMmEW9E4_Of9GNc8fp_v-IqwY/s640/ReporScript.jpg" width="640" /></a></div><span style="font-family: 'Calibri','sans-serif'; font-size: 14pt; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;"><strong>It is all in the DBAG – the DBAG is your friend and remember to keep it simple..</strong></span>Jessica's Hyperion EPM Bloghttp://www.blogger.com/profile/05297079265675559638noreply@blogger.com2tag:blogger.com,1999:blog-2815639153815755222.post-33602647822800149292010-10-16T18:17:00.001-04:002010-10-21T22:57:40.844-04:00Simplified Essbase Administration - Part IWhy is it that many organizations have invested millions in financial analytical tools that not only offer visibility to their data but also promise business process automation and I am hearing the term “MANUAL” frequently these days e.g. manual sourcing and transformation, manual loads, manual validation, manual e-mail notification of errors, manual migration, manual report delivery, and manual database object updates. I am exhausted of listening to these manual tasks … are you? <br />
<br />
I'd like to believe this misfortunate manual business process administration is due to the current economic condition that has forced organizations to eliminate or consolidate functional roles, cut back on training and development resulting in poor business system administration, poor data analysis and poor reporting.<br />
<br />
As a developer and system administrator, the good news is that all of these manual processes can be automated. The key to successful business application automation processes are as easy as going back to the basics:<br />
<br />
- Business Acumen - What is the nature of the business?<br />
- Data Process Flow - Where does the data source reside and what are the dependencies?<br />
- Customer Needs - What do the customer need to make effective business decisions?<br />
- Resources - What are their strengths and where can you leverage their talent?<br />
- Oracle EPM Analytical and Reporting tools – What are the strengths of the application?<br />
<br />
It is easy to lose site of the basics when one is wearing many hats. Understanding the strengths of the Oracle EPM applications, will give you a clearer view and understanding of:<br />
<br />
- How you can align business knowledge to begin the build of a database?<br />
- How you can leverage the tools to source and transform data?<br />
- How you can align your resources?<br />
- How you can leverage the strengths of the application and minimize the burden of administration?<br />
- How you can deliver data and reporting timely to meet your customer needs?<br />
<br />
If you are using multiple Essbase and Planning applications you can significantly reduce the burden of administration by automating database substitution variables, data loads, data transfers between multiple cubes by leveraging the XRef function, report scripts and/or Data Export via Maxl.:<br />
<br />
I. Automating Substitution Variable Updates<br />
<br />
a. Define Global Variables - Create a batch file that contains the names of your analytical servers, databases , log directories and load rules as follows:<br />
<br />
REM***********************************************************************<br />
REM This file sets Global variables to be used for all Month End administration functions <br />
REM i.e Sub Variable, Data Load, Dimension Build, Calculation Scripts and Report Scripts<br />
REM***********************************************************************<br />
<br />
Set Log_Dir=C:\Hyperion\Automation\Admin\Jobs\RPTG\Logs\<br />
Set Log_Dir2=C:\Hyperion\Automation\Admin\Jobs\Plan\Logs\<br />
Set RPTG_Process_Dir=C:\Hyperion\Automation\Admin\Jobs\RPTG\Bat<br />
Set PLAN_Process_Dir2=C:\Hyperion\Automation\Admin\Jobs\Plan\Bat<br />
Set RPTG_LoadBat_Dir=C:\Hyperion\Automation\Admin\Jobs\RPTG\Bat\LoadFile_Bats\<br />
Set PLAN_LoadBat_Dir=C:\Hyperion\Automation\Admin\Jobs\PLAN\Bat\LoadFile_Bats\<br />
Set Fin_Server=10.100.80.01<br />
Set Plan_Server=10.100.80.02<br />
Set APP1=RPTG<br />
Set APP2=PLAN<br />
Set Database=Finance<br />
<br />
II. Substitution Variable Batch Script – <br />
<br />
a. Create a central batch file that contains all of your substitution variables for all applications as follows:<br />
<br />
REM ********************************************************************<br />
REM UPDATE APPLICATION SUBSTITUTION VARIABLES<br />
REM ********************************************************************<br />
<br />
Set LOAD_CUR_MONTH=Aug<br />
<br />
REM **** ***************************************************************<br />
REM UPDATE FORECAST SUB VARIABLE REM*********************************************************************<br />
<br />
Set FCST_SCEN=FCT_SEP<br />
<br />
REM ********************************************************************<br />
REM UPDATE YEARLY SUB VARIABLE<br />
REM ********************************************************************<br />
<br />
Set Load_Year=FY10<br />
<br />
b. Create a Maxl file directory that contains all of your Global maxl scripts i.e. c:\Hyperion\Automation\Mxl\Set_SubVar.txt <br />
<br />
/*Global script can be used for any applications */<br />
<br />
spool stderr on to "$1";<br />
set message level error;<br />
login $2 $3 on $4;<br />
iferror 'ErrHandler';<br />
alter database $5.$6 drop variable "$7";<br />
alter database $5.$6 add variable "$7";<br />
iferror 'ErrHandler';<br />
alter database $5.$6 set variable "$7" "$8";<br />
iferror 'ErrHandler';<br />
logout;<br />
spool off;<br />
exit;<br />
define label 'ErrHandler';<br />
exit;<br />
<br />
c. Create a batch script to update substitution variable as follows:<br />
<br />
REM **********************************************************************<br />
REM SetDB_SubVars.bat<br />
REM Special Instructions:<br />
REM Update Monthly_SubVariable.bat with current month<br />
REM variables prior to execution<br />
REM **********************************************************************<br />
<br />
REM *********************** SET VARIABLES SECTION *************************<br />
<br />
Call C:\Hyperion\Admin\Jobs\Bat\Monthly_SubVariable.bat<br />
Call C:\Hyperion\Admin\Jobs\Bat\Global_System_Variables.bat<br />
Set Load_Dir=C:\Hyperion\Admin\Jobs\RPTG_Load\Data\%Load_Year%_%Load_Cur_Month%<br />
<br />
REM *********************** UPDATE RPTG APP SUB VARIABLE SECTION *********<br />
<br />
Set Application=%App1%<br />
<br />
REM ***************************************<br />
REM Update Current Month Sub Variable<br />
REM ***************************************<br />
<br />
Set SubVar=Cur_Month<br />
Set SubVal=%Load_Cur_Month%<br />
<br />
C:\Hyperion\AnalyticServices\Bin\essmsh.exe C:\Hyperion\Automation\MXL\set_subvar.mxl %Load_Dir%Set%Application%_%SubVar%.txt %USER% %PSWD% %Server% %Application% %Database% %SubVar% %SubVal%<br />
<br />
REM ****************************************************<br />
REM UPDATE FORECAST SCENARIO<br />
REM ****************************************************<br />
<br />
Set SubVar=FCST<br />
Set SubVal=%FCST_SCEN%<br />
<br />
C:\Hyperion\AnalyticServices\Bin\essmsh.exe C:\Hyperion\Automation\MXL\set_subvar.mxl %Load_Dir%Set%Application%_%SubVar%.txt %USER% %PSWD% %Server% %Application% %Database% %SubVar% %SubVal%<br />
<br />
III. Audit Trail – <br />
<br />
a. Not Certain if the substitution variables are updated. You can either log-on to the AAS console or check the Load Directory file initiated in the SETDB_SubVar.bat file to verify the substitution variable updated successfully. The results should appear in the log file as follows: <br />
<br />
MAXL> display variable on database RPTG.Finance;<br />
application database variable value (The log file will display pre and post Substitution Variable)<br />
<br />
+-------------------+-------------------+-------------------+------------------- <br />
<br />
RPTG Finance Cur_Mo Jul <br />
<br />
RPTG Finance Cur_Yr FY10 <br />
<br />
RPTG Finance FCST FCT_AUG<br />
<br />
<br />
MAXL> alter database RPTG.Finance set variable Cur_Mo "'Aug'";<br />
<br />
MAXL> display variable on database RPTG.Finance;<br />
application database variable value <br />
<br />
+-------------------+-------------------+-------------------+------------------- <br />
<br />
RPTG Finance Cur_Mo Aug <br />
<br />
RPTG Finance Cur_Yr FY10 <br />
<br />
RPTG Finance NEW_FCST FCT_SEPJessica's Hyperion EPM Bloghttp://www.blogger.com/profile/05297079265675559638noreply@blogger.com2tag:blogger.com,1999:blog-2815639153815755222.post-4414849486672138462010-08-03T21:24:00.011-04:002010-08-04T21:39:03.665-04:00Dodeca Review<span style="font-family: "Calibri", "sans-serif"; font-size: 1pt; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;"></span><span style="font-family: Times New Roman; font-size: small;"></span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><strong style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">C</span></strong><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">ontrols</span><span style="font-family: "Arial", "sans-serif"; font-size: 9.5pt; mso-fareast-font-family: 'Times New Roman';"></span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><strong style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">L</span></strong><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">everage </span><span style="font-family: "Arial", "sans-serif"; font-size: 9.5pt; mso-fareast-font-family: 'Times New Roman';"></span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><strong style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">E</span></strong><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">fficiency</span><span style="font-family: "Arial", "sans-serif"; font-size: 9.5pt; mso-fareast-font-family: 'Times New Roman';"></span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><strong style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">V</span></strong><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">erification</span><span style="font-family: "Arial", "sans-serif"; font-size: 9.5pt; mso-fareast-font-family: 'Times New Roman';"></span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><strong style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">E</span></strong><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">ffective</span><span style="font-family: "Arial", "sans-serif"; font-size: 9.5pt; mso-fareast-font-family: 'Times New Roman';"></span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><strong style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">R</span></strong><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">OI</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"></span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"></span></div><br />
<div class="MsoNormalCxSpMiddle" style="margin: 0in 0.5in 0pt; mso-add-space: auto;"><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"> It is clear that there is still an outcry and a desperate need to reduce cost, streamline processes, implement robust controls and most importantly leverage existing technology to facilitate the demands of the finance organization. <br />
<br />
If we conduct a survey to identify where most organization continue to invest their dollars, my guess would be in IT. The question is, “has it become out of control that it has hampered the financial analyst team and now they have to rely on additional resources to provide the information that they need for forecasting, budgeting, audits, special requests, etc.?”<br />
<br />
Have you analyzed how much time your resources are utilizing in gathering data? <br />
<br />
What medium do analysts use to gather information from Oracle, EPM, ERP and other relational databases once the data has finally become available to the analyst? <br />
<br />
The frequent answer is: EXCEL :-O<br />
<br />
Why are financial organizations utilizing a significant amount of their time in gathering data in this advanced era of information technology and not enough time to analyze the data thoroughly? So now, the data finally becomes available; unfortunately, month-end reporting, forecasting or budgeting season creeps in and the <strong>“analyst”</strong> puts the analysis on hold until after the madness is over - but wait, they can’t complete the analysis because it is now either quarter or year-end reporting. Unfortunately, their time is not utilized efficiently and definitely not effectively. <br />
<br />
Who is Accountable for the integrity of the data? Is there an opportunity to improve controls within both the IT and Finance organizations? There is too much room for error and what or how much would that error cost you?<br />
<br />
I have been in the Financial Reporting and Financial System role for over a decade and I can relate to both IT and Finance organizations frustrations. I am alerting you that this is not a sales pitch and I am not one to easily convince, those who know me will Strongly agree.<br />
<br />
Tim Tow from Applied Olap Inc., was kind to present Dodeca to me. A one hour presentation turned into a two hour webcast meeting. Dodeca is designed to connect to any relational database via JDBC and Essbase database via a front-end spreadsheet that "looks and acts" just like EXCEL. Tim’s team designed a front-end spreadsheet software with drill down capabilities to multiple relational sources including Essbase and other third-party applications. If you want to take it to another level, you can take it as far as drilling down to view approved invoices. This was the highlight of the presentation in my mind. Needless to say, the data retrieval was seamless. </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"></span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt 0.5in;"><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">As I ask questions and continue to discuss real challenges faced today by finance organizations, I am highly convinced that Dodeca will solve most of the challenges your finance organization is facing today in terms of gathering and analyzing data from multiple sources. Below are a few examples that I encountered or have witnessed within the finance organization:</span></div><table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-bottom: medium none; border-collapse: collapse; border-left: medium none; border-right: medium none; border-top: medium none; margin: auto auto auto 0.5in; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;"><tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;"><td style="background: #92d050; border-bottom: black 1pt solid; border-left: black 1pt solid; border-right: black 1pt solid; border-top: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 2.95in;" valign="top" width="283"><div style="text-align: left;"><br />
<span style="color: white; font-family: Arial, Helvetica, sans-serif; font-size: 10pt; mso-ascii-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: Calibri; mso-themecolor: background1;"><strong>Time Consuming Processes</strong></span></div></td><td style="background: #92d050; border-bottom: black 1pt solid; border-left-color: #ece9d8; border-right: black 1pt solid; border-top: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 239.4pt;" valign="top" width="319"><br />
<span style="color: white; font-family: Arial, Helvetica, sans-serif; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-themecolor: background1;"><strong>Dodeca Benefits</strong></span></td></tr>
<tr style="mso-yfti-irow: 1;"><td style="background-color: transparent; border-bottom: black 1pt solid; border-left: black 1pt solid; border-right: black 1pt solid; border-top-color: #ece9d8; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 2.95in;" valign="top" width="319"><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">Gathering data for Audits</span><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"></span></div></td><td style="background-color: transparent; border-bottom: black 1pt solid; border-left-color: #ece9d8; border-right: black 1pt solid; border-top-color: #ece9d8; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 239.4pt;" valign="top" width="319"><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt -1.65pt; text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">Drill back to source system instantly via spreadsheet</span></div></td></tr>
<tr style="mso-yfti-irow: 2;"><td style="background-color: transparent; border-bottom: black 1pt solid; border-left: black 1pt solid; border-right: black 1pt solid; border-top-color: #ece9d8; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 2.95in;" valign="top" width="283"><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt; text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">Provide Hard Copies of invoices</span><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"></span></div></td><td style="background-color: transparent; border-bottom: black 1pt solid; border-left-color: #ece9d8; border-right: black 1pt solid; border-top-color: #ece9d8; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 239.4pt;" valign="top" width="319"><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt -1.65pt; text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">Drill back to source system instantly via spreadsheet</span></div></td></tr>
<tr style="mso-yfti-irow: 3;"><td style="background-color: transparent; border-bottom: black 1pt solid; border-left: black 1pt solid; border-right: black 1pt solid; border-top-color: #ece9d8; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 2.95in;" valign="top" width="283"><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt; text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">Validate analytic, planning and </span></div><div align="left" class="MsoNormal" style="margin: 0in 0in 0pt; text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">reporting </span><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">data to source system</span><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"></span></div></td><td style="background-color: transparent; border-bottom: black 1pt solid; border-left-color: #ece9d8; border-right: black 1pt solid; border-top-color: #ece9d8; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 239.4pt;" valign="top" width="319"><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt -1.65pt;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">Drill back to source system instantly via spreadsheet</span></div></td></tr>
<tr style="mso-yfti-irow: 4; mso-yfti-lastrow: yes;"><td style="background-color: transparent; border-bottom: black 1pt solid; border-left: black 1pt solid; border-right: black 1pt solid; border-top-color: #ece9d8; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 2.95in;" valign="top" width="283"><br />
<div align="left" class="MsoNormal" style="margin: 0in 0in 0pt; text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">Commentary Notes</span><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"></span></div></td><td style="background-color: transparent; border-bottom: black 1pt solid; border-left-color: #ece9d8; border-right: black 1pt solid; border-top-color: #ece9d8; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 239.4pt;" valign="top" width="319"><br />
<div align="left" class="MsoNormal" style="margin: 0in 0in 0pt -1.65pt;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">Commentary notes are stored within </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt -1.65pt;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">relational/Essbase cubes and can be </span></div><div align="left" class="MsoNormal" style="margin: 0in 0in 0pt -1.65pt;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">retrieved </span><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">instantly via excel from relational </span></div><div align="left" class="MsoNormal" style="margin: 0in 0in 0pt -1.65pt;"><span style="font-family: "Arial", "sans-serif"; font-size: 9pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">or Essbase</span><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"></span></div></td></tr>
</tbody></table><div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"></span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">In summary, Dodeca is cost effective, it leverages existing technology and in my opinion addresses the concerns and frustrations that most finance organizations face today.<span style="mso-spacerun: yes;"> </span>I am an advocate for streamlining processes, implementing controls, leveraging existing systems and reducing cost – then again who isn’t?<span style="mso-spacerun: yes;"> </span>ROI’s should not solely consider the business bottom line; most importantly, it should account for your most valuable investment and that is people.<span style="mso-spacerun: yes;"> </span>Your analysts will appreciate the investment and they will be able to utilize their time effectively. </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><span style="font-family: "Arial", "sans-serif"; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"></span><span style="font-family: "Arial", "sans-serif"; font-size: 9.5pt; mso-fareast-font-family: 'Times New Roman';"></span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><span style="font-family: "Arial", "sans-serif"; font-size: 9.5pt; mso-fareast-font-family: 'Times New Roman';"></span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><strong><span style="color: red; font-family: "Arial", "sans-serif"; font-size: 9.5pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">See Cantor Fitzgerald case study <a href="http://www.appliedolap.com/resources/case-studies">Dodeca</a> </span></strong></div><div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><strong><span style="color: red; font-family: "Arial", "sans-serif"; font-size: 9.5pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';"></span></strong></div><div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;"><strong><span style="color: red; font-family: "Arial", "sans-serif"; font-size: 9.5pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';">CLEVER MR. TOW</span></strong><strong><span style="color: red; font-family: "Arial", "sans-serif"; font-size: 9.5pt; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman';"> </span></strong></div><img alt="O Lord" src="http://www.desicomments.com/funnypics/funnysmiley34.gif" />Jessica's Hyperion EPM Bloghttp://www.blogger.com/profile/05297079265675559638noreply@blogger.com2