How to Mondrian Cube which is having dynamic schema name

Hi,
We are using Pentaho Enterprise 8.1 and we have multiple clients who get their data in Pentaho Analyzer. Each of the client is having different database with unique schema name. To get the data we are using Dynamic Schema processor so that each client can see only their own data.
 
How we can achieve this using Flexmonster and also in the initial phase I am not able to configure our own Mondrian Schema in Flexmonster. Please help us in this as well

1 answer

Public
Dmytro Zvazhii Flexmonster April 11, 2019

Hello Mohit,
Thank you for your question. In case you want to use dynamic schema you need to work with Flexmonster through Flexmonster Accelerator. Also, you need to integrate Flexmonster Accelerator into your project to manage the schema with your code in the run time. To achieve it just override a few methods to use custom DynamicSchemaProcessor. That will allow you working with the dynamic schema. Please find the sample for integrating Flexmonster Accelerator attached.
Let us know in case of any other question.
Regards,
Dmytro

Please login or Register to Submit Answer