BI Blogs

I’m currently working on a paper on Oracle BI Suite Enterprise Edition (OBI EE) for Discoverer users, for the upcoming ODTUG conference at Daytona Beach, and a tricky area that I’ve come up against recently is getting the metadata layer in a state suitable for performing time-series queries. One of the strengths of Discoverer is it’s support for analytic and time-series (lag, lead, window etc) queries and any customer looking to migrate to Answers and Interactive Dashboards would want to make these new tools have similar capabilities.

Taking a look through the OBI EE documentation, it appears there is some basic support for time-series queries, in the form of AGO and TODATE. AGO gives you, for example, the value of sales one month ago or one quarter ago, whilst TODATE gives you the total of sales month-to-date, or quarter-to-date, or year-to-date. Both of these time-series functions rely on the existence of a time dimension in your business model and mapping layer, with the period you can refer to in the AGO and TODATE functions being determined by what levels you have in this time dimension. I found, however, the time dimension a bit tricky to set up, but now I’ve got it working, I thought I’d jot down some notes on how the process works.

As a quick recap: dimensions in OBI EE define drill paths in your data, and are a prerequisite if you want uses to be able to drill down from say all customers, to region, then warehouse and finally ship to.

Each level has at least one logical key, the top level is marked as the “grand total” level, and you can drag other attributes in to each level and have OBI EE display those, rather than the level key, when users drill down in reports. At present, you have to create these dimensions manually when setting up your business model and mapping layer, although there is talk about automatically creating these when importing Oracle dimensions or OLAP structures, or when using the soon-to-be-delivered Discoverer migration utility. In my case though, I create them all manually which is usually a five or ten minute job at most.

For the migration paper I’m working on for the ODTUG event, I’m bringing across the Videostore example dataset that comes with Discoverer Administrator, on the basis that everyone running Discoverer has got it and most people are familiar with its contents. To keep things simple, I’m initially working with the main sales fact table, SALES_FACT and the three dimension tables it links to, TIMES, PRODUCT and STORE. One additional step I had to carry out though to get everything working was to create two additional views in the VIDEO5 schema:

A view over the TIMES table to add additional month and quarter attributes that are used to display month and quarter names, and to permit their sorting (like alternate sorts in Discoverer)

create or replace view times_view
       (time_key
,      transaction_date
,      day_of_week
,      holiday_flag
,      month_mon_yyyy
,      month_id_yyyy_mm
,      year_yyyy
,      quarter_q_yyyy
,      quarter_id_yyyyq)
AS
       select time_key
,      transaction_date
,      day_of_week
,      holiday_flag
,      substr(to_char(transaction_date,'MON'),1,1)
       ||lower(substr(to_char(transaction_date,'MON-YYYY'),2))
       as month_mon_yyyy
,      to_char(transaction_date,'YYYYMM') as month_id_yyyy_mm
,      to_char(transaction_date,'YYYY') as year_yyyy
,      'Q'||to_char(transaction_date,'Q-YYYY')
       as quarter_q_yyyy
,      to_char(transaction_date,'YYYY')
       ||to_char(transaction_date,'Q') as quarter_id_yyyyq
from   times;

And a view over the SALES_FACT table to allow it to be joined to the TIMES_VIEW view on the transaction_date column (a date datatype) rather than the TIME_KEY column (a number datatype) – this is because I found I needed to make the primary key for the logical TIMES table a date, rather than a number, to get the time-series offset calculations working:

create or replace view sales_fact_view
      (cost
,      customer_count
,      product_key
,      profit
,      sales
,      store_key
,      transaction_date
,      unit_sales)
as
select cost
,      customer_count
,      product_key
,      profit
,      sales
,      store_key
,      transaction_date
,      unit_sales
from   sales_fact, times
where  sales_fact.time_key = times.time_key;

Theoretically, at least the view over the time dimension shouldn’t be necessary, as you can create virtual (calculated) columns within OBI EE, but when I tried to do this, although the columns created OK I had trouble using them with the AGO and TODATE functions; it may also be the case that you can use non-date columns for the time dimension primary key, but again I had problems getting this working. What I’m showing here is what eventually worked for me, but feel free obviously to try and build things without these views, and let me know if you get it working.

Anyway, once the views are created, I then imported them in to the physical layer of the common enterprise information mode, created a primary key key on the TIMES_VIEW.TRANSACTION_DATE column, and foreign keys on the SALES_FACT_VIEW.PRODUCT_KEY, TRANSACTION_DATE and STORE_KEY columns, linking back to the relevant tables/views. Once this was done, I dragged the whole set of Videostore tables and views over to the business model and mapping view to create a set of logical tables, like this:

After running the rename utility to put all the column and tables names in to sentence case, remove the underscores and so on, it was time to create the time dimension, which I called TimesDim.

Creating a time dimension is initially the same as creating a regular dimension, except on the dimension properties dialog you tick the “Time dimension” tickbox, like this:

Then, I created five levels for the dimension:

1. All Years
2. Year
3. Quarter
4. Month
5. Day

and then dragged the TRANSACTION_DATE column from the TIMES_VIEW logical table on to the day level, the MONTH_IDYYYYMM column on to the month level, the QUARTER_ID_YYYYQ on to the quarter level, and left the year level empty as it’s a grand total level. For the day, month and quarter levels, the columns dragged on to them were registered as logical level keys and also as the primary key for each level – the rationale here being that in DATE, YYYYMM and YYYYQ format, column values were sortable which is a requirement for performing rolling-window time-series calculations.

Next, to finish off the dimension, I dragged the MONTH_MON_YYYY column on to the month level, added it as a level key but kept the previous value as the primary key, like this:

I then edited each level key and ensured the “Use for drilldown” checkbox was unchecked for the YYYYMM value, but checked for the second, MON-YYYY value, so that the correct column was used for organizing the level values but users saw friendly looking month names when they drilled into time dimension values.

After doing the same for the Quarter dimension, I then went back to the day, detail level and carried out one more task, and the one that’s essential for a time dimension – marking one of the logical keys as being the Chronological Key. In my case, I marked the key created using the TRANSACTION_DATE column as being the Chronological key, which worked for me.

According to the docs, the chronological key has to be a “monotonically increasing value” which stumped me a bit; I tried using just a number field but I couldn’t get the time-series queries to output the correct values for month ago sales and so on, but this could more be down to my unfamiliarity with the feature – again, if you know better, let me know.

Once everything was done, and I added the other detail day-level attributes into the day level, my dimension looked like this:

with each level containing the following columns:

1. All Years Level (grand total level) – no keys or columns added
2. Year Level – YEAR_YYYY column, set as primary key, set as logical key
3. Quarter Level – QUARTER_ID_YYYYQ set as primary key and logical key but with “use for drilldown” disabled, together with QUARTER_Q_YYYY set as a logical key and enabled for drilldown
4. Month Level – MONTH_ID_YYYYMM set as primary key and logical key but with “use for drilldown” disabled, together with MONTH_MON_YYYY set as a logical key and enabled for drilldown
5. Day Level – TRANSACTION_DATE set as primary key and logical key and enabled for drilldown, DAY_OF_WEEK and HOLIDAY_FLAG set as attributes and not used for drilldown.

The next step was to tell OBI EE to sort the MONTH_MON_YYYY column by the MONTH_ID_YYYYMM column, and the QUARTER_Q_YYYY column by the QUARTER_ID_YYYYQ column, as whilst the latter columns were more readable (“Q3 2000”,”Jun-1999” and so on) they don’t sort properly by default (the year would start “Apr-1998”, followed by “Aug-1998” and so on). To do this, I double-clicked on the columns to be sorted and picked the other columns as the one to sort them by, like this:

Now the time dimension and logical table were set up, I could create my time-series functions. To start off, I used the AGO function to calculate the sum of sales one month ago, based on the SALES_FACT.SALES column, using the following formula:

AGO(Videostore."Sales fact view".Sales, Videostore.TimesDim."Month", 1)

…with "Sales Fact View".Sales being the base measure, Videostore.TimesDim.Month indicating that within our time dimension, we’re going to use months as the offset, and 1 indicating that we’re going back 1 month.

So, now it’s time to test it out. After dragging all the logical columns to the presentation layer and saving the changes to the repository, I started up Oracle BI Answers and ran a query showing sales month-by-month with last months sales next to them, like this:

Not bad. Running it at the day level gave similar results.

Using the expression editor, I created another logical column, this time using the TODATE function to create month-to-date values, using the expression:

ToDate("Videostore"."Sales fact view"."Sales" , "Videostore"."TimesDim"."Month" )

with "Sales fact view"."Sales" being the base measure, and "Videostore"."TimesDim","Month" indicating we’re going a month-to-date (as opposed to, say, year-to-date) total.

Then, running the day-level report created a moment ago, along with this new month-to-date attribute, gave the following results:

Looking back, the tricky bits were firstly, adding all the derived month and quarter values for the times logical table, which I tried doing using the EXTRACT and CAST features of BI Server SQL, but in the end found much easier just deriving as part of an Oracle view. The second tricky part was working out that the chronological key was only defined at the bottom (day) level, and that it should be a date datatype – this might be wrong, but it’s the only way I got it working. The final tricky bit was sorting the month and quarter descriptive columns by the YYYYMM and YYYYQ columns – without these, either the months and quarters were listed in the wrong order, or worse, they were in the right order but the time-series calculations were sometimes wrong. Going down the route I’ve outlined in this article made it work for me, but as I say if there’s a simpler way just let me know.

Young companies need to focus on strategy and on growing their business. That’s why it is important to properly investigate before you choose a new brand or company name and register it. But even if you do you can never be sure no one will dispute your right to use it. We decided not to […]

Chris Webb has recently released a really interesting tool: MDX Script Performance Analyzer. It’s a really interesting idea that will save me (and you) a lot of time trying to understand the root of a performance issue into an MDX Script of a cube. Thank you Chris, if I only had this tool three months ago!

Chris has also posted the news of an Analysis Services Load Testing tool that is available on CodePlex. More than the tool, it is the available documentation (which is a draft) that deserves most of your attention, beacuse illustrate you how to setup all the test environment using Visual Studio 2005.

The movement in the Peformance Management (PM) market of late seems to be heating up as mergers and acquisitions have seen some PM vendor consolidation as vendors start to beef up their PM product line. You can go back a few years to when all this started to happen with many vendors offering dashboards and scorecards on top of their BI platforms. Early PM products were somewhat lightweight starting out supporting just one thing e.g. scorecards or planning or budgeting. BI vendors focussed on strategic performance management and tried to battle it out with ERP vendors for CFO mindshare. Meanwhile operational performance management was ignored. Even today it is difficult to find PM products that allow you to declare the full business strategy to the software i.e. actually entering text for stategic business objectives, key initiatives, KPI owners, KPI targets, plans and activities, budgets and adding commentry on trends. Most were just associated with KPIs only and traffic lights.

Early PM products had a lot of limitations including separate databases from BI system data warehouses which meant that they could only show summary data and offer limited if any drill down into detail to understand why a traffic light has gone red. Key to most executives and particularly CFOs is planning and budgeting and so it is not surprising that we saw various acquisitions of Planning and Budgeting vendors to add to PM products that focussed on scorecards initially. Cognos acquisition of Adaytum comes to mind in this space.

More recently as process management has started to take hold as a key element of service oriented architectures (SOA), the areas of Business Activity Monitoring and Activity Based Costing have come under the spotlight as companies as questions about their operational process efficiency and the cost of their operational activities which form the steps in their processes. Interest in Activity Based Costing has been steadily growing over the last few years to the extent now that the link between ABC, planning and budgeting is becoming clear. Companies want Performance Management software to thread together:
• Support for Performance Management methodologies e.g. Balanced Scorecard, TQM, Baldridge
• Business Objectives
• KPIs and KPI targets to track performance to see if objectives are being met
• Owners who are accountable for the performance of a KPI
• Key Initiatives that a company intends to implement to achieve each objective
• The plan for each initiative - i.e. the activiies in the plan
• The budget for each initiative - how much the company can spend on each initiative
• Activity based budget - to see the planned spend for eash activity in a plan
• Activity based costing - for actual costs of plans against budget at the activity level
• Business Activity Monitoring for live monitoring of operational process performance management

I have lost count how many clients of mine now want to see costed in plans against budgets at the activity level. So it is no surprise to me that ABC is growing.

Looking at the market it may have been a visionary move by SAS when acquiring ABC Technologies to add to it’s PM offerings a few years back (or just plain good fortune). Also last year we saw Business Objects step into the Activity Based Costing market by acquiring ALG. Cognos acquired real-time Business Activity Monitoring (BAM) vendor Celequest fairly recently. Then Oracle stepped into the market by acquiring Hyperion to plug the PM gap in it’s product line and just last week Business Objects announced their intent to acquire French PM vendor Cartesis.

So what is happening here? The answer is that we are seeing the consolidation of various pieces of the PM puzzle to create Performance Management Platforms that will sit on top of and integrate with BI platforms (typicaly from the same vendor). By Performance Management Platform I mean a complete suite of integrated tools for managing the buiness. This PM Platform is also likely to be integrated with Office applications, portal products and collaborative workspaces for sharing performance.

It takes me back to when we had a reporting tool from vendor A, an OLAP tool from vendor B, a mining tool from vandor C and an ETL tool from vendor D. Now we have complete BI platforms from one vendor. A key point here is that PM platforms are not the same as BI platforms but sit on top of the BI platform. Secondly PM is growing and lucrative while BI platforms are coming down in price fueled by Microsoft competitive pressure, Open Source and even the DW appliance market. Also ETL is separating from the BI platform and going enterprise wide under the guise of Enterprise Data Management.

There is still a lot more to come in the PM consolidation space. Also it has to grow beyond BI and go enterprise wide by integrating with business process management and SOA as well as collaboration tools and content management.

For example in many PM products today you cannot
• Associate a business objective in a scorecard with business process activities
• Associate a performance initiative defined in a scorecard with a plan and business process activities
• Link a process model to a scorecard strategy map
• Use performance management software to pin-point where in an business process to make improvements to optimise performance
• Use performance management software to initiate business activity monitoring (BAM) of activities in process models to identify process inefficiencies
• Use performance management software to cost activities in plans and business processes
• Use performance management software to link operational performance to one or more objectives on a scorecard
• Use performance management software to set up business rules for automatic real-time decision making

Performance management needs to ADD the following to make everyone performance aware
• On-Demand analytics & BI
• Real-time decisions and automated recommendations
• Guided analysis
• Event driven Business Activity Monitoring (BAM)
• Monitoring agents
• Automated real-time alerts
• Guided and recommended actions
• Active performance management scorecards capable of managing at strategic and operational levels
• Decision monitoring to see how effective decisions have been in terms of achieving targets
• Business intelligence driving business process rules behaviour
• Personalised scorecards to make them available to everyone

No doubt we will see a lot more acquisitions over the next 12 months

Dado el interés que tenemos en el uso que las administraciones públicas hacen de las nuevas tecnologías, TodoBI, es portal oficial del próximo evento sobre e-administracion, que se celebra los dias 12, 13 y 14 de Junio en Madrid.

Aquí os podéis descargar el folleto del mismo.

Estos son los objetivos que persigue el evento:

IIR España organiza su 6º Encuentro Anual sobre tecnologías en el Sector Público para que Vd. sepa cómo:
- Facilitar que los servicios y registros electrónicos estén disponibles en sistemas multicanal 24/365
- Transmitir transparencia y confianza en los procesos a los usuarios
- Conseguir que la web cumplan con la Ley de Accesibilidad Digital
- Fomentar una e-sociedad con una e-administración sólida
- Integrar la prestación de servicios en una “ventanilla única”

About ten years ago, my company (under one of its earlier names) decided to market a “data warehouse as a service” to customers in retail. For their money we would host a generic one-size-fits-all system capable of storing any type sales data. At the heart of this blackbox was a database running on Tandem Non-Stop […]

Yesterday evening I
attended our inaugural TDWI Boston Chapter meeting
hosted by Fidelity Investments. It was a very well attended meeting. In fact,
we had to change the meeting room because the registration response was double
what we were told to expect. Lucky for us, right out the door we had a great view
of Boston Harbor from a 14^th floor
vantage point.

Two things made this a
great experience. First, our keynote speaker was Wayne W. Eckerson who is the
director of research and services for The Data
Warehousing Institute (TDWI). (Full disclosure: I am vice president of the
TDWI Boston chapter and have known Wayne for years…so I am biased!)

His topic was "BI
Maturity Model: Taking Your Data Warehouse to the Next Level." It was an
excellent topic to kick-off our chapter.

Wayne gave his insights on this topic
but, more importantly, encouraged the audience to provide feedback and share their
own experiences.

This brings us to the
second thing that made the chapter meeting interesting, the attendees were
terrific. It’s great that Wayne encouraged participation, but
it’s the attendees who can transform the presentation into a discussion…and
they did. It was great to hear many people relate their experiences and offer
their feedback. We had people from many companies, representing different
industries and with varied experience.

Regional user groups
(RUGs) are generally focused on specific software vendors and their products.
These are often a great forum to gain product-specific information and network
with peers who are using the same software. I highly encourage people’s participation
in these groups if their job role involves design, development or supporting
these products. In addition, architects, project managers and IT management
involved with these products also benefit from participating in these groups.

TDWI, due to its
tradition, is offering vendor-agnostic chapters where BI/DW professionals and IT
management can meet, learn, exchange ideas and network. This enables a more
holistic discussion of BI, DW and performance management issues than at a
vendor-specific RUG. But there are
significant benefits to participating in both
vendor-specific and a-vendor agnostic RUGs.

This is a little of a
rah-rah post, but I truly believe many people would benefit from participating
in these RUGS, whether it is TDWI or vendor-specific. TDWI meetings are free,
as are vendor-specific meetings (as long as you are a customer or partner, of
course.)

In previous posts, I shared a lot of thoughts around how to deal with dilemmas. There will be lots more of that later, I hope, but for now there are a few new projects I am working on, that will feature in the blog.

A great way to end this series for now, is a few links. The papers published on http://smartbi.hyperion.com have now been translated in other languages as well. Here are the links:

France

:             http://smartbi.hyperion.com/fr/index.html?id=immersion_fr&link=frank_blog

Germany

:          http://smartbi.hyperion.de/index.html?id=immersion_de&link=frank_blog

China

:               http://smartbi.hyperion.com.cn/index.html?id=immersion_cn&link=frank_blog

So if you want to learn about CIO Dilemmas, or if you want to learn French, German or Chinese ;-), go there!!

frank

Last Wednesday I visited the Oracle BI seminar in Utrecht. Underneath you find a brief description of the highlights.
First of all Wouter van der Brugghen presented the Oracle BI strategy. Main strategic focus of Oracle BI is summarized below:

Primary marketing tagline is: Pervasive BI, meaning BI for […]

I just posted this bug on the Microsoft Connect site. Please vote it if you think it would be a useful change. This is the issue description.

If you set the”Aggregation Usage” to true for an attribute of a dimension (i.e. Customer), you cannot run the aggregation design wizard on a partition of a measure group that is not linked to that measure group.
You receive an error message, but it would be preferable a Yes/No dialog box that allow the user to continue considering an “Aggregation Usage” set to “Default” for that dimension only for this measure group.
Actually you can workaround this issue in two ways:

1. Changing the Aggregation Usage before/after using the aggregation design wizard (setting the desired value for the measure group you want to optimize)
2. Manually designing the aggregation (not a very comfortable practice)

I understand it is not a real bug, but the message is not coherent with what you can do anyway by changing aggregation usage setting.

I’m working on optimizing aggregations in these days and this limitation has been very annoying today, requiring me to write a set of specification just to explain how to redesign aggregations if in the future someone will make a structural change to the cube…

I was taking a look through the BI&DW presentation extracts for the upcoming ODTUG Kaleidoscope 2007 event next June, and I noticed quite a few that I’m keen to attend. The event is in Daytona Beach, Florida, and compared to the recent Collaborate event there’s quite a few presentations by various Oracle BI product managers and product “champions”; as well as the Oracle talks, there’s ones by Michael Armstrong-Smith, David Fuston, Michael Snyder and of course yours truly. Anyway, here’s ones that I’m particularly looking forward to:

• “Business Intelligence and Service-Oriented Architectures”, Phil Bates - Phil is the man within Oracle in EMEA for BI and SOA, I spent a few hours with Phil at events in the USA and UK but have never heard his formal BI & SOA talk. Should be useful and I’ll be using it as input into my next seminar series in the UK
• ‘Warehouse Builder 11g—What Is New and Where Do We Go From Here?’ and “Driving Your Data Integration Through Business Rules with OWB 11g Release 1″, Jean-Pierre Djicks - expect to see me at the front furiously taking notes on what’s coming up in OWB11g - rules-based mappings, support for real-time and SOA - should be good.
• “Enterprise Planning and Budgeting—Three Case Studies”, David Fuston - This will be interesting, EPB has pretty much been a slow-motion car wreck over the past five years, it’ll be interesting to see whether David has managed to get it working or it’s more a case of “it’s useful in limited circumstances, but still not a replacement for OFA”.
• “Oracle Business Intelligence Suite Enterprise Edition Architectural Overview”, Kurt Wolff - Kurt’s one of the original guys from NQuire, no-one knows more about OBI EE internals than this man. Hopefully it’s not too much of a beginners talk, at the least I’ll be able to button-hole him afterwards with all my technical questions.
• “Oracle Data Integrator for OWB Developers” and “Oracle Business Intelligence Enteprise Edition for Discoverer Users” - two talks by myself on what these new tools offer traditional OWB and Disco users, how you migrate and/or interoperate, where the products are going and how they’ll co-exist with the existing tools. Lots of demos as well, come along to see all the products in action and get some development tips from me.

On the subject of conferences, I also noted a very interesting and well informed blog posting by Michael Bowen on the recent Hyperion Conference in the States, and the message Oracle gave to Hyperion customers on how their products will fit in with the existing Oracle product line-up. You’re best off reading Michael’s posting to get the full details, but it seems to me that Hyperion products that are likely to be adopted are System 9, their CPM framework, together with products such as Hyperion Planning, Crystal Ball, Scorecard, Strategic Planning, FM and MDM, with Essbase and EIS being a bit less clear (read: probably maintained, but not the strategic direction for Oracle in their particular product segment) and OBI EE, Oracle Alerts and Oracle packaged BI apps staying on.

I’ll be honest and say I know very little about Hyperion, or the CPM segment in general, but Mike’s analysis seems reasonable and I’ll be at the Hyperion event myself in Lyon later next month to hear it all in person. Take a look at the article if you get a chance.

Como ya hemos comentado en articulos recientes, el mercado del Business Intelligence es uno de los que tiene un mayor movimiento empresarial, con continuas compras, fusiones, etc…
Oracle compra Hyperion
Cognos compra Celequest
Oracle ha adquirido mas de 25 compañias
BO se queda con Xcelsius

Pero como vemos, la concentracion va a seguir. Business Objects con su estrategia de ‘la mejor defensa es un buen ataque’ respecto a Oracle sigue con sus compras. Ahora le toca a Cartesis, un buen producto que tiene con Business Objects en común su origen francófono. En España tienen algunas referencias interesantes, no muchas, aunque ya no operan directamente, sino a través de Partners como Primal.

BO quiere comprar Cartesis (detalles), va a apagar 225 millones de euros en metalico, y pretende encuadarse dentro de la linea de productos EPM. Son fuertes, principalmente en las aplicaciones para las áreas financieras.
Curiosamente, no es la primera vez que Cartesis es comprada, ya lo fue en 1999, por PWC, pero evidentemente esta compra parece más lógica.

Evidentemente, aunque la compra parece una buena noticia, hay otros como Cognos que no dejarán pasar la oportunidad para sacar ventajas (y hacen bien). Esta es la nota que nos han pasado, relativa a la compra.

Los clientes que estén pensando apostar por Cartesis y Business Objects han de considerar los siguientes aspectos:
• Esta adquisición supone un total solapamiento de productos. Un “Arca de Noé” de tecnologías dispares que han de ser integradas incluyendo:
o 3 motores de consolidación.
o 3 motores de planificación.
o Múltiples motores de análisis y reporting…

• Cartesis es un proveedor centrado sobre todo en Francia y con escasa presencia fuera de Europa, tanto en término de clientes como de personal fijo.

• Cartesis sólo opera sobre arquitectura .Net, por lo que está limitado a plataformas MSFT.

• El foco de Business Objects se encuentra en la mediana empresa, mientras que el de Cartesis se concentra sobre las grandes corporaciones. ¿Dónde recalará la atención de la nueva entidad y hacia dónde caminará su roadmap de productos?

Mientras que los equipos de ventas de Business Objects y Cartesis tratarán de lidiar con la fase de desconcierto que cualquier proceso de integración de este calado supone –suprimiendo objetivos en materia de clientes, producto y tecnología/arquitectura durante los próximos trimestres-, Cognos proseguirá ejecutando su estrategia tomando partido de las oportunidades que surjan.

Hay temas discutibles de la nota de Cognos, como que BO tenga el foco en la mediana empresa. En España son las grandes multinacionales las que apuestan por BO.

Mas info:
Investor contacts
Press contacts
Frequently asked questions about this announcement
Presentation

En este apartado se reseñan las principales empresas del sector Business Intelligence, ordenadas de forma alfabética. En aquellas que tienen una web page en español, se referenciará a ésta.
Junto a cada empresa, esta el enlace que lleva a todos los comentarios publicados por Todo Bi que la hagan referencia, ordenados en orden cronológico inverso.
Finalmente se incluye un listado de empresas más pequeñas del sector, que podríamos denominar jugadores de nicho, que de forma individual no tienen excesivo volumen, pero que puede llegar a ser significativo si las consideramos en conjunto.

Ver todos los comentarios.
Productos:
(Desarrollo) Actuate Analytics Cube Designer, Actuate Information Object Designer, Actuate e.Report Designer Pro, Actuate e.Spreadsheet Designer
(Deployment) Actuate iServer, Actuate Information Objects, Page-level Security
(Usuario) Actuate Analytics, Actuate e.Analysis, Actuate e.Report Option, Actuate e.Spreadsheet Option, Actuate Query

Ver todos los comentarios.
Productos:
TM1

Ver todos los comentarios.
Productos:
(Reporting) Crystal Reports, Crystal Reports Explorer, Live Office.
(Query and Analysis) Web Intelligence, OLAP Intelligence, BusinessObjects
(Perfomance Management) Dashboard Manager, Performance Manager, Applications
(BI Platform) BusinessObjects Enterprise, Integration Kits, Analytic Engines
(Data Integration) Data Integrator, Rapid Marts

Ver todos los comentarios.
Productos:
Cartesis Magnitude, Cartesis Magnitude iAnalysis, Cartesis Magnitude Planning, Cartesis Intercompany Server

Ver todos los comentarios.
Productos:
(Planning and Consolidation) Cognos Planning, Cognos Controller, Cognos Finance
(Scorecarding) Cognos Metrics Manager
(Business Intelligence) Cognos ReportNet, Cognos PowerPlay, Cognos DecisionStream, Cognos NoticeCast, Cognos Performance Applications

Ver todos los comentarios.
Productos:
Corvu5 (CorStrategy , CorPlanning, CorRisk, CorIncentive, CorBusiness)

Plataforma Denodo
Virtual DataPort
ITPilot
Aracne

Ver todos los comentarios.
Productos:
ArcGIS, ArcWeb Services, More GIS Software

Ver todos los comentarios.
Productos:
Performance Management, Performance Management, Geac MPC

Ver todos los comentarios.
Productos:
Hummingbird BI (BI Query, BI Analyze, BI Web, BI Server)

Ver todos los comentarios.
Productos:
Hyperion Essbase, Hyperion Metrics Builder
(Query and Reporting) Hyperion Performance Suite, Hyperion Intelligence, Hyperion Analyzer, Hyperion Visual Explorer, Essbase Spreadsheet Services
(Enterprise Reporting) Hyperion SQR, Hyperion Reports
(Developer Tools) Hyperion Application Builder
(Core & Data Integration) Essbase Administration Services, Essbase Deployment Services, Essbase Integration Services, Hyperion Application Link, Hyperion Hub, Hyperion Master Data Management Server
(Scorecading & Dashboards) Hyperion Performance Scorecard, Hyperion Metrics Builder, Compliance Management Dashboard from Hyperion
(Modelling) Hyperion Strategic Finance, Hyperion Business Modeling
(Planning, Budgeting & Forecasting) Hyperion Planning, Hyperion Workforce Planning, Hyperion Pillar
(Consolidation & Reporting) Hyperion Financial Management , Hyperion Enterprise

Ver todos los comentarios.
Productos:
Intelligent Miner
(DB2 Data Warehouse Enterprise Edition) DB2 Alphablox, DB2 Universal Database Enterprise Server Edition, DB2 Universal Database Database Partitioning Feature, DB2 Cube Views, DB2 Office Connect Enterprise Web Edition, DB2 Warehouse Manager Standard Edition, WebSphere Information Integrator Standard Edition
DB2 OLAP Server: Spreadsheet Services, DB2 OLAP Server Miner, DB2 OLAP Server Analyzer, Security Migration Tool

Ver todos los comentarios.
Productos:
Informatica PowerCenter
Informatica PowerExchange

Ver todos los comentarios.
Productos:
WebFOCUS Suite
iWay Software

Ver todos los comentarios.
Productos:
Budgeting/Planning/Forecasting
Management Reporting

Ver todos los comentarios.
Productos:
(Location Intelligence) Locate, Visualize, Analyze, Plan.

Ver todos los comentarios.
Productos:
SQL Server Reporting Services
Analysis Services
Data Mining and Visualization

Ver todos los comentarios.
Productos:
MicroStrategy 7i Platform: Administrator, Architect, BI Developer Kit, Desktop, Intelligence Server, MDX Adapter, Narrowcast Server, Office, 7i OLAP Services, Report Services, SDK, Transactor, Web Universal
Analytic Modules: Customer Analysis, Financial Analysis, HR Analysis, Sales Force Analysis, Sales & Distr. Analysis, Web Traffic Analysis

Ver todos los comentarios.
Productos:
MIS Alea, MIS onVision, MIS Plain, MIS DeltaMiner, MIS ImportMaster, dynaSight

Ver todos los comentarios.
Productos:
The Noetix Enterprise Technology Suite: Noetix AnswerPoint , Noetix WebQuery, Noetix QueryServer, NoetixViews

Ver todos los comentarios.
Productos:
Oracle Business Intelligence 10g: Oracle Discoverer, Spreadsheet Add-in, Oracle Warehouse Builder, Oracle Business Intelligence Beans
(Corporate Performance Management): Activity-Based Management, DBI(Daily Business Intelligence), Financial Analyzer, Financial Consolidation Hub, Balanced Scorecard, Demand Planning, Performance Analyzer, Enterprise Planning and Budgeting, Sales Analyzer
Oracle Data Mining, Oracle Reports

Ver todos los comentarios.
Productos:
OutlookSoft Everest: Strategic planning , Budgeting, Forecasting, Statutory consolidation, Reporting & analysis, Predictive analytics , Scorecarding

Ver todos los comentarios.
Productos:
Panorama NovaView, Panorama Enterprise Reporter, Performance Measurement, Novaview Intelligente Server

Ver todos los comentarios.
Productos:
PilotWorks, PilotWorks for GovMax , PilotWeb, Pilot BusinessAnalyzer, Pilot HitList, Pilot Heritage Products

Ver todos los comentarios.
Productos:
Analytics Family: Web Standard, Professional, Business Reporter for Excel,