US and Worldwide: +1 (866) 660-7555

Search Forums:

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

Search Forums: Search took 0.04 seconds; generated 44 minute(s) ago.

  1. Thread: Mondrian 4

    by kidar2
    Replies
    0
    Views
    1,274

    Mondrian 4

    Hi.
    I found the presentation about new features in Mondrian 4. But i don't understand, there is stable version? i founded only "mondrian-4.0.0-SNAPSHOT" Can i use them?
  2. Calculate measure, filter non aggregate values

    Hi.
    I have the simple cube with 2 dimensions: Dim1, Dim2, and one measure - value (aggregator = sum)
    I need to get cross table via mdx:

    select non empty [Dim2].members on 0,
    non empty...
  3. Replies
    1
    Views
    152

    Custom functions in mdx

    Hi.
    Can i add custom functions into mdx? For example, i want to add statistics functions from R. But I do not know how.
  4. Replies
    3
    Views
    234

    Yes, its working. Thank you.

    Yes, its working. Thank you.
  5. Replies
    3
    Views
    234

    I connected to mysql server over ssl. But when i...

    I connected to mysql server over ssl.
    But when i creating mondrian (OlapConnection) via DriverManager and this url
    ...
  6. Replies
    3
    Views
    234

    SSL Mondrian connection to mysql database

    Hello.

    I have CA File, CERT File and Key File. What i must to set url, to olap database connection?
  7. Replies
    6
    Views
    350

    Thank you. Here's a working version:

    Thank you.
    Here's a working version:

    <Schema name="test">
    <Cube name="bla">
    <View alias="testtable">
    <SQL dialect="generic"><![CDATA[select * from data]]></SQL>
    </View>
    <Dimension...
  8. Replies
    6
    Views
    350

    Sorry, but is not working... I removed attribute...

    Sorry, but is not working...
    I removed attribute primarykey

    <Schema name="Schema">
    <Cube name="cube">
    <View alias="testtable">
    <SQL dialect="postgres">
    <![CDATA [select * from data]] >...
  9. Replies
    6
    Views
    350

    If i remove foreignkey attribute, then is't work?

    If i remove foreignkey attribute, then is't work?
  10. Replies
    6
    Views
    350

    Mondrian schema xml. Cube from sql query

    Hi.
    I created xml schema and cube from sql query, and set alias='bla'.
    But i have the error:

    <Schema name="S">
    <Cube name="Source name" visible="true" cache="true" enabled="true">
    <View...
  11. Replies
    0
    Views
    170

    Time dimension and SQL Server

    Hi.
    I have simple table in sql server:


    CREATE TABLE [dbo].[test](
    [name] [varchar](max) NULL,
    [season] [varchar](max) NULL,
    [date] [datetime] NULL,
    [Category] [varchar](max)...
  12. Replies
    4
    Views
    348

    I created simple cube in this data: ...

    I created simple cube in this data:

    Time,Country,value_per,value
    1998,USA,1.37,1000
    1999,Canada,2.37,3000

    Two measures, and dimensions: Time, Country.
    I tried to use SOLVE_ORDER, but no...
  13. Replies
    4
    Views
    348

    Calculate members in mdx

    Hello.
    There is simple data.


    Time
    Country
    value_per
    value
  14. Replies
    6
    Views
    1,405

    Thank you very much, just what you need!!!

    Thank you very much, just what you need!!!
  15. Replies
    6
    Views
    1,405

    There is simple data. 2 dimensions and 1 measure....

    There is simple data. 2 dimensions and 1 measure.

    dim1,dim2,value
    Russia,1997-01-01,15
    Russia,1997-01-01,15
    Russia,1997-01-01,30
    Russia,1999-01-01,25
    USA,1998-01-01,15
    USA,1999-01-01,20...
  16. Replies
    6
    Views
    1,405

    I using mondrian 3.5.0. Does it support...

    I using mondrian 3.5.0. Does it support subqueries?
  17. Replies
    5
    Views
    445

    Yes, of course i can. But in our database we...

    Yes, of course i can.
    But in our database we have ~100 mondrian data schemas, and to create additional measures not simple.
    I was hoping there is simple mdx function for change aggregation type,...
  18. Replies
    5
    Views
    445

    Thanks. Can i put into first parameter 'Min'...

    Thanks.
    Can i put into first parameter 'Min' current Filter (from all axis's and from 'where' clause), not specified as you?
  19. Replies
    5
    Views
    445

    MDX change aggregation type of measure

    Hello.
    I have a simple cube:
    2 Dimensions: dim1, dim2
    1 Measure: value (default is sum aggregation type)

    I want to change aggregation type in my mdx query to min, max, distinct count, average. ...
  20. Replies
    1
    Views
    313

    clear Schema cache

    I have OlapConnection instance, and i try clear schema cache:

    RolapConnection privateConnection = s.OlapConnection.unwrap(RolapConnection.class);
    CacheControl cacheControl =...
  21. Replies
    0
    Views
    351

    Filter non aggregate values by condition

    Hello.
    There is simple cube. Dimensions : Calendar, Country. One mesaure - user sum.
    Real data like this
    2012, 2013
    Russia 100 3000
    USA 200 4000

    With filter >1000 must be...
  22. How to set aggregation type of measure in mdx ?

    In xml schema measure have this attributes

    <Measure aggregator="sum" column="market_cap" name="market_cap" visible="true"/>

    Can i change aggregation type of measure in mdx query ? Some like...
  23. Replies
    3
    Views
    1,169

    The same error... I found function ...

    The same error...
    I found function CurrentDateMember. In calendar dimension has members from 2013.10.1 to 2013.10.31.
    Today - 2013.11.29

    select...
  24. Replies
    3
    Views
    1,169

    MDX. Get data between two dates

    I think it's very popular question. But I have not found a solution.
    I have a calendar dimension with daily dynamics. In database keys have the DateTime format ("2013-09-03 03:00:00+06").
    I want to...
  25. Thank you for your reply. Mondrian 4 is released?

    Thank you for your reply. Mondrian 4 is released?
  26. MDX: Different levels of Dimension in different axes

    There is simple query:

    select [Browser].[Name].Allmembers on 0,
    [Browser].[Version].Allmembers on 1

    from [Payments]

    Browser has the structure:

    <Dimension type="StandardDimension"...
  27. Replies
    5
    Views
    484

    I think how i must create fact table - by 1000...

    I think how i must create fact table - by 1000 columns for each measures or put list of measures into other table and link this by dimension. Just, i think 1000+ columns in fact table - is not good...
  28. Update cell value into database and cube cache

    There is very simple task - change cell value in fact table and cube cache.
    I try by this code

    OlapConnection olapConnection = getConnection();...
  29. Replies
    5
    Views
    484

    I do not want to manually create 1000 metrics and...

    I do not want to manually create 1000 metrics and set for each desired column of the data table.
    So I want to create a metrics dimension and just set to cube.
  30. Replies
    5
    Views
    484

    Measures dimension

    How i can create my measures dimension from existing dimension.
    My data have over 1000 measures, and i want automate this process
  31. Thread: mondrian error

    by kidar2
    Replies
    3
    Views
    429

    Which gives an error this sql query in MySQL...

    Which gives an error this sql query in MySQL workbench?
  32. I solved the problem. After debugging the code...

    I solved the problem. After debugging the code mondrian'a figured out that you need to remove the attribute
    nameColumn = "id"

    because such a condition is triggered
    12116
    which spoils
  33. By source code of Mondrian, for generate "upper"...

    By source code of Mondrian, for generate "upper" in sql query uses "dataType" attribute. The attribute "internalType" is not used. How I can set this attribute for level of my dimension ?
    <Level...
  34. "type" (set to integer, number), "internalType"...

    "type" (set to integer, number), "internalType" (set to integer, numbr) - it did not help
  35. Maybe there is a setting of attribute types of...

    Maybe there is a setting of attribute types of dimension?
  36. I changed "year" field type of "time" table from...

    I changed "year" field type of "time" table from "Integer" to "Text" and this works.
    I think it's a mistake, because he had to generate such a sql request with condition...
  37. Mondrian + Postgresql Internal error: while building member cache;

    I have very simple cube
    <Cube name="World Economics" visible="true" cache="true" enabled="true">
    <Table name="data" schema="public">
    </Table>
    <Dimension type="StandardDimension"...
  38. Thank you very much

    Thank you very much
  39. How get org.olap4j.metadata.Cube from Mondrian OlapConnection

    Hi all. From Java code i create OlapConnection and try get all cubes from database.
    OlapConnection c = (OlapConnection) DriverManager.getConnection(connStr);
    OlapDatabaseMetaData md =...
  40. Replies
    1
    Views
    447

    Earned in such code String connStr =...

    Earned in such code

    String connStr = "jdbc:mondrian:"
    + "Jdbc=jdbc:mysql://localhost:3306/wdi; JdbcUser=root; JdbcPassword=q;"
    + "Catalog=file://c:\\Program...
  41. Replies
    1
    Views
    447

    Mondrian usage from java

    I have some code
    import mondrian.olap.Connection;
    import java.sql.*;
    import java.util.*;

    ….
    Class.forName("com.mysql.jdbc.Driver");
    Class.forName("mondrian.olap4j.MondrianOlap4jDriver");
    ...
  42. Replies
    1
    Views
    489

    I was able to connect to the server xmla:...

    I was able to connect to the server xmla:
    AdomdConnection con = new AdomdConnection("Data Source=http://localhost:8080/pentaho/Xmla?userid=joe&password=password; Initial Catalog=wdi; User Id = joe;...
  43. Replies
    1
    Views
    489

    ADOMD Client. Error 404

    I have the simple cube, published with "Register XMLA Data Source".
    How can i open connection by adomd client from c#?
    I tried this ,

    AdomdConnection con = new AdomdConnection("Data...
Results 1 to 43 of 43