On our business intelligence team, we use a document to display what we call the “cross walk” for Source Tables, Mart Tables and Reporting Layer objects. And from this document, we can know the ETL mapping between source columns and mart columns, and we also can know the ETL mapping between these mart columns and […]
Posts Tagged ‘analytics’
Back to the Basics: What is Big Data?
This video published by SAP provides a concise description of Big Data. Timo Elliott (SAP Evangelist) and Adrian Simpson (CTO, SAP UK& Ireland) describe the 4 major challenges that big data is comprised of: Volume – Amount of data Velocity – Frequency of change in data Variety – Both structured and unstructured data Validity – Quality of the data […]
Dresner claims ‘Business Intelligence Renaissance’
Dresner Advisory Services has recently completed and published its 3rd annual ‘Wisdom of Crowds Business Intelligence Market Study.’ The report itself highlights the shift towards emergent consumer-oriented BI. As part of the analysis vendors within the bi reporting and analytics space are given scores based on 33 criteria and 7 categories as well as an overall average score. They also broke vendors […]
Roambi Disrupts Mobile BI with an iFocus
Roambi was clearly built to bring some of the cool factor of Apple products to BI…or maybe it was the other way around. The downloadable Analytics app for Apple iPad and iPhone may be solely focused on these two products for delivery, but is also able to connect to a variety of data sources, as […]
Use Local Variable to Pass Value in Rows
Sometimes we need to calculate one column with cumulative value based on other columns value and value from previous row, here is one case Column BUSINESS_DAY_OF_MONTH should have a cumulative value of business day count in one month. You might have some sql script to get this value, but here is a simple way in […]
Insert a long XML string to DB table with PL/SQL
You want to insert an XML payload record in DB table, but the content for that column is too long and you can’t insert it into table. The traditional SQL: “insert into table (field1) values (‘yourxml’)” will fail because of the long characters. How do you handle this situation? Scenario: client requires to insert a XSLT/XQuery […]
SAP Shifting Focus from Product Integration to Innovation
SAP is taking a new approach in the BI space by focusing on innovation as was presented at the recent SAPPHIRE NOW event in Orlando, FL. One of the most promising products, Visual Intelligence, is a desktop tool used to visually explore and manipulate date. Visual Intelligence is a compliment to their recently launched HANA platform […]
Informatica:Use a Microsoft Excel worksheet as a source
Step 1. Create and configure the Excel worksheet. In Microsoft Excel do the following: Select the required rows to be read into PowerCenter. Select Insert > Name > Define (Formulas > Name Manager in Excel 2007). Enter a name for the range. Click OK. Save the worksheet.
Birst and TriCore Partner
TriCore Solutions, LLC and Birst Inc have combined forces to offer a more complete cloud-based BI solution. Birst, founded in 2004, has been make great strides as a disrupter in the Business Intelligence space. The San Francisco- based starup also just completed series D financing to start the month by raising a cool $26 million. This puts Birst’s […]
Difference of sub-query in different databases
SQL development varies from case to case when it use different database such as Oracle, DB2 and MSSQL. Today we’d like to take “sub-query” as an example to explain the differences. For example, we want to calculate rate, Oracle support two ways:
Exposed two interface for Oracle BPEL application
Sometimes, OSB call BPEL application need to use SOA-direct protocol. But while you use this protocol, you can’t debug and test your BPEL application in the enterprise manager (EM), because direct binding interface disabled the “Test” button in the EM. Can we use SOA-direct protocol for OSB call to BPEL and also debug the BPEL […]
Using Grouping and Cursor to improve performance
Summary: In BI testing, we create views for large amounts of data, but performance issues can occur when we need to pivot a column and make it a string. To improve the performance, we divide this column into two groups first, one is for the unique value that doesn’t need any combination, and another one […]