Ask Me !!

Post Your Questions Here,so that i’ll get back with answers which you will find in this blog.

Disclaimer: This website posts information about Oracle EPM/BI and Cloud. As this is a constantly enhanced set of products, it’s quite possible that the information on each post may become out of date and the features shown may evolve or no longer exist.

Thanks,
~KKT~

24 thoughts on “Ask Me !!

  1. HI KKT

    do you think we can still use FDM after upgrading 113 to 123? what will be path to use FDMEE after this upgrade?

    Like

    • With release of FDM 11.1.2.3 Oracle has combined what we know as “FDM” and what we know “ERPi” to create “FDM, Enterprise edition” or FDMEE.

      Upgrade to FDM 11.1.2.3 –

      Existing FDM Customers – FDM and FDMEE are both included in smart list
      – Choice to stay in FDM classic or FDMEE
      New FDM Customers – Can only install FDMEE.

      Functionality-

      – Accessing FDMEE Can now we accessed through workspace
      – Integrationg with adapter is done while configuration time , setup directly in FDMEE
      – Period and Category mapping remain same as FDM
      – Locations have sane Target and Integration option and different is there is not stored hierarchy concept.
      – Import format remains same
      – Data load rule is different now you need to create a data load rule , Basically second component in location.
      – Scripting still remains same.

      let me know incase of more questions.

      Thanks,
      ~KKT~

      Like

  2. thanks for the response.
    But if client wants to use Classic FDM (as is) in EPM 123, he can use it after migration – Correct?

    Later if client wants to upgrade to FDMEE, their will be some development/upgrade effort involved? true?

    Like

    • Yes that correct, but to note if the client want to go with FDMEE later its not just normal migration its redevelopment involve.

      Thanks,
      ~KKT~

      Like

  3. Hi KKT,

    I saw your article on the smartview extensions but i am unable to get them to install properly on my system. How did you get them to install?

    I’ve tried unzipping the dll files to the C:\oracle\smartview\bin directory and nothing shows up. I also tried saving them as a svext file and running it but that doesnt work either. ANy help would be appreciated!

    Thanks,

    Steve L.

    Like

  4. Hi KKT, do you know if there is a way to setup multiple grid programmatically when converting Essbase Add-in to Smart View? I am using HypRetrieveRange, but if the spreadsheet isn’t prepared to receive multi grid retrieves, it will crash excel and I am looking for something that allows me to setup a sheet as multi grid before the retrieve.

    Thank you!

    Like

    • Hi Alice,

      Hope you are doing good.
      First things you have to use Smartview version 11.1.2.3
      Yes you can have Multiple grid enabled in a single excel using Essbase as well as Planning Connection in different sheets. It works beautifully and with Refresh all option it will refresh all sheet with different connections as well.

      Thanks,
      ~KKT~

      Like

  5. Hey KKT,

    I tried using your remove descriptions script in an FDM import format in FDMEE. In the Import Format, I added a ‘Description’ field and added the script I created to the expression. I haven’t edited any of your syntax because I’m not that familiar with Jython and figured it’s a script that can be dynamically applied. Unfortunately, I am not having any success.

    Any ideas? Below is the script I copied and pasted and how I formatted it for the import script:

    def FixAmt(strfield, strrec):
    cleanrec = strrec.replace(“‘”, “”)
    qstart = strrec.find( ‘”‘ )
    if qstart > 0:
    qend = strrec.rfind(‘”‘, qstart)
    ndesc = strrec[qstart+1:qend].replace(“‘”, “”).replace(“,”, “”)
    cleanrec = strrec[0:qstart]+ndesc+strrec[qend+1:]
    seg = cleanrec.split(“,”)

    return seg[2]

    Like

  6. Hi, Would be possible know more about CASSecurity.exe Process? It should be a process launched by Hsxserver.exe in HFM Layer. On Hyperion release 11.1.2.1 is present also by front end side in foundation layer (workspace). So there are 2 Cassecurity.exe. One associated in foundation layer and another one in HFM. How they are related? How it works?

    Do you know step by step usual flow when an User log in a workspace and try to open a report?

    Like

  7. Hi KKT, hope you are doing good.
    Could you please explain how to load cell text data in FDM?

    Like

  8. Hi kkt,

    Can you please help me out on below issue…

    Installed components

    DB (Oracle-12c)
    ODI (11G)
    FDMEE(11.1.2.4)

    My requirement :-

    Flat file to FDMEE AIF_Open_interface (Table)-I have done all the mapping and could able to generate the ODI Scenario sucessuflly with out any issue from FDMEE

    when i am trying to import data from fdmee getting error “java.lang.Exception: ODI-17546: Specified variable not found in the Repository : INTEGRATION_TEST.p_period_num”

    I have done all the required setting in FDMEE before import

    ODI Session Log_details:

    java.lang.Exception: ODI-17546: Specified variable not found in the Repository : INTEGRATION_TEST.p_period_num
    at com.sunopsis.dwg.dbobj.SnpSession.updateVarWithSessVar(SnpSession.java:3162)
    at com.sunopsis.dwg.dbobj.SnpSession.treatSessVariables(SnpSession.java:2713)
    at com.sunopsis.dwg.dbobj.SnpSession.treatSessionPreTrt(SnpSession.java:2671)
    at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2013)
    at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1931)
    at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
    at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
    at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
    at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)
    at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
    at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:50)
    at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
    at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)
    at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:93)
    at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)
    at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
    at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:562)
    at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:516)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
    at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
    at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
    at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
    at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
    at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
    at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
    at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

    Regards,
    Vasu

    Like

    • Hi Vasu,

      The issue generally occur when there is mismatch of the mapping between source and Target. Crosscheck the mapping of every column in the datasource to Target.

      Also do let me know the target where you are trying to load the data.

      Thanks,
      ~KKT~

      Like

  9. Hey KKT,

    Today, I went to reload some data into PBCS using the same file that I had used a week ago and got this error:
    “EPMAT-1:Command Failed to execute. Outline load finished with errors. Check details in status.”
    After scouring through every log file I could find I can’t seem to figure out what the problem is. My outline is fine. I have refreshed the db with no errors. I even reset the entire application to be sure. I searched high and low online but I am yet to come across anyone/post that has this error. Any insights you could provide would be most appreciated!

    Thanks,

    Michael

    Like

    • Hi Michael,

      This error generally comes when some of the members in your load file (data file) doesn’t exist in your outline.

      I will suggest you to check the data file properly and try to reload.

      To do some testing – make a copy of the current file and remove all records and keep only 10 records and try to reload this updated file. If still you have some issues there is some problem in file. If this goes through then check old file some metadata mismatch might exist.

      let me know.

      Thanks
      ~KKT~

      Like

  10. hi KKt,

    Regarding HPCM application , when the user they are trying to update the dimension it becomes stuck “progress only”. in jobconsole not showing success. Even we recycled the hpcm services but no luck issue we are facing . could you please help me out on it.

    Very urge . Waiting for valuable reply.

    Thanks
    sujit

    Like

    • Log also I have checked but did not find anything from there.

      Like

      • Dear …

        Let me try to understand the issue.
        1. You are trying to update some dimension through epma and when you deploy the application getting stuck . Correct ?

        if i understood correctly. Then couple of suggestions suggested for you.
        – Check the epm product schema as sometime the database size will be the issue.
        – if above is ok. Go to application library -> right click and run diagnostics check. everything should be in PASSED stage if something is failed then check and try to rectify.Deploy again and check.

        Will wait for your update.

        Thanks,
        ~KKT~

        Like

  11. Hi. Our company is getting ODI implemented to replace our existing PL/SQL ETLs. For almost all interfaces(around 100) that use Oracle Control Append KM, we need to set a few values which are not the default values. We are being advised by our consultants that is is better to do the changes in each interface separately than create a custom KM based on the Oracle Control Append as it might cause problems in a future upgrade(when it comes). What do you advise? The changes are just setting a few default values in the steps, not drastic like introducing a new step or taking out a few.
    Thanks

    Like

    • Hi Leela,

      in reply to your query I will go with consultants and do changes in each interfaces separately. As this is easier and less cumbersome for your future maintenance.

      Thanks,
      ~KKT~

      Like

      • Thank you. One more question. What would be the cases when we should use a customised KM?

        Like

      • Hi, In most cases, these Knowledge Modules do not need to be edited, but there are situations where you may have to, or want to, customize a Knowledge Module to achieve a specific scenario. A good example would be to remove certain commands or a piece of code from a KM to gain higher performance. Another example would be to combine commands or pieces of code from multiple KMs into one KM to achieve a particular functionality.

        I hope i clarified your query.

        Thanks.

        Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s