szymic1

Hi, I've define and connected to Mondrian OALP datasource. I've define very simple MDX query select {[Measures].[PaymentValue]} ON COLUMNS, NON EMPTY {[GroupPaymentType.AllGroupPaymentTypes].[AllGroupPaymentTypes]} ON ROWS from [Payment] Using 'Report Query' I've created one field PaymentValue - Data([Measures].[PaymentValue]) and I've tried to use this field on report. After clicking on preview I've got: Error filling print... Incorrect data mapping: the number of positions doesn't match the number of axes. net.sf.jasperreports.engine.JRRuntimeException: Incorrect data mapping: the number of positions doesn't match the number of axes. at net.sf.jasperreports.olap.JROlapDataSource$DataFieldMatcher.<init>(JROlapDataSource.java:473) at net.sf.jasperreports.olap.JROlapDataSource.createFieldMatcher(JROlapDataSource.java:281) To be honest I do not understand what is wrong. By the way where I can find report examples with OLAP datasouce? Michal Szymanski http://blog.szymanskich.net

Hi, I've recently discovered error on one of our report after migration of our database from Postgres 8.3 to Postgres 8.4. Jasper server generate following select count("CrmGrouView"."*") as "m0" from (SELECT * FROM warehouse.crm_document JOIN warehouse.crm_group ON id_crm_group=crm_group_id WHERE document_type='PAY') as "CrmGrouView" the problem is with this part "*", in Postgres 8,4 * cannot be in ". Do you know any workaround ? Full bug description: http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4355 Michal Szymanski http://blog.szymanskich.net http://techblog.freeconet.pl

The aggregration table has to be at the lowest level of granularity you want to access. In your case, it sounds like you can use your aggregate table as your fact table, because you are not going below the Day level in your analysis. Maybe it is good idea to create aggregate table for Day level (or Hour level) and use it as a fact table. But in such situation I will lose 'zoom and drill' functionality. It will be nice to have such functionality where in schema file we define that for 'Day' level Analysis Server use aggregate table but when we use use 'zoom and drill' it use table will full table. By the way I have big problem with Aggregate Designer after adding few aggregation levels I cannot save in logs I've got: 11:03:26,421 INFO [AggListController] Event index: 0 aggTable.selectedRow0: 0 java.lang.NullPointerException at com.thoughtworks.xstream.io.xml.PrettyPrintWriter.writeText(PrettyPri ntWriter.java:203) at com.thoughtworks.xstream.io.xml.PrettyPrintWriter.writeText(PrettyPri ntWriter.java:199) .......................... I cannot write what I create i this program? Have you encoutered this bug? Maybe I have wrong Java version, now I have 1.6. Regards Michal Szymanski http://blog.szymanskich.net

Short version of schema is in attachment, and table definitions are quite simple and look similar to this: warehouse.cdr_group_view has following fields: call_status, id_start_time_invite_date, crm_group_type, payment_type, cdr_id, call_duration, call_cost, ps_call_cost, command, id_start_time_invite_time Time dimension: CREATE TABLE warehouse.warehouse_time ( warehouse_time_id bigserial NOT NULL, time_hour integer, CONSTRAINT warehouse_time_pkey PRIMARY KEY (warehouse_time_id) ) CREATE TABLE warehouse.warehouse_date ( warehouse_date_id bigserial NOT NULL, calendar_date date, calendar_year integer, calendar_day_of_year integer, calendar_day_of_month integer, calendar_month_number integer, calendar_month_name character varying ); ALTER TABLE warehouse.warehouse_date OWNER TO carrierexadm; Fact table has millions of rows, biggest dimension has around 600 rows. Performance is not so bad (to see date for each year user have to wait 2-3 min) but we expect more rows in the future and response time in tens of minutes is not acceptable. Regards Michal Szymanski http://blog.sztmanskich.net

tkavanagh Wrote: Are there any specific bugs you are concerned about? Or are you just thinking about getting the latest bug fixes in general? I've discovered two bugs one related to caption in shared dimension http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=62685 and second less important http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4247 by the way try to find answer to my question regarding aggregate tables :) http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=62746 Regards Michal Szymanski http://blog.szymanskich.net

This problem with AllMembers was described in http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=61358 Post Edited by szymic1 at 08/26/2009 12:47

Hi, On sourceforge there are all version of JasperServer but where can I find patches for the newest vesion or maybe I have to wait for newer version of software and JasperSoft does not publih patches for community edition? Regards Michal Szymanski http://blog.szymanskich.net

Should I use closuere table somehow? Regards Michal Szymanski

I have one big fact table 'Calls' and one dimension table 'Date' with levels Year,Month,Day and measure 'CallDuration'. I add one aggregation table (using AggName) that aggregate CallDuration per day. Suppose that for one day I have 100,000 calls and I store 300 days what gives 30 000 000 rows. When I create very simple MDX that displays CallDuration for each day for each year server is using aggregate table what is proper behaviour, but when I want to display CallDuration for each Month JasperAnalysis does not use aggregation table (probably it will work when I make one aggregation table where I aggregate CallDuration per month). In my opinion JasperAnalysis should sum rows from aggregation table with day's values (it will be definitly faster than calculating sum from whole table) but it does not happen :( Is it possible force JasperAnalysis to use aggregation table with per day values when it find date for months? Michal Szymanski http://blog.szymanskich.net

I have following shared dimension definition <Dimension type="TimeDimension" name="Date" caption="Okres"> <Hierarchy name="PeriodWithQuarter" hasAll="true" allMemberName="AllPeriods" allMemberCaption="Caly okres" primaryKey="warehouse_date_id" caption="Okres"> <Table name="warehouse_date" schema="warehouse"> </Table> <Hierarchy name="PeriodWithoutQuarter" hasAll="true" allMemberName="AllPeriods" allMemberCaption="Caly okres" primaryKey="warehouse_date_id" caption="Okres"> <Table name="warehouse_date" schema="warehouse"> </Table> <Level name="Year" column="calendar_year" type="Numeric" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" caption="Rok"> </Level> <Level name="Month" column="calendar_month_number" type="Numeric" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never" caption="Miesiac"> </Level> <Level name="Day" column="calendar_day_of_month" type="Numeric" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" caption="Dzien"> </Level> </Hierarchy> </Dimension> and I use in two places in Cube <Cube name="Group" caption="Grupy" cache="true" enabled="true"> <View alias="CrmGrouView"> <SQL dialect="generic"> ............... </SQL> </View> <DimensionUsage source="Date" name="CreationDate" caption="Creation date" foreignKey="id_creation_date"> </DimensionUsage> <DimensionUsage source="Date" name="BelowZeroDate" caption="Balance date" foreignKey="id_empty_account_date"> </DimensionUsage> <Measure name="GroupAmount" column="*" aggregator="count" caption="Iosc" visible="true"> </Measure> </Cube> when I display this cude in Jpivot both columns 'CreationDate' and 'BelowZeroDate' have caption 'Okres' (what is defined in <Dimension>). Do you know how to fix it? Maybe you know how to write SQL 'AS' construction in MDX. Now it is hard to say which column is 'Creation date' and which is 'BelowZeroDate' Michal Szymanski http:/blog.szymanskich.net

I have one big fact table 'Calls' and one dimension table 'Date' with levels Year,Month,Day and measure 'CallDuration'. I add one aggregation table (using AggName) that aggregate CallDuration per day. Suppose that for one day I have 100,000 calls and I store 300 days what gives 30 000 000 rows. When I create very simple MDX that displays CallDuration for each day for each year server is using aggregate table what is proper behaviour, but when I want to display CallDuration for each Month JasperAnalysis does not use aggregation table (probably it will work when I make one aggregation table where I aggregate CallDuration per month). In my opinion JasperAnalysis should sum rows from aggregation table with day's values (it will be definitly faster than calculating sum from whole table) but it does not happen :( Is it possible force JasperAnalysis to use aggregation table with per day values when it find date for months? Michal Szymanski http://blog.szymanskich.net

I've notice that SELECT [Measures].AllMembers ON COLUMNS, [Czas.Okres].[Miesiac].Members ON ROWS FROM [Naliczenia] does not work in 3.5 but it works in 3.1.

calathea Wrote: I am not at work at the moment but will check my logs tommorow and see if i can see anything with my error, i assume they are in a log directory somewhere? Well I've notice that SELECT [Measures].AllMembers ON COLUMNS, [Czas.Okres].[Miesiac].Members ON ROWS FROM [Naliczenia] does not work on 3.5 but on 3.1 it works. Use [Measures].[<yourmeasuer] instead. Michal Szymanski http://blog.szymanskich.net

Solution: Change the data type on the database to VARCHAR by casting the integer to a CHAR before CONCAT. Bingo it works! Well, I do not use concat. Today I was suprised that for short period of time my example works on 3.5 but after restart of JasperServer I've got message 'An error occured while..' :( The worst thing is that logs does not show what is real problem look below: ................ 13:14:54,960 DEBUG mdx,http-1280-Processor24:593 - 13: select [Measures].AllMembers ON COLUMNS, Hierarchize([PaymentType.TypPlatnosciAll].[All PaymentType.TypPlatnosciAlls].Children) ON ROWS from [Payment] 13:14:54,961 DEBUG mdx,http-1280-Processor24:630 - 13: exec: 1 ms 13:14:54,963 ERROR JSErrorPage_jsp,http-1280-Processor24:329 - javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy ................... it execute few steps and suddenly I've got exception ' An error occurred while getting p...' :( Michal Szymanski Post Edited by szymic1 at 08/20/2009 13:18

swood Wrote: What version of JasperServer are you running? Could you try restarting the server and then the analysis view? Sherman Jaspersoft Today I've submited error to tracker http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4247 and asigned to you Michal Szymanski http://blog.szymanskich.net