Tag Archives: Analysis Services

UPDATE: Building Analytical Models in Pentaho

15 Apr

As a quick update to my previous blog post on mechanisms to auto-generate Mondrian cubes using Pentaho, I’ve included a brief 10-minute video on how to modify and enhance the auto-generated models and then publish those back to the Pentaho BA server to share with the rest of your organization as a BI Solution here.

One more update to that post that I want to point out … I specifically called-out a command-line option to call the REST API that will pull out the Mondrian XML schema for your cube and stream it to a text file for advanced editing.

However, in the video I used a browser-based mechanism that works just the same, saving the XML file in my downloads folder. To do this, use a URI such as this: http://localhost:8080/pentaho/plugin/data-access/api/datasource/analysis/foodmart/download. In that URI, change “foodmart” to the name of the schema that you wish to export and edit.

cbailiss

Microsoft SQL/BI and other bits and pieces

TIME

Current & Breaking News | National & World Updates

Tech Ramblings

My Thoughts on Software

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Insight Extractor - Blog

Paras Doshi's Blog on Analytics, Data Science & Business Intelligence.

The SQL Herald

Databases et al...

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

Bill on BI

Info about Business Analytics and Pentaho

Big Data Analytics

Occasional observations from a vet of many database, Big Data and BI battles

Blog Home for MSSQLDUDE

The life of a data geek