• Artificial Intelligence: Handbook for Mere Mortals

    We live in the technological revolution of artificial intelligence. We can now say that this is not science fiction, but neither are humanoid robots meant to replace us. Likewise, we still know very little about these technologies, even though our lives are already touched by them. That makes predicting the future very uncertain. There are those who boast about the results that will change our lives positively, and there are those who cry out about the impending doom. The fear is of what we do not know. As always, the answer lies in knowledge. How do machines have vision and object recognition capabilities? How do they understand human language? How does…

  • Real Time Face Detection with OpenCV e R

    Facial recognition (face detection) is an artificial intelligence technique used to verify a person’s identity from one or more images depicting him or her. As you might imagine, the fields of application are immense: from security (recognition of the person in front of the sensor) to image cataloging (many tools, such as Google Photos and Facebook, allow people to be recognized in photos). Some airlines use facial recognition to board passengers, and almost all cell phone models use facial recognition to unlock the device. In our exercise we will see how to identify (in a generic way) a face in an image or video.You will be surprised how it is…

  • 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…

  • 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

  • TOP 10 BUSINESS INTELLIGENCE TRENDS TO WATCH IN 2020

    In the analytics business and in the business world — business intelligence, analytical devices and BI applications are the main discussed subject. BI is quicker and progressively precise in reporting; data analysis is increasingly vigorous, and forecasting has changed essentially and developed massively. An ever-increasing number of companies have begun to value the worth of business insight (BI) with regards to their decision-making process. The previous couple of years have seen BI systems experience various advancements. With the rising multifaceted nature of the business intelligence environment, the distinguishing proof of trends and market improvements is a key factor in powerful decision-making. It is progressively imperative to utilize the most recent…

  • SQL Server: how to move tempdb database

    SQL Server doesn’t support moving TempDB Database using backup/restore or by using detach database methods. In this article I explain the steps you must follow to move TempDB database from one drive to another in SQL Server. However, for the changes to come into effect you must restart SQL Server Service. Start SQL Server Management Studio and execute the below query: USE master; GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = ‘C:\yourpath\tempdb.mdf’); GO ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = ‘T:\yourpath\templog.ldf’); GO Remember to replace yourpath with your preferred path. Once query is executed, SQL Server give you a message to remember you to Stop…

  • 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…

  • [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…