Oracle Analytics

Get Involved. Join the Conversation.

Comments

  • Jonathan Johnson

    FYI: The issue is experience when installing BI Publisher Standalone.  I experienced this issue on the latest download of BI Publisher 12.2.1.4 and Weblogic 12.2.1.3 (infrastructure).  I also installed Weblogic patches (27401639,27479453,27823500,29650702,30386660), Opatch patch (6880880), and OBIEE patch (29640387) on Windows Server 2016 using JDK 1.8.0_181.

  • Jonathan Johnson

    I found a possible resolution for the error by the OP.  Browse to the following %ORACLE_HOME%\bi\modules\oracle.bi.sysman\syscomp\create_bi_service_instance.cmd then edit the .cmd on line 154 it has "SET ORACLE_HOME=%~dp0..\..\..\..\.. "  I just took out the last ".." and it worked for me.  You can ensure you take out the right amount by browse to that folder in command prompt then issuing cd ..\..\..\..\ to ensure that goes to your ORACLE_HOME directory.  Or just set it manually .. after the = then something like C:\Oracle\Middleware\Oracle_Home .  I've been looking for a solution for this issue for years.  Finally found it!  Also, Saresh's comment found in Oracle's notes may work on a Linux install.  It's the solution I found while working with Oracle Support. I've found that on Windows the issue is different.

    Thanks,

    Jonathan Johnson

  • Chethana Kumari

    Hello,

    Any updates on this please? This is of highest priority for us to work on. Does OAC not support about 15 lakhs records to be loaded as a dataset?

    I am using OAC version 105.3.0-120.

    Expecting your responses.

    Thanks,

    Chethana

  • Chethana Kumari

    Thanks a lot folks. I will try this out.

    Regards,

    Chethana

  • Brian Kelsey

    Hi Chethana,

    If you do not want to create an action off of the data, you can also create a link for informational purposes only utilizing the Text box component and creating the link within the message of the text box.

    Thanks,

    Brian

     

  • Aman Jain


    Hello Chethana,

    You can use data actions to navigate to an external URL from a canvas so that when you select a column such as the supplier ID, it displays a specific external website.

    Please refer the below oracle documentation for more information:

    https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/create-data-actions-connect-external-urls-visualization-canvases.html

    Hope this helps!

    Best Regards,
    Aman Jain

  • Christian Berg

    Shortest answer: It's not.

    Longer answer: There is no longer answer.

  • Greg

    The only way around this for me was to leave out a dimension from both the grid and filter. For me this is not a viable solution since I report off of an Essbase cube and need to be able to filter on every dimension. I spoke to the Oracle Dev guys and they say that they are working on a patch fix which will become available soon. I'm not sure what "soon" means since I've had a ticket open with them for over 5 months now. 

  • Johan Pretorius

    Hello Greg, Facing the exact same issue when pulling FCCS into OAC. OCI instance so can't check instance but EPM 19.10.

    Did you resolve the issue or change the report layout?

    Thanks

  • Chethana Kumari
  • Christian Berg

    Exactly. No backups mean that it's all gone.

    Be mindful that "cloud" doesn't mean you don't have to think about the usual management tasks like backups, snapshots etc.

  • Chethana Kumari

    Thanks Aman. Unfortunately, I have'nt taken any snapshot of the instance before deleting the datasets and projects.

    This means I would not be able to restore, right?

    Regards,

    Chethana

  • Aman Jain

    Hello Chethana,

    You can restore your instance snapshot (Console -> Snapshots) which was created before this deletion, you will get all your content back (the instance will be the same as when the snapshot was taken).

    Hope this helps!

    Best Regards,

    Aman Jain

  • Donald Ferreira

    Hello Aman,

    Attached the catalog file for your reference.

    Regards,

    Donald

  • Donald Ferreira

    Hello Aman,

    Thank you very much for the document. Something new I learned.

    Created a new OTBI with same Subject Areas, with 3 columns and they worked like you have mentioned in your document. I could see a new column coming up in the 2nd Subject Area.

    ------------------------------------

    The Actual OTBI Report

    ------------------------------------

    Took a new copy of the original version version

    I followed your document. At the end I added the last updated by column in the Subject Area 1.

    In the 2nd Subject Area, at the end of the layout, after the '...'.column,  I do not see any new columns coming up which would say 'Add Column (Last Updated By) 4th printscreen in your document.

    Therefore, in the 2nd Subject Area, I pulled out manually a  'Char' column and placed it at the end of the layout. It errors out the message “….number of columns and their data types…”

    I go to the Show Results layout, the column Last Updated By is missing

    I have attached the document of the sequence I am following, for your reference.

    Look forward to hearing from you.

     

    Regards,

    Donald