Analysis | Forum profile

Well... You do understand the difference between Rolap and molap? In this case mondrian uses Rolap, so Mondrian only needs a schema file (which you can build with the workbench). In this schema file all information needed to connect to the database is provided. Mondrian is embedded in the Pentaho server and when you open the default analysis view, the schema file is used to browse ...

Pentaho is currently using existing users and roles from another application. Everything is working fine. Acegi related files have been configured properly. When I try to publish a schema from Schema Workbench I get an Access Denied error for any user. Publisher config xml file has a password. How to solve this? Is there any configuration for Schema Workbench? I know I can manually...

Have you checked that role is being forwarded as an input to jpivot? To be on the safe side...

Another strange thing: When you have a measure with visible="false" and as first measure in the schema, this measure is default shown when opening the analysis view. But when you select the second measure (only the first and the rest of the visible measures are selectable) and after clicked twice "ok" and want to change it back, the first measure is invisible.... This is a bug? Or what?

Quote: Originally Posted by diego.bnova I have about 400 mysql schemas. In each schema I defined fact and dimensionals table and aggregates table to improve Mondrian performance. I made a mondrian schema for each mysql schema, with explicit reference to aggregate tables( I use aggregation designer tool). I set the right option ...

Try adding schema='MySchemaName' to the jdbc driver. And also is squirell connected with user SU2, to check if user has been setup properly....

I wonder if there is anybody out there that has used the mondrian schema workbench against a Lucid DB, that could comment on any idiosyncrasies. As always your help is greatly appreciated. Thank you Richard

Did'u solve that problem?

Quote: Originally Posted by diego.bnova I have about 400 mysql schemas. In each schema I defined fact and dimensionals table and aggregates table to improve Mondrian performance. I made a mondrian schema for each mysql schema, with explicit reference to aggregate tables( I use aggregation designer tool). I set the right option ...

Have you checked that role is being forwarded as an input to jpivot? To be on the safe side...

Try adding schema='MySchemaName' to the jdbc driver. And also is squirell connected with user SU2, to check if user has been setup properly....

Define your cube using an appropriate TimeDimension with years -> month -> week -> day ( http://mondrian.pentaho.org/document...ime_dimensi ons ) and map it respect to the KEY_DATE column. In that case you can use the appropriate time related function to have what you're looking for (look at the link given above). Cheers Sergio

I wonder if there is anybody out there that has used the mondrian schema workbench against a Lucid DB, that could comment on any idiosyncrasies. As always your help is greatly appreciated. Thank you Richard

Pentaho is currently using existing users and roles from another application. Everything is working fine. Acegi related files have been configured properly. When I try to publish a schema from Schema Workbench I get an Access Denied error for any user. Publisher config xml file has a password. How to solve this? Is there any configuration for Schema Workbench? I know I can manually...

Hi. My current olap schema have dimenion DimDate having level year on which there exists key expression. i.e. To_NUMBER (To_CHAR(DATE_,'yyyy')). I created a aggregate at Year on DimDate. Now i m not able to execute MDX as Mondrian is throwing below exception at the time of loading the new schema. 4438 [main] ERROR mondrian.rolap.aggmatcher.AggTableManager - ...

Did'u solve that problem?