Jump to content

szymic1

Members
  • Posts

    24
  • Joined

  • Last visited

 Content Type 

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

Posts posted by szymic1

  1. 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

     

     

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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 

  7. 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

     

     

  8. 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 

  9. 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

  10. >What version of JasperServer are you running?

     

    3.5, after when I've described problem here I've discovered that someone else describde problem here

    http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=61358

     

    As I've written it works in 3.1 :(

     

    > Could you try restarting the server and then the analysis view?

     

    Yes I've restarted server several times. Today I will report issue to Jaspersoft Mantis with log files and detail description of problem.

     

    Regards

    Michal Szymanski

    http://blog.szymanskich.net

  11. swood
    Wrote:

    Your problem could be because of this bug http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4222 If you uploaded the schema after running it once, then you could get this. Try restarting the server

    Today I've installed older version of JasperServer 3.1.0 and I've used the same schema definiton and the same database and there is no error.  I am almost sure that we are talking about error in JasperServer 3.5, the question is how to fix it in 3.5?

     

    Regards

    Michal Szymanski

    http://blog.szymanskich.net

  12. swood
    Wrote:

    Your problem could be because of this bug http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4222 If you uploaded the schema after running it once, then you could get this. Try restarting the server.

     

    Did the exception occur during the creation/editing of the analysis view?

     

     

    Sherman

    Jaspersoft

    I have the same problem and no solution so far :(

    http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=107&topicid=62239

    Exception occurs when I click on created  'analysis view'.

     

    Michal Szymanski

    http://blog.szymanskich.net

  13. Hi,

    When I try to see my  analysis raport I've got

    An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy

    IWe are using Postgres 8.3 and  I've creaed datasource for my view and it works (it works without problem with Reports)

    in my database I have two tables  public.crm_document (it is fact table) and public.fee_code

    and I've define my schema as follow:

    <Schema name="UproszczonaKosta">
      <Cube name="UproszczonaKostkaNaliczenia" caption="Kostka" cache="true" enabled="true">
        <Table name="crm_document" schema="public">
        </Table>
        <Dimension type="StandardDimension" foreignKey="id_fee_code" name="RodzajUslugi">
          <Hierarchy name="WszystkieUslugi" hasAll="true" allMemberName="WszystkeUslugi" primaryKey="fee_code_id">
            <Table name="fee_code" schema="public">
            </Table>
            <Level name="fee_code" column="description" nameColumn="description" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
            </Level>
          </Hierarchy>
        </Dimension>
        <Measure name="Kwota" column="amount" datatype="Numeric" aggregator="sum" visible="true">
        </Measure>
      </Cube>
    </Schema>
     

    In Schema Workbech following MDX query:

    SELECT
    [Measures].AllMembers ON COLUMNS,
    Hierarchize([RodzajUslugi.WszystkieUslugi].[WszystkeUslugi].Children) ON ROWS
    FROM [uproszczonaKostkaNaliczenia]

    it works without problem eg:


    |                                                                   | Kwota     |
    +-------------------------------------------------+-----------+
    | Obciążenie manualne konta                |  1,000.94 |

    ..........................

     

    but when I try to view created  'Analysis View'  I always get 

    An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy 

     

    P.S We replace old Postgre JDBC driver in Jasper directories (to be honest I've replaced in several places because I do not know where is proper location of JDBC driver)

     

    Michal Szymanski

    http://blog.szymanskich.net

×
×
  • Create New...