• All
  • Advanced Analytics
  • AI & LLM
  • Amazon
  • Big Data & Cloud
  • ClearPeaks
  • Cloudera
  • CoolThoughts
  • Data Governance
  • Enterprise BI
  • ETL
  • Executive Analytics
  • Google
  • Informatica
  • KNIME
  • Microsoft
  • Observation Deck
  • Oracle
  • Qlik
  • Snowflake
  • Tableau
  • Visualizations
  • Web & Mobile BI Development
When assessing the success of a BI project, one of the most important KPIs to take into account is the usage of the BI solution being delivered. A high BI solution usage is always understood as a success of the BI project. So you need an easy way of tracking who is using the BI solution you just implemented. On the other side, you also may want to know who is trying to access the system without being granted access. This may help you to discover malicious or unauthorized access attempts to your BI system.

08 septiembre, 2010

ClearPeaks exhibitor for Oracle Business Intelligence Enterprise Edition 11g Launch Event

ClearPeaks is pleased to sponsor and exhibit at Oracle´s upcoming 'Business Intelligence Enterprise Edition 11g Launch Event' in London, July 7th. An important global event for Oracle, the unveiling of Oracle BI 11g, will be attended by Oracle President, Charles Phillips and Executive Vice President of Product Development, Thomas Kurian who will be presenting on why OBI 11g technology is the Best-in-Class BI Solution out there.
22 junio, 2010

Oracle BI EE not only helps you to visualize information using charts and graphs, but it also gives you the opportunity to add geographical dimension to your reports.

With today’s globalization of business, many organizations have their branch offices located in various countries or even across different continents. Viewing individual branches and their performance, presented on the geographical map, can give companies further insights into their business. Oracle provides a powerful engine that can analyze and display the data from your data warehouse on the map or even integrate it with Google maps.
19 marzo, 2010
One of the things OBIEE doesn’t have out of the box is a user comment option (although future versions may have integration with Oracle Webcenter, which provides social computing). So what are our options if we need to leave comments about specific reports/dashboards or give users the option to add documentation to the reports? One option is to embed Google wave in an OBI dashboard for feedback and wiki type documentation. Google wave is a new kind of collaboration tool that combines elements of email, wiki and chat. Basically everything on a wave can be edited. A varying number of users can be part of the wave or it can be public like in the example below. A wave can be embedded on any Web page. An embedded wave can be edited either on the page itself or through Google wave accounts.
19 febrero, 2010
Sometimes we need to combine measures from two fact tables in the same report and apply a filter to one of them. If the filter is on a dimension shared by both fact tables; that’s great. However, if the dimension is only related to one of the facts, then we have a problem: Oracle BI would show null values for a measure that’s not related to the dimension. Imagine that we have two fact tables: Revenue and Budget. Revenue is recorded for Product but also contains information about General Ledger (GL) Account. Budget is defined for Product but not for GL Account so there’s no relationship between them. Our business model is shown in the image below. Of course in a normal repository there would be more dimensions and facts but they have been left out to clarify the example.
15 diciembre, 2009
If you are using an Essbase data source, you may be interested in learning more about the relationship between Essbase cubes and your Oracle BI EE platform. It is quite common to find a dimension with multiple hierarchies in a BI project. This is managed in Oracle BI by creating a Dimension object with multiple child levels at a point that converges into the same leaf level. This looks quite easy when the physical data source is a relational database. However, when the physical data source is an Essbase cube, the process is a bit more complex.
08 diciembre, 2009
If you want better performance from your data warehouse, one of the most efficient solutions is to create aggregate tables. In this post we will have a look at how Oracle Materialized Views and query rewrite option can help you do it. You can quickly implement aggregates in your data warehouse and you don’t need to make any changes in your existing reporting universe. Aggregates become available automatically when they are ready for use. And using Materialized Views makes your aggregate solution completely independent from your reporting tool. Aggregate navigation is the process of determining the most efficient source for a user’s query. Oracle Materialized Views are database views whose results are cached in a table and can be returned from the cache instead of creating a new database query. In short, Materialized Views permit aggregate navigation in the Oracle Database instead of your reporting tool. Let’s have a look at how aggregate navigation is normally defined in Oracle Business Intelligence and Business Objects. Then let’s see how we can benefit from using Materialized Views.
24 noviembre, 2009
Loading new posts...
No more posts