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

  1. Replies
    1
    Views
    124

    CacheControl.flushSchema & deadlock

    Hi.
    Sometime, we have the problem with clear cache of OlapConnection and executing mdx query in parallels threads.
    All olapStatements waiting the next thread:
    ...
  2. Replies
    0
    Views
    193

    Custom cache for schemas and dim items

    There is any way to store schema cache (calculate measures and dimensions items) in custom cache, some thing like mondrian.rolap.SegmentCache property?
  3. Thread: Mondrian 3.9

    by kidar2
    Replies
    1
    Views
    306

    Mondrian 3.9

    Hi.
    Where I can view list of bugs fixed in this version?
  4. Replies
    0
    Views
    239

    Restart mondrian internal server

    Hi.
    Some times I need to restart internal mondrian server. Is there any way for this?
  5. Replies
    1
    Views
    226

    Calculate members. Formula validation

    Hi.
    I have xml schema with large number of calculation measures.
    When OlapConnection is opening, mondrian start validation the all calculation measures.
    Some formulas using elements of big...
  6. Replies
    0
    Views
    191

    Exclude filter in mdx

    Now using the exclude filter is generated SQL query, which are elements of the test for equality are not marked in the filter.


    Is it possible to exclude in the case of the filter to make...
  7. What is the best cache system for mondrian SegmentCache ?

    Memcached, Redis, Hazelcast or something others ?
  8. Replies
    1
    Views
    232

    TopCount of big dimension

    How to calculate via mdx
    TopCount([My dim].members, [Measures].[Test], 20)

    without build all dimension members? I need it because my dimension is very big - 1000000 items.
  9. Replies
    4
    Views
    390

    If i write this: select non empty...

    If i write this:

    select non empty [Date].[Date].Members on 0,
    non empty [Measures].[Customer Count] on 1
    from [Adventure Works]
    where ({[Product].[Category].[4]},...
  10. May be this ? IIF(...

    May be this ?
    IIF( [Country].CurrentMember.Name="USA", [Measures].[Sales], 0)
  11. Replies
    1
    Views
    240

    You should use the olap4j library and xmla server...

    You should use the olap4j library and xmla server of SSAS.
    Fore example:
    OlapConnection s = (OlapConnection)...
  12. Replies
    4
    Views
    390

    mdx where clause

    Hi.
    In SSAS i can write this mdx query:
    select non empty [Date].[Date].Members on 0,
    non empty [Measures].[Customer Count] on 1
    from [Adventure Works]
    where ([Product].[Category].&[4] ,...
  13. Replies
    0
    Views
    175

    Automatic cleaning cache of mondrian

    Sometimes the passage of time, we notice that the cache in mondrian somehow disappears and all the data retrieved from the database again.
    Is there a mondrian some automatic cleaning cache?
  14. NullPointerException in SegmentCacheIndexImpl after flushSchemaCache

    Hi.
    When i clear cache of schema

    RolapConnection privateConnection = OlapConnection.unwrap(RolapConnection.class);
    CacheControl cacheControl = privateConnection.getCacheControl(null);...
  15. Need help for implement mondrian.spi.SegmentCache in Memcached

    Hi.
    I'am using this http://code.google.com/p/spymemcached client of memcached.
    How to implement listeners?
    Wich string key of SegmentBody class i must to use for store in memcached ?
    What is...
  16. Replies
    1
    Views
    224

    Custom aggregation method

    Hi, i need to define custom aggregation method of measure, for example Median.


    How can i do this ? May be exists java interface for this? Some like this:

    <Measure name ="Median" column...
  17. Segment cache, add new day to calendar dimension

    Hi.
    I readed documentation about cache control of mondrian (http://mondrian.pentaho.com/documentation/cache_control.php).
    Every day I add new data into my database. After that I want to update...
  18. Replies
    1
    Views
    194

    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.
  19. Replies
    0
    Views
    169

    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...
  20. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    2,405

    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) {
    ...
  21. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    2,405

    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?
  22. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    2,405

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

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

    by kidar2
    Replies
    14
    Views
    2,405

    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.
  24. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    2,405

    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?
  25. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    2,405

    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");
    =>...
  26. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    2,405

    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 = ...;...
  27. Thread: Mondrian 4

    by kidar2
    Replies
    14
    Views
    2,405

    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?
  28. 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...
  29. Replies
    1
    Views
    406

    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.
  30. Replies
    3
    Views
    460

    Yes, its working. Thank you.

    Yes, its working. Thank you.
  31. Replies
    3
    Views
    460

    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
    ...
  32. Replies
    3
    Views
    460

    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?
  33. Replies
    6
    Views
    758

    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...
  34. Replies
    6
    Views
    758

    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]] >...
  35. Replies
    6
    Views
    758

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

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

    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...
  37. Replies
    0
    Views
    279

    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)...
  38. Replies
    4
    Views
    547

    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...
  39. Replies
    4
    Views
    547

    Calculate members in mdx

    Hello.
    There is simple data.


    Time
    Country
    value_per
    value
  40. Replies
    6
    Views
    1,639

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

    Thank you very much, just what you need!!!
  41. Replies
    6
    Views
    1,639

    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...
  42. Replies
    6
    Views
    1,639

    I using mondrian 3.5.0. Does it support...

    I using mondrian 3.5.0. Does it support subqueries?
  43. Replies
    5
    Views
    1,209

    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,...
  44. Replies
    5
    Views
    1,209

    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?
  45. Replies
    5
    Views
    1,209

    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. ...
  46. Replies
    1
    Views
    407

    clear Schema cache

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

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

    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...
  48. 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...
  49. Replies
    3
    Views
    2,282

    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...
  50. Replies
    3
    Views
    2,282

    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...
Results 1 to 50 of 69
Page 1 of 2 1 2