Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Virtual Cube Error in Saiku Anaytics

  1. #1
    Join Date
    Aug 2013
    Posts
    9

    Default Virtual Cube Error in Saiku Anaytics

    Hi all,

    In Saiku Analytics I have this error in my Cube :
    SybSQLException: SQL Anywhere Error -1005018: Illegal ORDER BY item 0, -- (opt_OrderBy.cxx 164)

    This error appears when I selected :
    ROWS : Measure A, Measure B
    COLUMNS : Dimension 1, Dimension 2


    I have defined a Mondiran Schema which looks like this:

    Schema

    Cube 1
    Dimension Usage 1
    Dimension Usage 2
    Dimension Usage 3
    Measure A

    Cube 2
    Dimension Usage 1
    Dimension Usage 2
    Measure B

    Dimension (Shared) 1
    Dimension (Shared) 2
    Dimension (Shared) 3


    Virtual Cube
    Virtual Dimension 1
    Virtual Dimension 2
    Virtual Dimension 3
    Virtual Measure A
    Virtual Measure B

    thanks & regards

  2. #2

    Default

    More Info would be better... Place the query here

  3. #3
    Join Date
    Aug 2013
    Posts
    9

    Default

    Hi,

    I can't see the Explain Plan.
    I just see the MDX query :
    ----------
    SELECT
    NON EMPTY {[Measures].[Measure1], [Measures].[Measure2]} ON COLUMNS,
    NON EMPTY CrossJoin([Dimension 1].[Annee].Members, [Dimension 2].[BP].Members) ON ROWS
    FROM [Suivi]
    ---------

    thanks & regards

  4. #4
    Join Date
    Jan 2013
    Posts
    796

    Default

    Hi classalle,
    The error you're getting is Sybase choking on some SQL. Can you post the log output from the failure, including SQL generated? You may need to enable SQL logging in your log4j.xml file (there's a "mondrian.sql" category that you should be able to uncomment).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.