OBIEE

  • Oracle Analytics 105.4 Release

    /

    Oacle announced the Analytcs 105.4 are now available. Annouce on Oracle Blog: The latest updates to Oracle Analytics Cloud provides new functionality in two primary categories that will help you meet the breadth of all your business analytics needs. We released the 105.4 update with Augmented Self-Service (so everyone in your organization can get the right data at the right time) and deeper Integration with all the common big data sources with built-in security and governance (so you can easily share insights and collaborate with your colleagues). The following blog is designed to help you navigate this release and achieve faster time to insights. Augmented Self-Service Some popular requests have…

    read more

  • Oracle Analytics Named a Leader in Forrester Wave

    /

    All modern enterprises are on a quest to identify signals captured within data (created inside and outside the organization) and turn them into actionable insights. For many, it’s table-stakes in an increasingly digital world. For others, it seems like the search for the Holy Grail. https://blogs.oracle.com/analyticscloud/oracle-analytics-named-a-leader-in-forrester-wave

    read more

  • Reports fail with Logical drill graph level-‘to’ does not exist Error After Upgrade to 11.1.1.9.0

    /

    APPLIES TO: Business Intelligence Suite Enterprise Edition – Version 11.1.1.9.0 and later Information in this document applies to any platform. SYMPTOMS After an upgrade from 11.1.1.7.140715 to 11.1.1.9.0, certain reports – those based on the ABC subject area – now fail and throw the error below.  It was further determined that a newly created report with just the Customer > Customer No presentation column would also throw the error. Error View Display Error Logical drill graph level-‘to’: ‘####’ – does not exist. SQL: ‘{call NQSGetLogicalDrillGraph(‘ABC’,’%’,’####’,’%’)}’ Error Details Error Codes: KZDX4O6Q Location: saw.views.evc.activate, saw.subsystem.portal.pagesImpl, 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 A Global Consistency Check of the 11.1.1.9.0 RPD returned…

    read more

  • [nQSError: 14025] No fact table exists at the requested level of detail

    /

    APPLIES TO: Business Intelligence Suite Enterprise Edition – Version 11.1.1.9.170418 and later Information in this document applies to any platform. SYMPTOMS ISSUE CLARIFICATION ============================ Issue Seen : After Upgrading from OBIEE 10g to 11g the report throws the following error : State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14025] No fact table exists at the requested level of detail: [,,[AGENCY.Agency],[POPULATION.Population],,,,,,,,,,,,,,,,,,,,,,,,,,,,]. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: AGENCY.Agency, POPULATION.Population (HY000) The same reports are working fine in 10g. CAUSE The…

    read more

  • BI Server: sawserver.exe has stopped working in OBIEE 12c

    /

    I have a OBIEE 12c installation in Windows Server 2102 R2 (but i think this solution is valid for any windows installation). Installation process was successful and everything works perfectly, but randomly the nqsserver.exe crashes: While checking BI Services I can see that OBIS and OBIPS Services are in shutdown state and when I try to start it again I keep getting different errors, like “nqsserver.exe has stopped working”:   This issue is caused by another Weblogic installation in my server and is related to Weblogic that is unable to locate to Wbem files. To solve this problem you can edit the “start.cmd” file located at the path: E:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi_foundation\bitools\bin\start.cmd Line which…

    read more

  • OBIEE 12c Error: “Exceeded configured maximum number of allowed input records. Error Codes: EKMT3FK5.

    /

    When trying to export or run large reports the following error appears: Error: "View Display Error Exceeded configured maximum number of allowed input records. Error Details Error Codes: EKMT3FK5:OI2DL65P Location: saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool, saw.threadpool, saw.threads"

    read more

  • OBIEE 12c: Add page break in PDF

    /

    When you schedule a BI Answer with BI Agent to send a report in PDF format, you often need to place a page break between two different views of the analysis. To get this you can use the CSS code: Page-break-after: always; With this CSS, the pdf exported generate a page break in the exact point you insert the CSS. In your answer enter a new Static Text view, check the box “Contain HTML Markup” and add the following HTML code: <Div style = "page-break-after: always"> </ div> Drag the view between the two sections, where you want the pagebreak. Now, if you schedule a BI Agent that sends the report in a…

    read more

  • OBIEE: Rank function

    /

    The Rank function in OBIEE are described as follows: Syntax: RANK(expr) Description: Calculates the rank for each value satisfying the numeric expression argument. The highest number is assigned a rank of 1, and each successive rank is assigned the next consecutive integer (2, 3, 4,…). If certain values are equal, they are assigned the same rank (for example, 1, 1, 1, 4, 5, 5, 7…). But if you want to partition the rank by a specified column, you can use another syntax, not described in the tooltip: RANK(measure by attribute) For example to obtain the rank of “Product Sales” by “Fiscal Year” you can use: RANK("Fact – Product Sales".Cost by "Calendar"."Fiscal Year")…

    read more