Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: saschaz; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. Replies
    1
    Views
    1,604

    How to implement a user defined function

    I need to calculate the T-value (or P-value) for a linear regression. With MDX I can nicely calculate the linear regression using the LINREGSLOPE() function, but I can't calculate the result of a...
  2. Updating data in a Mondrian scheme created with the data source wizard

    In BA server I've created a Mondrian scheme from a csv file using the Data Source Wizard. This csv file is created by a Kettle transformation. I was hoping I could add one step to the transformation...
  3. What was missing is that the years have to be...

    What was missing is that the years have to be translated to an index, from 1 to the number of years. This can be done with the rank function:

    WITH
    SET [SelStations] as...
  4. Using the LinRegSlope() function in Mondrian MDX

    I can't seem to get the correct result from the LinRegSlope function in Mondrian MDX. I have a cube with three dimensions:

    Station
    Year
    Month

    and one of my measures is the Rain in mm.
    ...
  5. Replies
    7
    Views
    7,912

    It worked for me when I specified one column...

    It worked for me when I specified one column width less than the number of columns there are. The last column is sized automatically.
  6. Replies
    1
    Views
    625

    Making the following settings in the CDE chart...

    Making the following settings in the CDE chart solved it:
    - dataMeasuresInColumns: True
    - dataIgnoreMetadataLabels: True
    - isMultiValued: True
  7. Ok, apparently Mondrain doesn't accept subqueries.

    Ok, apparently Mondrain doesn't accept subqueries.
  8. Replies
    1
    Views
    625

    Help with box plot needed

    I'm using a Mondrian MDX query as a datasource for a box plot on my CDE dashboard.

    The MDX query:
    SELECT
    [Month].[Month].Members on 1,
    ...
  9. Saiku MDX SubQuery throws NullPointerException

    As soon as I try to write an MDX query in Saiku that uses a subquery, Saiku responds with "Error executing query. Please check the server logs or contact your administrator!". In the Catalina log...
Results 1 to 9 of 9
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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