≡ Menu

the proper office

I have been using G Suite to run my office for years; I highly recommend them.
get yourself a proper office too

If you click on this link (or the ones below) it helps me pay the bills. Thank you!

I have been using Crane & Co. stationery for personal as well as business correspondence several years. I have gone through boxes of the stuff, in all the usual colors. They have even custom made matching paper into envelopes for me when the supply of paper I purchased exceeded my supply of matching envelopes.

Their consistency and superior products are good enough for me. The purpose of this post is to point out if one is persistent and searches for Crane & Co. on Amazon, it is quite difficult to locate anything other than 50 sheet, and 25 envelope boxes. Here are links to purchase 250 sheet reams & 100 envelope cartons respectively:

Hope this saves you some time.


{ 0 comments }

mastery, success, nothing less…

The North American concept is, well, I’ve been doing it for 6 years–I oughta know what I’m doing now…

~ Murray Carter, the 17th Generation Yoshimoto Bladesmith

Some treat Enterprise Performance Management that way.

At the six-year mark, I was able to put together a working system; Each year since has made an exponential difference in the quality of the solutions that I provide.

Confidence gained from demonstrating mastery is radically different from confidence gained by counting years.

What makes you and your EPM advisory team confident?

Perhaps it is an external certification; DiResta 55 – 1 million subscribers is what that looks like on YouTube. The Oracle Specialized Partner of the Year (2017) – EPM CLOUD – GLOBAL is The Hackett Group.

peer recognition from Oracle

The Hackett Group:
Specialized Partner of the Year – North America, EPM Cloud – Global

Perhaps it is a referral from an influencer to help make better purchase decisions.

Perhaps it is repeat engagements? A strong indicator of confidence is that after routinely considering all the options,  we call back the same EPM advisory team for further engagements.

Jim Rohn, an American business philosopher echoed[1] a perennial business sentiment on confidence:

The greatest step towards success is self-confidence. The greatest builder of self confidence is self esteem, and self esteem comes from doing the daily things you know you should do. Your self esteem will start to soar when you make some critical decisions – decisions to walk a new road, to start a new direction, to start a new discipline.

I would add that picking the EPM advisory team is a critical decision in our journey to mastery.



[click to continue…]

{ 0 comments }

Oracle Planning and Budgeting Cloud Updates

The Oracle Planning and Budgeting Cloud updates for August

applied to test environment on Friday, August 4, 2017 and to production environment on Friday, August 18, 2017

Please note that Oracle updates the document for August 2017  over time with most recent updates are at the top. Summarized from Oracle’s website on 28 JULY

Tanya Heise has outlined the August 2017 updates here

    • New chart type “Status Meter Gauge” quickly shows form values against threshold levels
    • Calculation Manager log values improved
    • Data Management will now provide option to include adjustment periods from Oracle GL source system
    • Data Management increased integration with FAH and FAHRCS
    • EPBC only, Consolidation Operator, Account Type and Variance Reporting are now editable options
    • EPBC only, Projects business process now provides Data Load Templates customized to the EPBC features enabled and any custom dimensions
    • EPBC only, Financials business process now provides Data Load Templates for Weekly Planning
    • Multiple Strategic Modelling enhancements
    • Get ready to update Smart View for Office to 11.1.2.5.710 to ensure compatability with the August 2017 update features and access new functionalities.
    • 19+ defects fixed

    Reminder: Transition to “Financial Reporting Web Studio” as it will “become the only environment for designing and building reports”

    [click to continue…]

{ 0 comments }

The Profitability and Cost Management updates for September

applied to test environment on Friday, September 1, 2017 and to production environment on Friday, September 15, 2017

Please note that Oracle updates the document over time and most recent updates are at the top

summarized on 30 August from:

here for September 2017 include these and others:

  • “Integrate business process navigation flows can connect following subscriptions (** sources for connections)”
    • Oracle Planning and Budgeting Cloud**
    • Oracle Enterprise Planning and Budgeting Cloud**
    • Oracle Financial Consolidation and Close Cloud**
    • Oracle Tax Reporting Cloud**
    • Oracle Account Reconciliation Cloud
    • Oracle Profitability and Cost Management Cloud
    • Oracle Enterprise Performance Reporting Cloud
    • More details: “‘Connecting Subscriptions in EPM Cloud’ in the Administrator’s Guide of the source service”
    • “Connection across multiple subscriptions when services are in different domains within the same data center will be supported in a future update”
  • Maintenance snapshots can now be submitted to Oracle for support
  • Provisioning report has been improved
  • Enhancements to the Activity Report identifies top 15 user interface requests by time to execute
  • SSO is now available with Oracle Identity Cloud Services (IDCS)
  • Addition of Copy Application Snapshot to the REST API
  • Dimension Management now allows deleting dimension during early dev stages
  • Simultaneous editing of all aliases for a member is now possible
  • Analysis Views can now be sorted to aid simple reporting
  • Ability to copy n number of rules added
  • Smart View is supported across Private Connections
  • In case one needs a reminder: (continue) to avoid special characters in artifact names, including calculation scripts

Reminder: Transition to “Financial Reporting Web Studio” as it will “become the only environment for designing and building reports”

6 Defects Fixed…

[click to continue…]

{ 0 comments }

We recommend staying away from fancy online password managers so Password Safe is our long-time go-to solution for securing logons. If Passwordsafe is part of your kit on OS X (or Ubuntu, Red Hat, et cetera) this will be useful.

Install wxPython:

brew install wxpython

Download Loxodo for OS X or (even better):

git pull https://github.com/sommer/loxodo.git

(you did remember git is context sensitive right?)

To run, cd into the location of loxodo.py and execute:

./loxodo.py

We prefer to execute from command line, so in /usr/<username> create a symbolic link:

ln -s  /usr/local/some/obscure/location/loxodo.py /Users/<username>/loxodo.py

Now one can open a terminal to run:

<computername>:~ <username>$ ./loxodo.py

“Cristoph Sommer’s pure Python Password Safe v3-compatible Password Vault Loxodo is a thing of beauty, especially when accessing the same v3 psafe archive file from multiple operating systems.”

“Renowned security technologist”[1] Bruce Schneier, author of many books designed Password Safe for simple and secure password management. Password Safe is maintained at https://pwsafe.org/.

From git the source is open.

On Windows, each formal release of  Password Safe is digitally signed with the project administrator’s gpg key. To verify the signature, use this public key (key fingerprint = A703 C132 8EAB C7B2 0175   3BA3 9194 6451 5CCF 8BB3).


Posted by: Jon H. Williams
[1] https://pwsafe.org/index.shtml
{ 0 comments }

SQL Server tuning

If SQL Server is part of your kit, this will be interesting:

“If you do a lot of query and index performance tuning, you’re going to love the improvements in this month’s release of the First Responder Kit.”

First Responder Kit is from Brent Ozar Unlimited® via @BrentOzarULTD

 

{ 0 comments }

Unable to Assign Access Control in Shared Services for HFM

Oracle Enterprise Performance Management System, Release 11.1.2.3.xxx or below
A right-click on an HFM application in Shared Services, throws an authentication error. The server is unable to process your request. Please have an administrator restart the Web server.
Click “OK”.
Click “Finish”.
Right click again on the HFM application in Shared Services. Assign Access Control seems to begin to work.
Logout, and back in, to Shared Services; The problem recurs.
This error indicates the EPM System was not properly shutdown during the last restart. The HsvDataSource.exe for the particular process and the CASSecurity hang and hold the memory. Manually clearing the HsvDatasource.exe process(es) and CASSecurity.exe process(es) will clear the holding memory which allow communication like “assign access control”.

steps

Shutdown HFM completely on all servers, including the processes HsxService.exe, HsxServer.exe, and HsvDatasource.exe, then kill process(es) CASSecurity.exe.
Restart HFM.

Details

The related error message will be like:

URI: http://servername.mycompany.com:port/hfm/security/securityAssignmentWizard.asp
Code: -2147023174
Description: An error occurred processing the result from the server.
Actor: Hyperion.HFMErrorHandler.1
Trace: Error Reference Number: {8CDD5ED5-C012-423B-843E-FAE0FB3F2403}
Num: 0x800706ba;Type: 0;DTime: 6/18/2013 7:18:18 PM;Svr: servername;File: CHITRegistryWrapper.cpp;Line: 1116;Ver: 11.1.2.2.303.3959;
Num: 0x800706ba;Type: 0;DTime: 6/18/2013 7:18:18 PM;Svr: SERVERNAME;File: CHFMwHITRegistry.cpp;Line: 777;Ver: 11.1.2.2.303.3959;

Prerequisites:
The environment is stable (Assign access control worked previously).
One can access all the HFM applications.
One can (re-)register the HFM applications.

Prevention: Modify the shutdown script to verify the processes HsxService.exe, HsxServer.exe, and HsvDatasource.exe end, and to verify CASSecurity.exe ends.

external links

None at this time


{ 0 comments }

simplify SQL Server installation

“SQL FineBuild makes it easy for anyone to produce a best-practice installation and configuration of SQL Server.

“Simplify the time needed to deploy any of the following builds:

Main Instance Server Build – for multi-drive servers (clustered or non-clustered)

Additional Named Instance Server Build – adds another SQL Server instance to a server

Workstatiodrive[sic] desktop machines

Client Tools Only Build – just the tools, to allow remote administration of SQL Server

“There are five members of the FineBuild family:

  • SQL2016 FineBuild to install SQL Server 2016
  • SQL2014 FineBuild to install SQL Server 2014
  • SQL2012 FineBuild to install SQL Server 2012
  • SQL2008R2 FineBuild to install SQL Server 2008 R2
  • SQL2008 FineBuild to install SQL Server 2008
  • SQL2005 FineBuild to install SQL Server 2005

“All of these can be downloaded at FineBuild V3.2.1
source: http://sqlserverfinebuild.codeplex.com/

steps

http://sqlserverfinebuild.codeplex.com/documentation

 

external links

Source for this is the original author in a SQL Server Central post about replication.
Get more information about FineBuild from discussions on CodePlex.

 


{ 0 comments }

managing mixed environments with MobaXterm

connect from Windows clients to Linux servers

MobaXterm Professional provides full X server and SSH support in a portable (no install required) customized (no unwanted games nor tools) application.

connect from Linux servers to Windows clients

Diligent system administrators usually isolate the EPM system servers completely from the Internet, allowing no direct connections. The recommended practice is to download and validate more than 20GB of Oracle EPM source software and patches to a client desktop before transferring to the EPM servers. By running MobaXterm on a Windows client, secure connections, rapid file transfer and remote terminal access is straight-forward from the Windows client to Solaris/Linux servers AND from Solaris/Linux servers to the Windows client.

description

Prerequisite: MobaXterm Professional
This post describes the process that I use to setup MobaXterm Professional. The cost is negligible as we remove components undesirable in client environments (e.g., games, port scanner, network packet capture, http server, NFS server, et cetera).

In addition, we will add plugins (e.g., httperf, Curl, and DnsUtils like dig or  nslookup).

The Home Edition is free, subject to MobaXterm terms and conditions, but somewhat limited and excludes professional support.

steps

[click to continue…]

{ 0 comments }

easy alias to show all files in OS X

From Ian Lunn:

… All I need do now is type showFiles and hideFiles whenever I need to show/hide OS X’s hidden files. Here’s how you can do it too.

How to set up an alias for AppleShowAllFiles. Edit ~/.bashrc:

alias showFiles='defaults write com.apple.finder AppleShowAllFiles YES; killall Finder /System/Library/CoreServices/Finder.app'
alias hideFiles='defaults write com.apple.finder AppleShowAllFiles NO; killall Finder /System/Library/CoreServices/Finder.app'


{ 0 comments }