Kognitio Pablo – OLAP without an actual cube – MDX query language access from Excel Pivot TablesFebruary 10, 2011 by Amyn Rajan in Business Intelligence Data Warehouses Excel Pivot Tables MDX Multi-Dimensional Data Connectivity OLAP OLE DB for OLAP XML for Analysis XMLA
I was at the Gartner BI Summit in London last week and Kognitio had a session on their new Pablo product. Basically, Pablo allows you to define meta data such that your data in WX2 is presented to Microsoft Excel Pivot Tables as a cube. So, you really have a ROLAP implementation on WX2. These ROLAP models are accessed using OLE DB for OLAP and the MDX query language. There is a session by Robin Bloor of the Bloor Group and John Coppins of Kognitio where they will present this solution and answer questions. If you are interested in the data warehouse space and how you can build ROLAP models, I strongly suggest you watch this webinar. You can register here: https://bloorgroup.webex.com/mw0306lc/mywebex/default.do;jsessionid=KGQNNJDNqyPqp0CQxnkybs8NnTQ4ypxf1pHTpZ9v0sg6ns19PDJ3!1821339609?nomenu=true&siteurl=bloorgroup&service=6&main_url=https%3A%2F%2Fbloorgroup.webex.com%2Fec0605lc%2Feventcenter%2Fevent%2FeventAction.do%3FtheAction%3Ddetail%26confViewID%3D279381906%26siteurl%3Dbloorgroup%26%26%26. The details of the session are:
Several new approaches challenge the long-standing process of delivering BI solutions via OLAP on top of Data Warehouses. The most recently unveiled model focuses on delivering 'train-of-thought' analytics to business users in their favorite environment: Microsoft Excel. Under the covers, an in-memory database combines with Massive Parallel Processing (MPP) to achieve a huge reduction in latency, inaccuracy and scalability issues.
Register for this episode of Briefing Room to learn from veteran Analyst Robin Bloor, who will explain how and why the architecture of information management is changing, in part due to the cloud. He'll then offer insights on what you can do to become more agile and responsive. Bloor will be briefed by John Coppins of Kognitio, who will tout his company’s latest offering Pablo, which creates a virtual marshaling area for metadata and super-charged “cubes” which essentially circumvent many of the issues that companies encounter with cube maintenance and proliferation.
Each episode of The Briefing Room includes a 5-min topical intro by the Host, Eric Kavanagh, a 15-min detailed technical presentation by a vendor, a brief response by a well-known analyst, then a live, unscripted analyst briefing. The show finishes with a 15-min Q&A with the audience and anyone who tweets questions with a hash tag of #briefr."