Tuesday, November 4, 2014

Summary of Quantitative Relationships

You can find the following excerpt in the book "Show Me The Numbers": Designing Tables and Graphs to Enlighten written by  Stephen Few.

  Show Me the Numbers Cover Graphic
 Front Cover


Quantitative Relationships
  • Quantitative information consists of two types of data:
    • Quantitative 
    • Categorical
  • Quantitative information always describes relationships
  • These relationships involve either
    • Simple associations between quantitative values and categorical subdivisions or
    • More complex associations among multiple sets of quantitative values.
  • There are four types of relationships within categories:
    1. Nominal
    2. Ordinal
    3. Interval
    4. Hierarchial
  • There are three types of relationships between quantitative values
    1. Ranking
    2. Ratio
    3. Correlation 


    You can purchase a copy of  "Show Me The Numbers": Designing Tables and Graphs to Enlighten online at the following web address: http://www.amazon.com/dp/0970601972/ref=cm_sw_su_dp


    Thursday, October 30, 2014

    Why it’s time to switch to Cloud BI


    Displaying image1.jpg


    •          Quick, Reliable, and Versatile    
    The Oracle Cloud BI allows you to create analysis’ in seconds. It allows you to edit views to create graphs that will allow your customers/consumers to easily distinguish the data you have provided for them. In Cloud BI you are now able to use all the BI apps on any mobile device. This allows for a very easy access to any of your data that is put into the Oracle Cloud. Cloud BI may be used through small groups all the way up to an entire organization. The product can be personalized for the optimal use for any amount of members.


    •          Secured
    Cloud BI is moderated through the Oracle Public Cloud. The Oracle Public Cloud meets all of the industry's strictest standards for security. The data that is stored into the Oracle Cloud is never passed through third parties. This should allow the customers to know that their data can be stored safely and not have to worry about hackers accessing their private information.


    •          Easy to Learn
    Cloud BI has a substantial amount of guidance that allows all users to easily access any type of training and tutorials that they please on the product. There are already many tutorials and training videos that Oracle has put out to allow customers to n and get a head start on the product.

    Here is a good website to start on your training and tutorials:
    http://docs.oracle.com/cloud/latest/reportingcs_use/index.html





    Oracle Cloud BI is a necessity for any organization that is trying to get the most reliable and efficient analytics platform while reducing the need for dedicated hardware and software installations


    Displaying image2.jpg

    Wednesday, October 22, 2014

    OBIEE 11g PDF printing bug related to Page Number on Footer of analysis

    When attempting to print an analysis that has a Page Number variable displayed in the page header or  footer, the following error is displayed:

    Error: "Sax parser returned an exception. Message: Expected whitespace. Error Codes: UH6MBRBC"

    The problem is related to OBIEE 11g bug 18601947 which is described on Oracle Support below:


    When Exporting a Dashboard to PDF with a Page Number in the Header or Footer
    (Doc ID 1913713.1)
    https://support.oracle.com/epmos/adf/images/t.gif


    https://support.oracle.com/epmos/adf/images/t.gif

    Applies to:

    Business Intelligence Server Enterprise Edition - Version 11.1.1.7.140415 to 11.1.1.7.140527 [Release 11g]
    Information in this document applies to any platform.
    **Updated on 15-Oct-2014**

    Symptoms

    When you export a dashboard that has a page number (@{pageNumber}) in the footer or header to PDF, the following error appears:
    Error
    ====
    Sax parser returned an exception. Message: Expected whitespace, Entity publicId: , Entity systemId: , Line number: 33, Column number: 21
    Error Details
    Error Codes: UH6MBRBC
    Location: saw.subsystem.portal, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

    Note: If you remove the page number (@{pageNumber}) from the footer that has been set at the dashboard properties level, this error no longer occurs.

    Cause

    Bug 19010387 - SAX ERROR WHEN EXPORT A DASHBOARD TO PDF WITH PAGE NUMBER (FOOTER OR HEADER)
    Bug 18601947 - PM: RESOLVE BASIC HTML IN VIEWS CONTAINING FMAP AND PAGENUMBER
     

    Solution

    This issue has been fixed in Patch 18601947 which can be download from My Oracle Support (http://support.oracle.com).