Posts Tagged ‘Data’

We can use TableMapReduceUtil.initTableReducerJob and put the method in Hbase API, but we can also use doBulkLoad to load data to Hbase. In a previous post, I introduced using importtsv and completebulkload hbase shell command to load data to Hbase. In this post, I will introduce how to implement it by JAVA language. Advantage: Put method in […]

The SEC’s Office of Compliance Inspections and Examinations (OCIE) is responsible for protecting retail investors and assessing market-wide risks, but now is shifting its attention also toward figuring out how to leverage data analytics to identify potential for illegal trading activities, conflicts of interest or other misconduct, according to a recent article by ThinkAdvisor, Compliance Data Analytics: Do […]

It is no secret that Big Data is involved daily with social engagement, advertising, mobile applications, and business intelligence in today’s enterprise. As much data that an enterprise would like to receive from customers, even more data needs to be ingested from the cloud, commerce sites, transactions, social feeds, geo-locations and on. In between the […]

Here is an example to transfer data between TM1 Instances byTM1RunTI configuration file and some tips for trouble shooting. TM1RunTI is a command line interface tool that can initiate a TM1 TurboIntegrator (TI) process from within any application capable of issuing operating system commands. That means it can be called cross TM1 Instance, especially when […]

Introduction SSAS 2012 provides three different approaches for creating a business intelligence semantic model: tabular, multidimensional, and PowerPivot. Tabular solutions use relational modeling constructs such as tables and relationships for modeling data, and the xVelocity in-memory analytics engine for storing and calculating data. Multidimensional and data mining solutions use OLAP modeling constructs (cubes and dimensions) […]

We examine SCD Type I and Type II here. Overview of Kettle transformation Here is overview of transformation. It will be loaded from excel source file and loaded into database.

In this blog we will talk about how to implement various types of slowly changing dimensions (SCDs) with Kettle in details. And I will introduce the examination of SCD Type I and Type II in Part2. Types of Slowly Changing Dimensions Following Kimball, we distinguish two main types of slowly changing dimensions: Type I, Type […]

Almost every type of ETL tool has its extract and load strategy with its configurations. In general the user should be concentrated in full load (aka initial load) and incremental load options in whatever tools to utilize. Oracle BI Apps component provides straightforward options to let developer configure appropriate approaches to achieve data load in […]

Basing on my last blog (IBM Cognos TM1 updating metadata in TI submit time explore), we will explore the influence of updating metadata by sub TI here. Please see below example as scenario 1:

Recently, when we update the dimension elements, we find the value of the cube which includes the dimension are missing. So we need to explore which time moment cause this. Please see below experiment:

In the past couple of years, we have delivered several projects successfully which were based on MVC + KnockoutJS, they all applied the same structure or pattern, so I was thinking to get them out from several projects which we might reuse in the future projects, here is what I’d like to share, you may […]

When you intend to create report utilizing SAP Crystal Reports for Visual Studio 2012, generally speaking, all the report content can be bound with some kinds of data source (like DataSet). However, in some particular scenarios, some report content is not bound to any data source, and you have to change them dynamically, such as […]