My current blog looks at the logical or business model. In particular how to connect fact tables so that you can get numbers from more than one fact in the same report – and actually show results. This aspect of OBIEE seems to cause a fair...
Read MoreMicrosoft SQL Server 2008 Analysis Services (SSAS) delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting you design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases....
Read More
1. RPD Editing Mode [supsystic-tables id='3'] 1.1. Modifying the Oracle BI Repository You can modify and extend the Oracle BI repository (RPD). This section provides information about RPD modification tasks. For some tasks, links to additional documentation are provided. Task: Open the Oracle BI Administration Tool The Oracle BI Administration...
Read MoreInternet of Things (IoT) and Big Data are growing as at astronomical rate and this can open new horizons for business in terms of new business models, products design, intelligent operation and improved customer services - which is why they occupy places at or near...
Read MorePre-requisite - Minimum java JDK version should be 1.7 build 15 and above - 3 GB space approximately - I am installing on VM windows 7 - 32 bit machine - Admin privileges is required Step 1: Make sure JDK is installed in your machine and set the JAVA_HOME environment variable Step...
Read More
OBIEE Reports/ Dashboards/Analysis Export to Unix/Windows/FTP Procedure 1 using EjB: Oracle Business Intelligence 11g, doesn’t provide any built-in method to allow Agent to automatically export/archive OBIEE11g content (Entire Dashboard(or) Dashboard Page(or) Analysis(or) Conditional Report of Agent(or) even Briefing Book) to file system, although this can be done...
Read More
ORACLE DATA VISUALIZER DESKTOP (DVD) Installation Oracle have recently released a desktop version of their Data Visualizer tool – which had until now just been a browser based tool available in an OBIEE 12c installation or the two BI Cloud or DV Cloud services. The current version...
Read MoreBI Publisher with JFreeChart an Open Source plotting API in order to generate plots that are not provided by BI-Publisher such as the Gantt chart type. The main steps are as follows: 1) Create the BIP data model: as an example I used the sample Gantt data mentioned...
Read More
1) Oracle Business Intelligence Suite Enterprise Edition (OBIEE) – comprehensive suite of enterprise BI products that delivers a full range of analysis and reporting capabilities – Contains components like BI Answers, Interactive Dashboards, Disconnected Analytics, Briefing Books, BI Administrator – Latest Version > 12.2.1.0.0 (as on 04-June-16) 2) Oracle Business Intelligence...
Read More