Semantic layer technology reduces value of BI investments
A semantic layer will be able to create technically sophisticated SQL and in many instances may need to generate multiple SQL statements in order to return the correct results (chasm trap/fan trap). The semantic layer must understand how to deal with database loops, complex objects, complex sets (union, intersect, minus), aggregate table navigation and shortcut joins.
This results into huge investments both in time to market and maintenance. Technical expertise and costly resources are deployed to build this semantic layer. Traditional BI semantic layer takes time to build and slows down deployment of a BI solution. It must be kept in sync with any database changes that occur.
Hence use of semantic layer is being experts few in any organization and adoption becomes a challenge. As a result of this intensive workload, user requests for new queries and reports can accumulate in a long queue, leading to user frustration and reducing the value the organization gets from its BI investments.
With 1KEY BI which is fully self-service consumed BI, which is all the rage today. It would serve over 80% of most BI users who are the critical masses. The self-service consumed BI requirements of “casual users” are easily fulfilled using parameterized reports or interactive dashboards which do not require semantic layers to build or deploy.
The other point was that you can use database constructs such as database views or stored procedures to accomplish much of what the semantic layer provides with 1KEY BI with quick time to market and easily deployable with zero or no special training.
The final disadvantage to the semantic layer or at least the semantic layer of traditional BI tool was that it could only connect to one database at a time. In other words, if you had data in MS SQL Server and Oracle, you needed a semantic layer for both whereas in 1KEY with 1KEY View module it can couple queries from two different servers-databases and provide in single presentation layer reports with simple SQL statements.
After seeing 1KEY create a data source, add a hierarchy on the fly, rename several dimensions, add comments to those reports to clearly identify what was presented, drag a measure field to become a dimension field, hide a few fields, and then publish the data source with the metadata changes so it could be shared across his team, the customers have reacted with wow and called it “powerful with 1KEY”. Information delivery is the most successful aspect of 1KEY which would cover Reporting, Dashboards, Ad Hoc Query, Microsoft Office type UI and Outlook Integration where it covers requirements of mass user base of any enterprise. One of the major advantages of using 1KEY BI is it does not require database which saves money and very well skilled human resource.
With no data warehouse required 1KEY can be implemented in a couple of weeks saving a lot of TIME, MONEY AND RESOURCES. This technology overcomes the efforts and time required to build data warehouse, normalization, schema writing, creation of cubes and building semantic layer.  With 1KEY BI it’s about providing data access and analysis to individuals and groups, and letting them get what they need more rapidly and precisely than ever before.
By Sanjay Mehta, from:Â http://blog.maia-intelligence.com/2012/01/02/semantic-layer-technology-reduces-value-of-bi-investments/