Posts Tagged ‘Data’

Out of the mathematical and statistics language and tools such as SAS, SPSS, Matlab, etc. R language is a pretty good tool which provides the environment and essential packages for statistical computing and graphics. It is free and it offers an open environment and the means to allow users to develop custom package. In addition to […]

In his July 10th email to employees, Microsoft CEO Satya Nadella mentions the word “data” no fewer than 15 times.   This simple fact serves to highlight how dealing with data is a foundational part of Microsoft’s future strategy.   When he describes a “mobile-first and cloud-first world”, Mr. Nadella is describing a world where data is ubiquitous in “the […]

  Essbase API Overview  Oracle Essbase Provides a solution of EPM (Enterprise Performance Management) that helps end-user analysts across the enterprise in various departments Such as finance, accounting, Sales and marketing to solve complex calculations and perform ad-hoc data query operations . We operate Essbase in a client server environment from custom applications written in […]

Because of the popularity of mobile devices and other reasons, nowadays more and more companies have a large data store than before. The unit of data in big Internet companies like Google or Alibaba is PB or even EB.  How to store and fetch big data efficiently becomes a very interesting topic. There are three […]

Why do we Purge Cache Automatically? The cache option in OBIEE 11g can help us to improve query performance greatly. But sometimes when we refresh the data mapping or reload the transaction data, the result over report will be out of date and not refreshed immediately due to cache. The best way is that we […]

I remember that I heard the cloud concept about ten years ago while now the real cloud age is here. The cloud deployment and practice in CRM area might be the pioneer comparing with others. It is glad that we are seeing more and more BI vendors are boosting their cloud strategy and product development […]

Solution Writing column names in the first row of a flat file target using PowerCenter (version 8.1 or update) session, do the following: Edit the session with the flat file target in Workflow Manager. Select the Mapping tab. Select the target file. Scroll to the Header Options attribute. Select Output Field Names from the attribute list. NOTES: By default, this option […]

Recently we experienced the Data Warehouse Admin Console (DAC) notification configuration issue in the Oracle BI project and finally resolved that. It would require the configuration in two parts. 1. Configure Email Recipients in the DAC Client Follow this procedure to configure email recipients in the DAC Client. 1). In the Setup view, click the […]

The Heartbleed bug is causing some real heart palpitations in the healthcare community (sorry for the pun), regardless of whether your organization is a health plan, a health provider or both. That’s according to Phil Lerner, chief information security officer at Beth Israel Deaconess Medical Center, who, on a scale from 1 to 10, ranks […]

This month, we completed an interview with our healthcare analytics strategist, Juliette Silver. We wanted to understand how enterprise information management strategies can specifically optimize business performance, reduce costs, mitigate risks and improve quality of care. From the interview, I take away at least 10 major benefits to establishing and leveraging an enterprise information management […]

Social TV is becoming the new norm of experiencing your favorite television shows. If you’ve noticed all those Tweets pop up on the screen during your favorite programs, you’re already well aware of the growing trend of what is now known as “Social TV.” During my first stint at South by Southwest (SXSW), many of […]

SQL Server 2012 introduces new analytical functions LEAD () and LAG (). These functions accesses data from subsequent row (for lead) and previous row (for lag) in the same result set without the use of a self-join. The syntax for the Lead and Lag functions is: Note that: −        “Partition by clause” is optional, “order […]