Posts

Posts

  • Richard Chan (Neodata Australia)
    Oracle Developer Suite 10gR2 (10.1.2.0.2) download
    Topic posted July 18, 2019 by Richard Chan (Neodata Australia)Silver Medal: 2,000+ Points, tagged Data Visualization in Business Analytics > Data Visualization public
    Title:
    Oracle Developer Suite 10gR2 (10.1.2.0.2) download
    Summary:
    Looking for Oracle Developer Suite 10gR2 (10.1.2.0.2) download
    Content:

    Oracle Developer Suite 10gR2 (10.1.2.0.2) 

    Looking for a download for this to show Report Developer migration to cloud, however this is no longer available on the Oracle download pages

     

    Richard

    Version:
    10.1.2.2.0.2
  • Brian Hall
    COUNT(DISTINCT ODD RESULTSAnswered2
    Topic posted July 18, 2019 by Brian HallBronze Medal: 1,250+ Points, tagged Data Visualization in Business Analytics > Data Visualization public
    Title:
    COUNT(DISTINCT ODD RESULTS
    Summary:
    count in SQL DEV different than DV ??
    Content:

    We are tying to validate our reports.  We get different numbers when we run My Calculations "COUNT(DISTINCT VOUCHER_ID)" in DV TILE versus "COUNT(DISTINCT VOUCHER_ID)"Oracle SQL Developer. 

    Both use the same SQL (pulled SQL from DV paste into SQL Dev), same ADW. 

    I have refreshed the Dataset more than once today.  DV is processing this dataset differently than SQL Dev.  How?  I have lost

    count 318 in DV

    count 550 in SQL DEV

    Version:
    18 , Cloud
  • Nirbhay singh
    DV visualization wrong data in case snowflake schema
    Topic posted June 29, 2019 by Nirbhay singh, tagged Data Visualization in Business Analytics > Data Visualization public
    Title:
    DV visualization wrong data in case snowflake schema
    Summary:
    Report output is wrong when i am running a data from snowflack
    Content:

    Hi all , 

    My Db connection is from SQL server database and imported 3 tables .A Factinventry table which is connected to Product dimension  table and product dimension  is further connected with Product _Subctegory.

    Created a DV project in DV and bring all 3 tables and joined in Data Diagram, now i am selecting a measure column from FactInventry.TotalQty and product category from product_subcategory table  and it is suppose  to show the data sum by product category but it is showing a column black with total sum TotalQty.

    Can anyone tell me if DV support the snowflake  join or only star join only ?

     

     

     

    Version:
    DV desktop -Version 12.2.5.3.0-20190529084035
  • Andy Wan
    Map Layer file size limit
    Topic posted June 20, 2019 by Andy Wan, tagged Data Visualization in Business Analytics > Data Visualization public
    Title:
    Map Layer file size limit
    Content:

    Hi,

    I am trying to add a custom map layer that exceeds the maximum supported file size 25MB on my Oracle Data Visualization Desktop.

    Is there a method that I can turn the file size limit off ? Or if anyone know another alternative for this situation?

     

    Much Appreciated,

    Andy

    Version:
    12.2.4.1.1
    Image:
  • Marybeth Snodgrass
    No category for Data Visualization to post in Idea LabAnswered35.0
    Topic posted June 14, 2019 by Marybeth SnodgrassGold Medal: 3,500+ Points, tagged Data Visualization in Business Analytics > Data Visualization public
    Title:
    No category for Data Visualization to post in Idea Lab
    Summary:
    I have several posts i would like to make regarding Data Visualization enhancements, however there is nowhere in Idea Lab for posts related to DV
    Content:

    Yes, this unfortunately it doesn't render on the graph as i'd like.. There is no way to hide the sort number measure when I plot on graph with the attribute like content authors can to with OTBI. Also, there is no way to sort these values in my filter list of values, as is enabled in OTBI.

    I know that OAC is Oracle's new baby and that you are working hard to create an Oracle product that can be a legitimate competitor with Tableau. We have several enhancement requests/opportunities to improve the product, as we are currently trying to convince our university admissions team not to purchase Tableau (which they are pushing for HARD, especially those with previous Tableau experience) and to use OAC DV, which the university has already purchased as a whole, instead. A lot of "why can't i do (fill in the blank) like i can with Tableau?

    Would love to post such items in the Idea Lab, but there is no category to choose for Data Visualization..

  • Sravan Jayannagari
    Is there any way to restrict the data shown in visualization...2
    Topic posted June 13, 2019 by Sravan Jayannagari, tagged Data Visualization in Business Analytics > Data Visualization public
    Title:
    Is there any way to restrict the data shown in visualization based on user in Oracle Analytical cloud.
    Summary:
    Is there any way to restrict the data shown in visualization based on user in Oracle Analytical cloud.
    Content:

    Hi,

    We have created a Visualization report in Oracle analytical cloud with three data sets.

    We have a scenario to restrict the user to see their own data, data contains different regions/business units.

    We are going with below approach. 

    --- Comparing user with application user and applying expression filter with user name. It will fetch data pertaining to that user.

    --- In some scenarios its working fine and sometimes it's showing full data to user which he didn’t have access, Once we refresh the report then its filtering out the data as expected.

    Please suggest. 

    Thanks,

    Sravan

  • Marybeth Snodgrass
    No option to manually rearrange the sort of dataAnswered85.0
    Topic posted June 11, 2019 by Marybeth SnodgrassGold Medal: 3,500+ Points, tagged Data Visualization in Business Analytics > Data Visualization public
    Title:
    No option to manually rearrange the sort of data
    Summary:
    Need sort option by letter grade ("A+", "A", A-", "B+", etc.") - critical need for universities
    Content:

    We have a critical need to be able to drag and drop to reorder bars in graphs.

    Our specific urgent use case is to correctly order by student grade for a class: Need the order to sort: A+, A, A-, B+, B, B-, etc. The only options currently available is alphabetically, rendering the only order to be A, A+, A-, B, B+, B-, etc.

    In Tableau, this can be done by dragging and dropping the bars in graph to the position you want.

  • Kanaka Mohan
    OAC DV Project - Auto Save option set as default1
    Topic posted June 11, 2019 by Kanaka MohanGreen Ribbon: 100+ Points, tagged Data Visualization in Business Analytics > Data Visualization public
    Title:
    OAC DV Project - Auto Save option set as default
    Summary:
    OAC DV Project - Auto Save option set as default
    Content:

    Hello,

    In OAC our users have reported that for them "Auto Save" option is set as default when working on DV Project.

    Is there option/setting where we can disable the option for all the users. As our users prefer to not to be a default option

    Thanks,

    Kanaka

     

  • Roberto Espinosa
    MacOS DVD Configure Python3
    Topic posted June 11, 2019 by Roberto Espinosa, tagged Data Visualization, Machine Learning in Business Analytics > Data Visualization public
    Title:
    MacOS DVD Configure Python
    Summary:
    Error when executing DVD Configure Python on Mac
    Content:

    Hi Team,

     

    I'm getting this error after installing DVD latest version (12.2.5.3.0) on my Mac:

     

    echo Downloading Installer for Python Framework;
        /Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/jdk/jre/bin/java -Doracle.bi.rinstall.timedilation=1 -Doracle.bi.product.dir=/Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1 -Doracle.bi.proxy.log.dir=$TMPDIR -jar /Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/modules/oracle.bi.dvdesktop.installer/rinstall.jar -download=true -url=https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg -filePath=$TMPDIR/BiPython_Framework.pkg;open -W $TMPDIR/BiPython_Framework.pkg; /usr/bin/osascript -l JavaScript '/Applications/Oracle Data Visualization Desktop Configure Python.app/Contents/Resources/Scripts/DVDesktop_JSON_Writer.scpt';rm $TMPDIR/BiPython_Framework.pkg
    McBkPr-RES:~ robertoespinosa$ echo Downloading Installer for Python Framework;
    Downloading Installer for Python Framework
    McBkPr-RES:~ robertoespinosa$ /Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/jdk/jre/bin/java -Doracle.bi.rinstall.timedilation=1 -Doracle.bi.product.dir=/Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1 -Doracle.bi.proxy.log.dir=$TMPDIR -jar /Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/modules/oracle.bi.dvdesktop.installer/rinstall.jar -download=true -url=https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg -filePath=$TMPDIR/BiPython_Framework.pkg;open -W $TMPDIR/BiPython_Framework.pkg; /usr/bin/osascript -l JavaScript '/Applications/Oracle Data Visualization Desktop Configure Python.app/Contents/Resources/Scripts/DVDesktop_JSON_Writer.scpt';rm $TMPDIR/BiPython_Framework.pkg
    Jun 11, 2019 5:00:06 PM oracle.bi.exec.ExecScript executeScript
    INFO: Executing: [/Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/modules/oracle.bi.configutils/internetproxylookup.exe, https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg]
    Jun 11, 2019 5:00:06 PM oracle.bi.exec.ExecScript executeScript
    INFO: Logging script stderr to /var/folders/qk/7dknhwdx52vbv9ypnf2pt8q00000gn/T/proxyProvider.log

    Jun 11, 2019 5:00:06 PM oracle.bi.dvdesktop.birinstall.RInstall mainNoExitDownload
    SEVERE: Download failed: Unable to get proxy for https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg
    java.lang.RuntimeException: Unable to get proxy for https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg
        at oracle.bi.dvdesktop.birinstall.Download.copyURLtoFileWithProxy(Download.java:46)
        at oracle.bi.dvdesktop.birinstall.RInstall.mainNoExitDownload(RInstall.java:121)
        at oracle.bi.dvdesktop.birinstall.RInstall.mainExitDownload(RInstall.java:81)
        at oracle.bi.dvdesktop.birinstall.RInstall.main(RInstall.java:59)
    Caused by: oracle.bi.install.environment.ProxyException: Execution of proxy lookup command failed
        at oracle.bi.install.environment.MacProxyProvider.getProxy(MacProxyProvider.java:84)
        at oracle.bi.dvdesktop.birinstall.Download.copyURLtoFileWithProxy(Download.java:42)
        ... 3 more
    Caused by: oracle.bi.exec.ExecutionStatusException: Execution of [/Applications/dvdesktop.app/Contents/Resources/app.nw/OracleBI1/modules/oracle.bi.configutils/internetproxylookup.exe, https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg] failed with exit value 139
        at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:106)
        at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:191)
        at oracle.bi.exec.ExecScript.executeQueryScript(ExecScript.java:106)
        at oracle.bi.install.environment.MacProxyProvider.getProxy(MacProxyProvider.java:82)
        ... 4 more

    Runtime exception caught mainNoExitDownload java.lang.RuntimeException: Unable to get proxy for https://oss.oracle.com/DVML/DVML-1.0.1-macos.pkg
    The file /var/folders/qk/7dknhwdx52vbv9ypnf2pt8q00000gn/T//BiPython_Framework.pkg does not exist.
    rm: /var/folders/qk/7dknhwdx52vbv9ypnf2pt8q00000gn/T//BiPython_Framework.pkg: No such file or directory

    It seems it is trying to execute a ".exe" file!

    Any ideas how to get Advanced Analytics running on Mac?

     

    Thanks

    Roberto

     

    Version:
    12.2.5.3.0
  • Kanaka Mohan
    DV Project - Filters are not getting applied uniformly...
    Topic posted June 7, 2019 by Kanaka MohanGreen Ribbon: 100+ Points, tagged Data Visualization in Business Analytics > Data Visualization public
    Title:
    DV Project - Filters are not getting applied uniformly across visuals when built using different OBIEE subject areas
    Summary:
    DV Project - Filters are not getting applied uniformly across visualization when built using different OBIEE subject areas
    Content:

    Hello,

    We are observing following issue in DV Projects. 
    When a project is built using multiple OBIEE Subject areas, we are seeing the filters are NOT getting applied uniformly across visualizations. This issue is occuring for users having DV Consumer role.

    For example. A project is being built using two OBIEE subject areas (SA1 & SA2) and in project canvas, we have built two visualizations Vz1(from SA1) and Vz2(From SA2).
    In the filter section, if we using Time (Year) from SA1, then the Time filter is not getting passed in Vz2.

    Further we observed that if we give users DVAuthor role and also access to Subject areas we are not seeing above issue. However this work around is not acceptable to our business users.

    Has anyone faced similar issue

    Thanks,
    Kanaka

    Version:
    18.3.3-69