Configuration, Schema Workbench, OLAP4J, Spreadsheet Services, Aggregation Designer, JPivot...
The GA build of Mondrian 3.2.0 along with stable builds of Schema Workbench and Pentaho Aggregation Designer have been published on SourceForge and...
The stable build of Mondrian 3.2.0 along with release candidates of Schema Workbench and Pentaho Aggregation Designer have been published on...
Rules: Keep it short and simple One problem per message, please No explanations of the problem. Just post a one liner of what you think...
Hello All, We have created a cube using the Pentaho Metadata Editor and used the "Publish to Server" option. But when we checked the...
Hi all, I have an issue with writing MDX with input parameters: - date range - pulisher name I have wrote th enext one MDX: WITH member . AS...
Hi, I have a mysql query as follows: select a.download_date, a.CompanyName, a.category_desc, (select count(b.download_status) from...
Hi, I am getting an error of Session already invalidated when I try to add any hierarchy to my analysis. background info: I had to amend the...
Hi all, I use postgres DB, and trying to build degenerated dimension. For this reason i need to extract year as dimension level from the field...
In the documentation of mondrian regarding performance I found the following remark : "If a dimension (or, more precisely, the level of the...
Hi all, I'm facing a really problem, we are testing pentaho analysis, and we are waiting to buy a lincense. In the mean time we had configured,...
Hello, I want to get a sum of all selected elements of a dimension in my analysis. It should be displayed like the "All" element of a dimension,...
Hi there, just in case anybody is looking for a practical absolute beginner's tutorial on Mondrian, I wrote a blog post, that goes through the...
Hi, I use a SQLSERVER (2005) cube published by IIS on localhost with XMLA (the cube data comes from "Adventure Works" data). I deployed a basic...
Hi Does Mondrian support Running Sum, Running Average and Distinct Sum unlike any other OLAP Tool right now? If not is there any plan to have...
Hi, I have tried almost all the threads and other external information on setting up for access through XMLA but with no success. I would be...
Hi, In my schema I created a calculated member called CPA with the formula ./.. The formula works perfectly when I look at one week. Now I want to...
Hi all I'm making a cube in a schema using schema workbench, it worked fine when i make a MDX query on it, so i want to publish it, but it throws...
Hi, I’m evaluating the trial version, but I have a problem: -I build a simple Mondrian schema with Schema Workbench tool, connecting on a oracle...
Hi, Is is possible to create an Analytic view, based on a already created Analytic Report (exemple: 3 fields out of 10 and 1 filter on employees...
are there any plans to update Mondrian to use a more recent commons-math.jar? I ask because my code uses v2.0 of commons-math.jar and Mondrian...
Hi, I am new to Mondrian and to Schema Workebench and I'm having trouble connecting to a MySQL source database. I user the following parameters...
Hello When I want print my "analysis view" via PDF I've wrong national chars encoding (check attach) - ###, with XLS everythink it's ok. Could...
Hi All, I am using Pentaho 3.2.0. I have a transformation Table input ->Insert/Update. I want to truncate the target table after table input. I...
Hello all, I am new to analysis service and I am just trying to understand the basic concepts. So, if I have relational database that I would...
I'm trying to see what is the generated SQL from a MDX Query. I tried enabling log4j like I saw in a post:...
I read that this syntax is valid in the Microsoft documentation. Do you know if this is supported by Mondrian ? (A Select statement at the FROM...
Hi, I am trying to connect Excel to Mondrian using SimbaO2X provider. Simba was successfully installed but when I try to connect nothing happen ...
We have a dimension where one of the level members can be reached through 2 different parents. An example can be the Week of month in the time...
I upgraded from version 2.0 of the platform to version 3.6.0 stable a few months ago and have now noticed that aggregate tables for mondrian that...
Hi, I need to get Mondrian to create a database connection based on the user credentials specified in Excel (via the SimbaO2X adapter) when creating...
Hi all, I want to define a dimension using a select statement but i don't understand fully how I can do this and what attributes I need to define....
Dear all, I have a sample schema in which i need to use one detailed and one manually created agg table (for level "Country"). I have: - one...
Hi All, I am having issues trying to sum up some data in my Mondrian Schema Measurement. :confused: The SQL for this task is very similar to...
Use this control to limit the display of threads to those newer than the specified time frame.
Allows you to choose the data by which the thread list will be sorted.
Order threads in...
Note: when sorting by date, 'descending order' will show the newest results first.
Forum Rules