Sunday, April 26, 2020

Stop Editing Workspace EAR Files - EASY Way to Change the Title!


I mentioned in my last ODTUG webinar that Oracle EPM 11.2.x's workspace looks exactly the same as 11.1.2.4's.  Everything looks identical right down to the color schema and title of the tab in your browser.

In the old days, we had to manipulate the WAR file inside of the EAR file to change the Oracle logo, manipulate the color codes, or whatnot so as to discriminate between Production, non-Production, or even different versions of EPM.  Replacing the logo image requires the know-how to make an image of the exact same height & width -- or being a fairly good Internet meme creator.

Worse, I sometimes find evidence that some consultants made edits directly within WebLogic's domains/EPMSystem/servers/FoundationServices0/tmp folder, rather than within the EAR+WAR file itself.

Stop doing that!!!

Do you know that a 1-line SQL statement makes your EPM Workspace title and browser tab look similar to my screenshot above?

Execute the SQL statement and bounce the EPM Foundation service, and you'll never have to worry about what happens if somebody subsequently patches Workspace or blows away WebLogic's /tmp folder.

Which SQL statement????   Here you go.  As my dear mother used to tell me in her dry humor, "never say I didn't do anything for you..."

UPDATE hss_component_property_values
SET property_value = 'EPM Workspace 11.2.1.0 - Datavail Sandbox'
WHERE property_name = 'ApplicationName'


property_name = 'ApplicationName' is case-sensitive for both Oracle and MSSQL.  What you specify for property_value may be anything you want.  My suggestion is to indicate the version (e.g. 11.1.2.4, 11.2.0.0 or 11.2.1.0 as appropriate) and the environment designation (PROD, UAT, DEV, etc...)

The above SQL statement works for all 11.1.2.x and 11.2.x versions as of this writing.  If you're still on 11.1.1.x or 9.3.x..... good luck!

7 comments:

  1. Thanks Dave, it worked on my Lab environment

    ReplyDelete
    Replies
    1. You are most welcome! My team has been using this technique for the past few years and I thought it would be a shame not to share a bit of secret sauce!

      Delete
  2. Hello Dave,

    In 11.2.1 install, I am planning to scale or high available OHS and Foundation Services, is it okay if I first install these two services in 1st server and complete all configurations and get Hyperion workspace to work and then move on to second server install/configure or do you see any issues not doing all of them at once.
    (or) Do you think I should install on both servers at once, but configure on first server and bring Hyperion to work and then stop services to configure on second server?
    I appreciate your thoughts.

    ReplyDelete
    Replies
    1. Hi Veera. I tend to install all servers at once, but then configure just one half of the cluster at a time. So in your case, I'd configure Foundation+OHS #1 and test it. Without the 2nd half of the cluster being configured, any issues I run into can be isolated without having to worry if the problem was one half of the cluster or the other. (Or if you are doing 3, 4 or more servers in a cluster). I find it less confusing that way.

      Best luck to you! Regrets for the late reply... I've been heads-down on a project and just noticed this.

      Delete
  3. Thank you so much Dave for your response, no worries.
    Hope you don't mind me asking couple of more questions.
    1. We are using Oracle as database, prior to 11.2 we used to create required users for each component like(Planning, EAS, Calc etc.,) upfront and use them during configuration.
    a) Can we do the same in 11.2.1, create user schemas upfront before install/configure or do we have to even use RCU only to create these schemas?
    b) In what stage RCU comes into picture during configuration?
    c) If I have sys credentials updated in rcu.properties file, is that good enough and will configuration automatically prompts to create required user schemas?
    d) I understand there is new requirement to have schema for each server, if I am configuring e.g. Server1 and Server 2. If I configure rcu.properties file, will configuration process asks me to create these new schemas one one each server?

    2. I read in your blogs that OHS will not create windows service and also some password encryption issues., I appreciate if you can shed some light on additional steps needed after OHS configuration and any script that will help me.

    3. Also, for OHS high availability I am thinking not to use shared file area for configuration instead configure on individual servers, I understand there is additional work, but do you see any further issues in doing during load balancing etc.,

    Thanks,
    Veera

    ReplyDelete
  4. Hi Veera. You will still create blank schemas as you always did for EAS, Calc, etc. RCU comes into the picture BEFORE you try to create your WebLogic EPMSystem domain and deploy Foundation... those steps will fail if RCU is not taken care of. I presented an ODTUG webinar that included this topic. The 11.2 install guide tells you what to pick in RCU and you would pick a distinct "prefix" for each of your servers. You only need to do this on servers that run WebLogic processes... a pure Essbase server wouldn't need it.

    Sounds like you have a lot of questions and may need some of my consulting time? If you click on my profile at the top-right of this blog you see a link to my LinkedIn page. You can ping me there and we could set something up. I can't do an exhaustive how-to on all steps to properly spin up 11.2 on this blog, or I won't get any billable work. :)

    One thing I will give out is something I wrote in one of my prior posts, and that is how to run OHS.

    You start the new NodeManager service. Then you execute the following command one time only. You will need to do this on each of your load balanced OHS servers:

    %EPM_INSTANCE_HOME%\httpConfig\ohs\bin\startComponent.cmd ohs_component storeUserConfig

    The above command encrypts the password for you. The password you supply would be your epm_admin password you previously created for EPMSystem.

    From this point forward, your custom startup script would need to start the Node Manager and then include the same command above, but without "storeUserConfig" at the end.

    Best of luck to you!


    ReplyDelete
  5. Hello Dave,

    Thank you so much for your kind response, sorry for asking many questions. I will definitely reach out to you as you suggested.

    Thanks for your wishes.
    Veera

    ReplyDelete