A session parameter is a variable that IBM Cognos Framework Manager associates with a particular session. Examples include (current user name, current active language, current date and time, and others). Parameter maps are a method for substituting different values with different keys. A parameter map can be thought of as simple data “look-up table”. Each […]
Data + Intelligence
Following the Money Trail: Understanding the True Cost of Care
Healthcare leaders are challenged to understand the true costs associated with providing care. If you ask caregivers to determine their current workflow, they don’t really know where the patient and family go before or after each step of their care so the total care pathway is not in their purview. This is a well-known challenge […]
Data Warehouse Role in Big Data
Last year the Data Warehouse was on the endangered species list. A number of Hive solutions were being marketed as the Data Warehouse killers. However, this message has been muted this year and is evidenced by some developing trends. First, all of the mega-vendors have announced technologies to access data in Hadoop. Oracle and IBM […]
Yarn – The Big Data Accelerator
Yarn….. Yes, Hadoop may be changing everything, but when Yarn was released, the change pedal has been pushed aggressively to the floor. Putting the technical details aside, the bottom-line is that now multiple concurrent workloads can be executed and managed on Hadoop clusters. This “pluggable” service layer has separated the data processing and cluster resource […]
Risks Associated with Niche Big Data Vendors
One of the not so nice parts of the conference is seeing companies that have technology that have been superseded by the new releases of Hadoop, primarily Hive. One company, boasted about the fact it did not have to do full scans and could return SQL queries in seconds on large datasets. The look on […]
Creating Business Logic – in Cognos Framework Manager
One of the goals of the Cognos Framework Manager modeler is to build a model that makes report authoring easier. To accomplish that, you “build in” business logic” (a loosely defined term here) into your meta model. This business logic can be simple (like simply renaming or hiding a database table column) or quite complex […]
Secure Reflections from Day 1 at Hadoop Summit 2014
The Hadoop Summit has definitely been worth attending. Along with the SQL on Hadoop focus, security has also been center stage. Cloudera acquired encryption specialist Gazzang which follows an acquisition by HortonWorks of a security company, XA Secure. The traditional data warehousing players like IBM, Oracle, and Teradata all tout their robust security offerings for […]
Making Big Data Real
Update from the Hadoop Summit: Its only part way through day one and there is an un-mistakable theme: Interactive SQL on top of Hadoop is here, and in a big way. Stinger, Impala, and a number of other niche providers are not promising, but delivering on interactive SQL. Benchmarks, case studies of production clients, hands […]
Cognos Framework Manager, Transformer & Metric Designer
During a recent project of mine, I jumped “head first” into IBM Cognos Framework Manager. Yes, it is an awesome tool, but where exactly does it “fit” into the Cognos environment? Are there similar or alternate tools that can be used? I just had to have a quick look! The Cognos Components […]
Stages of MDM…
MDM is a popular topic and many organizations are in different stages of MDM journey. Many times clients (primarily IT) want to engage consultants who can recommend a MDM tool and start the implementation, bypassing the Planning / Pre-planning stages. Typically this leads to a MDM solution which is not thought through completely or end […]
IBM Cognos Framework Manager – Proven Practice
A proven practice for Framework Manager Meta Modeling is to divide your model into a series of layers, each layer having a specific purpose. (Originally IBM recommended the use of two layers (data and modeling), but later added a presentation layer, and (optionally) a separate dimensional layer). The layers should be: The top layer – […]
Hadoop Summit – The Future of Big Data
Next week is the Hadoop summit in San Jose. Perficient, along with almost every Partner, will be attending, sponsoring and/or exhibiting. Big Data, especially Hadoop-based solutions is the most dynamic area of IT. Hundreds of companies have products and solutions, all geared at increasing the value enterprises are able to extract from their information. Hope […]