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

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.09 seconds.

  1. Replies
    1
    Views
    107

    Hot to get sql query from OlapStatement

    Hi.
    I execute mdx query by OlapStatement

    olapStatement.executeOlapQuery(mdx);

    How i can get sql query of this mdx, not in log? I want to get it in my java variable.
  2. Replies
    0
    Views
    126

    setRoleName to OlapStatement

    I need to set current RoleName to OlapStatement, but this class don't have any API for this.
    Only OlapConnection have method setRoleName.
    But in my application instance of OlapConnection is shared...
  3. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    1,987

    Thank you fro reply. I'm not sure, but i think...

    Thank you fro reply.
    I'm not sure, but i think this function contains my bug with not working "schema" attribute:

    private MondrianDef.Table convert(Mondrian3Def.Table xmlLegacyTable) {
    ...
  4. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    1,987

    Another little question: What classes in...

    Another little question:

    What classes in mondrian 4 are responsible for the conversion of xml-schema to the new format?
  5. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    1,987

    Thank's for reply. Where can i get new full...

    Thank's for reply.
    Where can i get new full schema specification?
  6. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    1,987

    No, my schema does not contains an errors,...

    No, my schema does not contains an errors, because it's excellent working in mondrian 3.7.
  7. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    1,987

    Yes, it's work. But stopped working attribute...

    Yes, it's work.
    But stopped working attribute "schema" in table xml element => "relation 'my table' does not exists".





    When you release a stable version?
  8. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    1,987

    I trying use the mondrian-4.0.0.13109.jar. The...

    I trying use the mondrian-4.0.0.13109.jar.
    The mondrian-4.0.0.0-752.jar have the error when loading mondrian driver:

    Class.forName("mondrian.olap4j.MondrianOlap4jDriver");
    =>...
  9. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    1,987

    So, i tried to use mondrian 4.0.0 with...

    So, i tried to use mondrian 4.0.0 with olap4j-1.1.0 (is released and support mondrian 4+).
    But there is some errors incompatibility:

    OlapConnection c = ...;...
  10. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    1,987

    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?
  11. 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...
  12. Replies
    1
    Views
    244

    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.
  13. Replies
    3
    Views
    330

    Yes, its working. Thank you.

    Yes, its working. Thank you.
  14. Replies
    3
    Views
    330

    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
    ...
  15. Replies
    3
    Views
    330

    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?
  16. Replies
    6
    Views
    495

    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...
  17. Replies
    6
    Views
    495

    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]] >...
  18. Replies
    6
    Views
    495

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

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

    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...
  20. Replies
    0
    Views
    216

    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)...
  21. Replies
    4
    Views
    442

    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...
  22. Replies
    4
    Views
    442

    Calculate members in mdx

    Hello.
    There is simple data.


    Time
    Country
    value_per
    value
  23. Replies
    6
    Views
    1,472

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

    Thank you very much, just what you need!!!
  24. Replies
    6
    Views
    1,472

    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...
  25. Replies
    6
    Views
    1,472

    I using mondrian 3.5.0. Does it support...

    I using mondrian 3.5.0. Does it support subqueries?
  26. Replies
    5
    Views
    618

    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,...
  27. Replies
    5
    Views
    618

    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?
  28. Replies
    5
    Views
    618

    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. ...
  29. Replies
    1
    Views
    357

    clear Schema cache

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

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

    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...
  31. 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...
  32. Replies
    3
    Views
    1,540

    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...
  33. Replies
    3
    Views
    1,540

    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...
  34. Thank you for your reply. Mondrian 4 is released?

    Thank you for your reply. Mondrian 4 is released?
  35. 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"...
  36. Replies
    5
    Views
    563

    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...
  37. 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();...
  38. Replies
    5
    Views
    563

    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.
  39. Replies
    5
    Views
    563

    Measures dimension

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

    by kidar2
    Replies
    3
    Views
    485

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

    Which gives an error this sql query in MySQL workbench?
  41. 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
  42. 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...
  43. "type" (set to integer, number), "internalType"...

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

    Maybe there is a setting of attribute types of dimension?
  45. 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...
  46. 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"...
  47. Thank you very much

    Thank you very much
  48. 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 =...
  49. Replies
    1
    Views
    510

    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...
  50. Replies
    1
    Views
    510

    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");
    ...
Results 1 to 50 of 52
Page 1 of 2 1 2