Boost Productivity with Enterprise Mobility

Both employees and customers are becoming increasingly mobile, and as they do so, their expectations regarding employers and product/service providers change. Businesses that manage, secure and support mobile devices and their apps, help employees become more agile and productive, and improve the service provided to customers. SAP mobile solutions can help to bring greater flexibility to work processes.

Movilidad empresarial

By putting the enterprise functionality normally found on the desktop into employees’ palms 24 hours a day 7 days a week, and supporting these with an ever-growing range of mobile enterprise apps – portable versions of back-office systems. So employees are working more effectively because they have the flexibility to manage, sell, service, market, transact, spend and work on the go.

The SAP range of over 200 mobile apps spans industry, line of business and analytics. They let employees perform tasks from anywhere, at anytime, transforming  downtime into uptime. Plane delays and waiting at the airport for example, can now be used as productive time, as the CEO can check recent performance updates at the airport lounge.  A store manager can answer customer inquiries immediately at the shop floor. An IT support employee can check the inventory for a piece that he needs to fix an equipment while on the customer´s site. You can enjoy greater efficiency and offer more seamless and impressive customer service are the result. To see for yourself, watch this case study from Kardinal Shwarzach Hospital Case Study to see how enterprise mobility has allowed them to provide excellent service to their patients.

You’ll find that 91% of the world’s leading brands have already opted for at least one SAP mobile app and SAP are leading the way in the enterprise mobility application market. SAP has mobility at the core of its innovation agenda, and is investing heavily to stay ahead of the competition, while at the same time fostering collaboration from its ecosystem partners.

Your company can start enjoying the benefits of mobility with the help of Clariba and our partner Exxova.

With Exxova´s MyBI Mobile you will be able to enjoy all your SAP BusinessObjects content from a mobile device, anytime, at any place, without time-consuming re-platforming. With a simple deployment process, and a familiar interface, format and content we reduce the learning curve and improve user adoption, so your employees can immediately start enjoying the benefits of mobility, improving productivity.

If you have any doubts or would like more information about SAP Mobile solutions or Exxova´s MyBI Mobile, leave a comment below. You can also find us at GITEX Technology Week 2012 in Dubai, at the SAP Stand.

SAP HANA Sandbox Implementation for In-house Tests

SAP HANA gets you moving at the speed of light

It is early days, but Clariba is at the forefront here once again with our initial SAP HANA installations. Indeed, SAP HANA is positioning properly in the starting grid of the BI stack for new deployments. That is very good news for all of us who are in the SAP World. However, even though everyone is (theoretically) aware of what SAP HANA is and its main benefits, not so many consultants know what the real options for having that in-house are and therefore they are not able to start making the first tests and getting their hands dirty with the tool. This is really important as we do not usually know when a real SAP HANA project may come up in our portfolio and we want to be ready for that. The main purpose of this blog entry is to shed some light on this topic.As mentioned earlier, surely almost all of our Clariba blog readers already have heard about SAP HANA. For all those who are still late let me pinpoint the primary concepts of it. Basically SAP HANA is a Database Server taking advantage of the SAP In-Memory Computing technology. This technology empowers dramatically the entire business – from shop floor to boardroom – by giving real-time business processes and applications instantaneous access to data, enabling real-time business applications and analytics system.

Back to the point, nowadays we have 2 real options for having our own SAP HANA environment up-and-running in our office. Depending on our budget and our requirements we can go for the cheapest option which is to apply for a virtual instance of HANA in the cloud or the most expensive one which is acquiring an official hardware appliance from one of the leading hardware partners of SAP.

The first and cheapest option is to go for a SAP HANA Application located virtually in the Cloud. This is an on-demand application environment and SAP offers a range of services with that. Nowadays SAP is offering SAP HANA Database environment in Amazon Elastic Compute Cloud (aka Amazon EC2). This is a complete fully working instance which can be accessible through SAP HANA Studio with really nice performance (depending on the requirements the instance may be created with more or less HW resources).

Under this context, before creating our SAP HANA instance there are two prerequisites which have to be met. First thing is to ensure you are a member of the Sap Community Network (SCN) - you can register here. This process is totally free of charge. Second is registering in Amazon Web Services (AWS). You will be requested to use your credit card because although registering is free, the charges will come up as soon as we create our SAP HANA instance. Amazon charges money from that point on. Even when the instance is stopped they will still be charging. Regarding the costs, they can be foreseen in advance using their own pricing calculator which can be found here. Just to give an idea, the smallest instance costs 50$/month with a 25h per week usage. We definitively recommend terminating the instance once the test is completed. The entire process to create the AWS instance can be found here.

The second option is absolutely the best but also the most expensive one. The idea is to purchase an actual brand new SAP HANA rack data base server. Currently SAP is in partnership with Intel, IBM, Fujitsu, Dell, Cisco and HP companies so you can contact directly with them and check their actual prices. They have a nice variety of models in order to meet all customers` needs. It is only with this sort of installation that you will get the best SAP HANA performance. Just to give you an idea of the remarkable speed in one of those machines, our consultants loaded more than 250 Million records in our sandbox system and they were achieving less than 5 seconds of average response time for any query we run against the database. Not bad at all, is it?

Finally, I would like to mention that you might find other options in forums for using a laptop with a fresh SAP HANA installation that involve altering installation code. This solution is not supported by SAP; therefore Clariba strongly discourages you to use it. The 2 options listed above will give you much better performance.

In conclusion, SAP HANA has become a reality in our BI world. As time goes by, our SAP customer datasets are exponentially growing and will eventually exceed the abilities of their commonly used tools. Transition towards SAP HANA will be a must for them, but also for us. Ensure you are ready for that by getting to know the tool. You know what options you have now, so go for it.

If you have any tips or questions, please leave a comment below.

Enterprise Mobility - Efficiency that Keeps Customers Near

The current explosion in enterprise mobility means that there’s never been a better opportunity for businesses to engage with their customers more effectively.

With the right mobile apps and connectivity, businesses can have access to the right information at the right time. This lets them answer customer queries efficiently, resolve issues satisfactorily or delight customers with well-targeted communications or offers.

When customers are happy, that’s when they stay put and spread the good word.

Through enterprise mobility, organisations can increase efficiency by eliminating paperwork, reducing travel time, managing tasks, calendars, alerts and more.

With 91% of the world’s leading brands having at least one SAP mobile app, they’re number one in the enterprise mobility application market. They also offer over 200 mobile apps – a range that spans industry, line of business and analytics. And there are 60 million users who trust the SAP Sybase Unwired Platform and Afaria Mobile Device Management solution.

Users include Asian Paints (India’s largest paint company). The company used Sybase Unwired Platform to make data and information about its 200 plus products easily available to its 1700 sales people in the field (See Asian Paints success story here). And what is a best example than SAP itself running their SAP mobility platform and realizing all benefits it can bring (see SAP runs SAP Mobile here).

With SAP mobile solutions, businesses can create an enterprise mobility strategy that aligns with their broader IT strategy and helps them engage effectively with their valued customers.

Clariba as a valued SAP Partner in Europe and the Middle East can help you define your mobility needs and help you to come up with a solution tailored to your requirements, helping you to make decisions faster, from anywhere at anytime.

We have also partnered with Exxova to provide our client with Exxova MyBI Mobile, an application that allows users to securely and instantly access enterprise-wide content held in their SAP BusinessObjects environment from mobile devices instantly, without re-designing anything.

If you wish to know more about how mobility can make you run faster and more effectively, contact Clariba. You can also learn more about enterprise mobility through the Top 10 Blogs / News Sites for Mobile.

SAP BI Services - Part 1

During the last couple of years I have been part of a team developing quite a few SAB BusinessObjects Dashboards (Xcelsius). In order to develop them, one of the key requirements is to have a consistent data source. Historically we have used all sorts of techniques that SAP BusinessObjects has made available, from QAAWS to Live Office. Each method has its pros and cons and there are situations on which using one over another makes sense.

On this article I will focus on the last method I have discovered: BI Services.

Comparing the three methods most frequently used, the following table shows their common characteristics as well as differences:

The main advantages I see on using the BI services method are:

• Using W as an aggregation engine
• Robust Query/Block organization
• Enterprise re-usability
• Filter capabilities at SAP BusinessObjects Dashboards (Xcelsius) connector level
• Additional Metadata
• Performance increase by using Webi servers engine/cache

Basic Requirements

Now let’s talk about how we can implement this solution in our Business environment.

As indicated above the BI Service is dependent on a WebI document. This means that it gets its data from a WebI report block. Also note that it is only possible to use this functionality if you have the WebI Rich Client application installed and you have enterprise permissions on the application. For our particular example we are using a client tools installation with version 3.1 SP 2.4.

Configuring the BI Service CMS Server

If you meet the two above requirements then let’s go ahead an open the WebI report that contains the block that will serve as the data source for our BI service.

Once the report is open you will see the on the top right of the WebI Rich client application.

We need to mark the check box to display the BI Services panel. The following panel will appear on the right side of the application:

 

Now we need to configure the CMS server we will be accessing by clicking on the manage servers button.

 

Click on Add and enter the details corresponding to your SAP BusinessObjects system. The data input parameters are: CMS name and dsws URL (which should be something like this http://yourserver:port/dsws)

 

Once the server has been configured, select it from the list and click on the refresh button so all BI Web Services available are displayed.

 

A list of BI Web Services will appear if any exist in the system. The BI Web Services can be organized in folders and each BI Web Services can have 1 or more blocks of data. We will talk more about these organization structures later on this blog.

 

You can see the 3 levels of organization in the screenshot below:

 

In order to consume from one of the BI Services available you will need to use the WSDL url which is one of the properties that appear when you select the block you wish to consume from the list.

Click on the three dots button on the right so you can see the BI Service definition.

 

The BI service description should look similar to the screenshot below.

NOTE: If you can’t see a page similar to the  one below, then the BI service URL is not accessible from the machine you are querying from and that might cause trouble later on. 

Click on the wsdl link.

 

Creating a new BI Service

Select the block from the WebI report and right click on it. A context menu will appear with its first value being “Publish block”. Select this option.

 

In some cases the below warning might appear. If the WebI report you are using as a source is not published in the SAP BusinessObjects enterprise repository then you can’t create a new service.

 

This is the initial screen for the BI service publishing wizard:

 

You need to, define a name for the block. The block is the smallest piece of organization for the BI service and it is equivalent to the table you have selected as a data source.

 

The block can be part of an existing BI service or you can create a new one. Each BI Service can contain one or many blocks. Also the BI Service can be organized in folders. All of these selections are done at the following screen:

For publishing a block on an existing BI service just select the BI service and press the Publish button.

To create a new service, select the folder and click on the Create button below. To create a new folder click on the New Folder button on the upper right side.

 

So now that your BI service has been created it is time to start consuming it with SAP BusinessObjects Dashboards (Xcelsius).

In the next part of this blog we will talk about SAP BusinessObjects Dashboards (Xcelsius) connectivity to BI services and what we can do to manipulate our new data source.

If you have any questions or tips, leave a comment below.

Implementación de SAP Rapid Marts Xi 3.2: lecciones aprendidas

I would like to share with you two lessons learned about the implementation of SAP Rapid Marts XI 3.2, version for SAP Solutions. In our particular case the customer didn´t allow us make any modification to the out-of-the-box solution, and this must be taken into account when reading the article.

Lesson 1: Don´t be scared by the TSV_TNEW_PAGE_ALLOC_FAILED Error

If part of your implementation of SAP Rapid Marts includes General Ledger, Inventory or Cost Center you will probably have to perform a massive extraction of information from SAP ERP during your initial load. Most probably your customer will have been working with their ERP for quite some time, and you are likely to face the following error:

At this point, you will possibly start looking at configuration of SAP Data Services or you will start trying to tune the SAP ERP configuration in order to achieve the end-to-end execution. In general terms, you will have a headache trying to solve this problem and most likely none of the configurations will work…

The truth is out there… After many hours trying to tune configurations you will understand that the only solution is to modify the ABAP extraction itself… BAD NEWS: your customer does not allow you to do this because this means altering the out-of-the-box product. GOOD NEWS: the guys from SAP Support already tackled this problem and they published the following SAP Note 1446203 - Multiple Query Transforms in ABAP Data Flows, there they clearly explain that your conclusion is correct: this error is a memory allocation error on the SAP solutions server, it indicates that the SAP solutions server has run out of memory for the SAP Data Services generated ABAP program.

You will find an attachment in the SAP Note with some ATLs where they basically tune all the ABAP extractions of the SAP Rapid Marts XI 3.2 package, after applying this ATL to the out-of-the-box solution your extraction will work like a charm.

Lesson 2: How to improve performance of Delta Load for FINANCIAL_DOCUMENT_FACT

This lesson is useful to you if SAP Rapid Mart XI 3.2 General Ledger is part of your implementation.

After finishing the initial load of this SAP Rapid Mart you will start running the delta load. At this moment you may be shocked by the bad performance. Depending of your requirement this delta load can be something simply not affordable.

In basic terms this delta load tries to rebuild all the information of the current fiscal year. We ran an extensive performance analysis and the conclusion was clear: the logic for the processing of delta loads to the table FINANCIAL_DOCUMENT_FACT was causing serious performance issues to our environment.

Only one possible solution was in sight: introduce a new logic for the processing of delta loads to the table FINANCIAL_DOCUMENT_FACT. Breathe deeply because indeed this means to re-invent the SAP solution and this can clearly jeopardize your project.

We decided to come back with this topic to the SAP Support team looking for a “magical solution” and they got it! One more time there was a solution on the SAP Note 1557975 - Poor Performance of Delta Load for FINANCIAL_DOCUMENT_FACT.

The SAP note clearly defines a scenario like ours and provides an ATL file to tune the delta load for the FINANCIAL_DOCUMENT_FACT. Again, after applying the solution provided the delta load worked perfectly.

As conclusion, I would like to mention that after many years working with different support teams I´m impressed with the capability and escalation levels in the SAP Support team. Like many other support teams you may have to push to get a solution but I don´t know many other support teams that can escalate your request up to have a discussion with the director of development of a product or provide you with solutions that fit perfectly to your environments.

That´s all folks! I hope these two tips help you to speed up your SAP Rapid Marts implementations. If you have any doubts please leave a comment below.

Sugerencias para instalar SAP BusinessObjects BI4 en español

Se dice que la instalación en español de SAP BusinessObjects BI4 se bloquea frecuentemente, e incluso cuando no funciona, algo todavía está mal en el lado del servidor, por lo que la consola de administración de la instalación de SAP BusinessObjects no funciona como debería y ciertas fórmulas utilizadas en el lado frontal mal funcionamiento. En este artículo se explican algunos trucos que se pueden aplicar al instalar SAP BusinessObjects en español para que los clientes puedan migrar con éxito al nuevo SAP BO BI4. Configuración de seguridad de carpetas

Al configurar la seguridad de una carpeta en la consola de administración de SAP BusinessObjects, aparece un problema. Esto se puede reproducir fácilmente instalando el software en español, procediendo a entrar en CMC y empezar a configurar la seguridad. El error siguiente se puede ver al ingresar en carpetas Seguridad de carpeta de nivel superior:

"Se produjo un error de servidor durante la confirmación por lotes de seguridad: Error de solicitud 0 de tipo 44 con error de servidor: Error de Administrador de complementos: No se pudo localizar el complemento solicitado CrystalEnterprise.ScopeBatch en el servidor (FWB 00006)"

No hay otra solución en lugar de cambiar la configuración regional del servidor de español (España) a inglés (Reino Unido), entonces este problema se resuelve.

Uso de la fórmula UserResponse

Se produce un problema en WebIntelligence cuando la configuración regional preferida es el español y los usuarios actualizan los informes. Avisos: Un indicador numérico se interpreta como un texto con un formato científico incorrecto cuando se utiliza la fórmula = UserResponse ().

El problema se puede reproducir tomando un objeto del universo oficial de SAP "STS Sudeste Demo", recuperando un objeto con un prompt y aplicando la fórmula UserResponse () como se indica a continuación

En el ejemplo indicado anteriormente la fórmula UserResponse () debe ser evaluada como "201010" en lugar de "2.0101 e5". Esto puede causar problemas graves, ya que es un cambio vs. Versiones de software anteriores, ya que esto podría incluirse en muchas fórmulas y filtros, y podría causar un proyecto de migración con los informes que utilizan esta fórmula de uso frecuente para ser ampliado dramáticamente.

Una solución para esto es, por el momento, mantener el Entorno de visualización preferido en inglés para cada usuario que actualiza la información.

Así, resumiendo, los consejos propuestos para una instalación exitosa en español son:

• Mantenga su servidor con Configuración regional del servidor en inglés (Reino Unido)
• Configure los usuarios de BI LaunchPad para que mantengan la configuración regional preferida en inglés
• Mantenga el valor de la propiedad Locale del producto de BI LaunchPad en español (España)

Como resultado, los usuarios visualizarán todo el front-end en español sin errores.

Esta solución ha sido probada en el último 4.0 SP4 que incluye FeaturePack 3.

El beneficio de estas soluciones es proporcionar al mercado de clientes en español la posibilidad de comenzar a migrar a la nueva plataforma SAP BI4 con éxito y disfrutar del producto en español sin errores. Espero que esto ayude. Si desea dejar su comentario u opinión, por favor no dude en hacerlo a continuación.

BI y Social Media - Una combinación poderosa (Parte 2: Facebook)

To continue with my Social Media series  (read the previous blog here BI and Social Media – A Powerful Combination Part 1: Google Analytics), today I would like to talk about the biggest social network of them all: Facebook. In this blog post, I will explain different alternatives I have recently researched to extract and use information from Facebook to perform social media analytics with SAP BusinessObjects’ report and dashboard tools. In terms of the amount of useful information we can extract to perform analytics, I personally think that Twitter can be as good or even better than Facebook, however, it has around 400 million less users. Facebook still stands as the social network with the most users around the world - 901million at this moment - making it a mandatory reference in terms of social media analytics.

Facebook

Antes de comenzar a hablar sobre detalles técnicos, lo primero que debe entender es que Facebook está fuertemente enfocado en la experiencia del usuario, las aplicaciones de entretenimiento, el intercambio de contenido, entre otros. Por lo tanto, la actividad del usuario es más dispersa y variable en comparación con la moda ordenada en tiempo real que Twitter nos brinda, lo cual es muy útil al construir tendencias y análisis cronológicos. Por lo tanto, asegúrese de lo que está buscando, manténgase enfocado en sus indicadores clave y asegúrese de buscar algo que sea significativo y medible.

API de Facebook relevantes para fines analíticos

The APIs (Application Programming Interface) that Facebook provides are largely directed at the development of applications for social networking and user entertainment. However, there are several APIs that can provide relevant information to establish Key Indicators that can later be used to run reports. As Facebook’s developer page1 states: “ We feel the best API solutions will be holistic cross API solutions.” Among the API’s that you will find most useful (labeled by Facebook as Marketing APIs), I can highlight the Graph API,  the Pages API, the Ads API and the Insights API. In any case, I encourage you to take a look at Facebook pages and guides for developers, it will be worth your time:

• Programa de desarrollador de marketing: http://developers.facebook.com/preferredmarketingdevelopers/why_build/

• Marketing Developer Resources (with mentions of the APIs above): http://developers.facebook.com/preferredmarketingdevelopers/resources/

• Soluciones de marketing de Facebook:   http://www.facebook.com/marketing

API de Facebook

Aplicaciones de terceros para extraer datos de Facebook

Solo encontré algunas aplicaciones de terceros para extraer datos de la API de Facebook que eran lo suficientemente completas como para garantizar un acceso confiable a los datos. A continuación se presentan algunas alternativas diseñadas para este requisito:

GA Data Grabber: This application has a module for the Facebook APIs, which costs 500USD a year. As in the case of Google Analytics, it has key benefits such as ease-of-use and flexibility to make queries. It may also be integrated with some tools from SAP BusinessObjects such as WebIntelligence, Data Integrator or Xcelsius dashboards through LiveOffice.2

Custom Application Development: It is the most popular option, as I already mentioned in my previous post about Google Analytics. The Facebook APIs admit access from common programming languages, allowing to record the results of the queries in text files that can be loaded into a database or incorporated directly into various tools of SAP BusinessObjects.

Implementation of a Web Spider: If the information requirements are more focused on the user’s interactions with your client’s Facebook webpage or any of its related Facebook applications, this method may provide complementary information to that which is available in the APIs. The information obtained by the web spider can be stored in files or database for further integration with SAP BusinessObjects tools. Typically, web spiders are developed in a common programming language, although there are some cases where you can buy an application developed by third parties, as the case of Mozenda.3

Final Thought

Como mencioné en mi publicación anterior, en el área de las redes sociales aparecen nuevas aplicaciones y tendencias a un ritmo agitado, se espera que ocurran muchos cambios, por lo que es solo cuestión de tiempo hasta que tengamos más y mejores opciones disponible. Le animo a que tenga curiosidad por el análisis de las redes sociales y sus redes más populares, porque en este momento esta es una mina de oro de información en crecimiento.

Si tiene alguna pregunta o algo que agregar para ayudar a mejorar esta publicación, no dude en dejar sus comentarios. También puede encontrar interesante la publicación anterior que escribí sobre SAP BusinessObjects y Google Analytics: http://juancaruiz.com/clariba/bi-and-social-media-a-powerful-combination-part-1-google-analytics/

Referencias

1 Programa de desarrollador de marketing: http://developers.facebook.com/preferredmarketingdevelopers/why_build/

2 GA Data Grabber: http://www.gadatagrabbertool.com/

3 Mozenda: http://www.mozenda.com/

Índices B-tree vs Bitmap: Consecuencias de la Indexación - Estrategia de Indexación para su Parte de Oracle Data Warehouse 2

En mi blog anterior B-árbol vs índices de mapa de bits - Estrategia de indexación para su Oracle Data Warehouse Respondí a dos preguntas relacionadas con la indización: ¿Qué tipo de índices podemos utilizar y en qué tablas / campos debemos usarlos. Como prometí al final de mi blog, ahora es el momento de responder a la tercera pregunta: ¿cuáles son las consecuencias de la indexación en términos de tiempo (tiempo de consulta, tiempo de creación de índice) y almacenamiento?

Consecuencias en términos de tiempo y almacenamiento

Para abordar este tema utilizaré una base de datos de prueba con un esquema en estrella muy simplificado: 1 tabla de hechos de los saldos de las cuentas de Libro mayor y 4 dimensiones - la fecha, la cuenta, la moneda y la rama banco).

Esquema simplificado de la estrella

Para dar una idea del tamaño de la tabla, Fact_General_Ledger tiene 4,5 millones de filas, Dim_Date 14 000, Dim_Account 3 000, Dim_Branch y Dim_Currency menos de 200.

Supongamos aquí que los usuarios pueden consultar los datos con filtro en la fecha, código de sucursal, código de moneda, código de cuenta y los niveles 3 de la jerarquía de balance (DIM_ACCOUNT.LVLx_BS). Suponemos que las descripciones no se utilizan en los filtros, sino sólo en los resultados.

Aquí está la consulta que usaremos como referencia:

Seleccionar

d.date_date,

a.account_code,

b.branch_code,

c.currency_code,

f.balance_num

de fact_general_ledger f

unirse a dim_account a en f.account_key = a.account_key

join dim_date d en f.date_key = d.date_key

unirse a dim_branch b en f.branch_key = b.branch_key

unirse a dim_currency c en f.currency_key = c.currency_key

Dónde

A.lvl3_bs = 'Depósitos con bancos' y

D.date_date = to_date ('16/01/2012', 'DD / MM / YYYY') y

b.branch_code = 1 y

C.currency_code = 'QAR' - Vivo en Qatar ;-)

Entonces, ¿cuáles son los resultados en términos de tiempo y almacenamiento?

Comparación de tiempo y almacenamiento

Algunas de las conclusiones que podemos extraer de esta tabla son:

• Using indexes pays off: queries are really faster (about 100 times), whatever the chosen index type is.

• En cuanto al tiempo de consulta, el tipo de índice no parece importar realmente para las tablas que no son tan grandes. Probablemente cambiaría para una tabla de hechos con 10 mil millones de filas. No obstante, parece existir una ventaja para los índices de mapa de bits y, especialmente, para los índices de combinación de mapa de bits (consulte la columna de costes del plan de explicación).

• El almacenamiento es claramente a favor de los índices de combinación de mapa de bits y mapa de bits

• El tiempo de construcción del índice es claramente a favor de b-tree. No he probado el tiempo de actualización del índice, pero la teoría dice que es mucho más rápido para los índices b-tree también.

Ok, estoy convencido de usar índices. ¿Cómo puedo crear / mantener una?

La sintaxis para crear índices b-tree y bitmap es similar:

Crear índice de mapa de bits Index_Name ON Nombre de tabla (FieldName)

En el caso de los índices b-tree, simplemente quite la palabra "Bitmap" de la consulta anterior.

La sintaxis para los índices de combinación de mapa de bits es más larga pero sigue siendo fácil de entender:

Crear índice de mapa de bits ACCOUNT_CODE_BJ

on fact_general_ledger (dim_account.account_code)

de fact_general_ledger, dim_account

donde fact_general_ledger.account_key = dim_account.account_key

Tenga en cuenta que durante su ETL, es mejor dejar / deshabilitar sus índices de combinación de mapa de bits / mapa de bits y volver a crearlos / reconstruirlos después, en lugar de actualizarlos. Se supone que es más rápido (sin embargo no he hecho ninguna prueba).

La diferencia entre drop / re-create y disable / rebuild es que cuando se deshabilita un índice, se mantiene la definición. Así que necesitas una sola línea para reconstruirla en lugar de muchas líneas para la creación completa. Sin embargo, los tiempos de generación del índice serán similares.

Para eliminar un índice: "drop index INDEX_NAME"

Para deshabilitar un índice: "alter index INDEX_NAME inutilizable"

Para reconstruir un índice: "alter index INDEX_NAME rebuild"

Conclusión

La conclusión es clara: ¡UTILICE LOS ÍNDICES! Cuando se usan correctamente, pueden aumentar realmente los tiempos de respuesta a las consultas. Piense en usarlos en su ETL también: hacer búsquedas puede ser mucho más rápido con los índices.

Si desea ir más lejos, sólo puedo recomendarle que lea la Guía de almacenamiento de datos de Oracle. Para conseguirlo, sólo busque en Internet (y no olvide especificar la versión de su base de datos - 10.2, 11.1, 11.2, etc.). Es un documento bastante interesante y completo.

Clariba está en movimiento!

Clariba está en movimiento

¡Clariba se mudó a una nueva oficina en Dubai!

Clariba es un proveedor líder de soluciones y servicios de Business Intelligence (BI) y gestión de datos en MENA. Con un negocio próspero en la región y una fuerte demanda de proyectos de BI, Clariba se ha desarrollado rápidamente en los últimos 3 años y, como resultado, ha superado sus actuales instalaciones en Dubai.

La compañía necesitaba una oficina más espaciosa para acomodar a su creciente equipo de expertos en inteligencia de negocios y también un espacio más cómodo para albergar mejor a sus valiosos clientes y prospectos durante sus visitas. Marc Haberland, Director Gerente de Clariba, dijo: "Después de nuestro continuo crecimiento en los EAU, había una necesidad obvia de un espacio de oficina más ingenioso para mejorar las condiciones de trabajo de nuestro personal y proporcionar un espacio de reunión más adecuado para los clientes".

Torre Sidra

Por lo tanto, para continuar brindando el mejor servicio a sus clientes, Clariba se ha mudado a un nuevo edificio estratégicamente ubicado en el corazón de la tecnología en Dubai - Media City. A partir de junio 22, Clariba se encuentra en sus nuevas oficinas en la Unidad 905, Sidra Tower, PO Box 75645 - Dubai Media City, Dubai, EAU.

“Es emocionante mudarse a Media City y a una oficina moderna que permita nuestro crecimiento futuro. Este movimiento refleja la confianza que tenemos en nuestra capacidad para continuar expandiéndonos, y esto solo es posible debido a las soluciones, servicios y soporte de BI de alta calidad que Clariba brinda a sus clientes ", agrega Marc.