How developers can solve the problem?
Pentaho BI developers need to write BI components using Mondrian OLAP and for this, they need to acquire MDX skills and knowledge. Here’s how the process flows-
How the solution approach should be made?
Developers can create an OLAP schema in easy way using Pentaho Schema Workbench. After building the schema and testing its performance, Pentaho developers can use it in data integration tool and develop end solution without any strict requirement of writing lengthy MDX.
Next they need to double click on the Mondrian input and make a DB connection-
After that, they need to browse the schema file that already has developed by them in schema workbench-
Then they just need to write basic MDX that will help in fetching required Columns-
Once the fetching of columns is done, developers can start formatting the data, putting business logic as per the requirement and complete the transformation. They need to change the catalogue path to the server path where they want to put the schema file.
And it is done. This is how Pentaho BI ETL developers can get rid of MDX using pentaho data integration approach as discussed above.
For further information, mail us at firstname.lastname@example.org