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

Search Forums:

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

Search Forums: Search took 0.06 seconds.

  1. Replies
    5
    Views
    339

    Hi, yeah .. It is working when we add type_id to...

    Hi, yeah .. It is working when we add type_id to fact_table. But, It is not possible for us to have all the columns in fact_table. There are 12 such dimensions we have, that using <join>.

    There is...
  2. Replies
    5
    Views
    339

    Hi gabitoju, Thanks for the reply. "Customer...

    Hi gabitoju, Thanks for the reply.

    "Customer Type
    |
    |-- Customer

    Then need to have Type_id and Type_dsc in your customer table"


    Actually, In customer table I have type_id, but all...
  3. Replies
    5
    Views
    339

    Join Tables - Dimension Table

    Hi, I have added 2 dimensions like, one is with single table and other is with join.


    fact_table
    auto_id customer_id amount date
    1 1
    2 1...
  4. Replies
    1
    Views
    189

    Row size or Row count

    Hi all, when it comes to the cache, how the mondrian fetching the data. Will it fetches and cached only the columns mentioned in the schema or it fetches all the columns in fact table.

    Is that...
  5. Replies
    2
    Views
    314

    I guess .. no need of adding a measure .. u can...

    I guess .. no need of adding a measure .. u can get in the mdx itself ..

    Assuming u have dimensions like..


    <Dimension type="StandardDimension" visible="true" foreignKey="User_id"...
  6. Adding Age dimension in tricky way ..

    wow ...... It just got solved ... I referred some mdx forums and finally added a dimension Age like this


    <Dimension type="StandardDimension" visible="true" foreignKey="customer_id"...
  7. Thanks for the reply. Here the date_id and dob of...

    Thanks for the reply. Here the date_id and dob of customer is not related. The Business rule might be like, "get all customer names of age(group), who made transactions of amount > 1k".

    - if I add...
  8. Dimension/ Measure as Customer Age or Customer Age Group

    Hi all,

    table_fact:


    tran_id customer_id amount date_id
    1 1234 1000 20140414
    2 1245 1200 20140414
    3 1256 1800 20140414
    4 1234 1000...
  9. Thanks for the reply. Actually, I m running...

    Thanks for the reply. Actually, I m running multiple queries to get it done. And I forgot to mention that for every customer the start date changes based on the transactions done by that customer (In...
  10. Need help in converting this Business logic into MDX

    Hi all, I need help to write mdx for this scenario ..


    table_fact:
    date type1 type2 amount customer ... and some other dims with auto incr id
    1 C 3 100 ...
  11. Unexpected Results with verion 3.6 ( using except and Not-In functions )

    Hi mcampbell, Sorry for the late reply (test result on version 3.6, I was away from the project).

    For the MDX with except/ not-in functions (which are applied on a dimension with 700 members)...
  12. Replies
    11
    Views
    2,279

    hi , If you increase your cellbatchSize value,...

    hi ,
    If you increase your cellbatchSize value, you have to increase your innodb_buffer_pool_size (in case of MySql). The back-end mysql has also to be optimized (also try to set table_cache and...
  13. Tested on 3.6

    Hi mcampbell, Here I am attaching the test results on 3.6.
    This time, I reduced the dataset size and increased the no of slicer dimensions (aggregating with not in ).

    Query:

    with member...
  14. Hi, I too have same problem with 3.5 version....

    Hi, I too have same problem with 3.5 version.
    here is the jira case http://jira.pentaho.com/browse/MONDRIAN-1803
    It is taking very long time and in my case i got wrong results with version 3.5. ...
  15. How can we optimize MDX and mondrian performance

    Hi all,
    1). How can we optimize mdx query in such way, that can be executed in less than 5 sec (Even on large data set with many slicer dimensions in slice axis or aggregating or cross joining).
    ...
  16. Replies
    3
    Views
    1,519

    Try to give like ... {[Calendar].[2013].[10].[1]...

    Try to give like ... {[Calendar].[2013].[10].[1] : [Calendar].[2013][10].[31]} .. just remove .Hierarchy
  17. Replies
    5
    Views
    788

    Hi Suresh,, Can you post the exception. My fact...

    Hi Suresh,, Can you post the exception. My fact table is also huge and avg it contains 20k records per day. But working fine for now. Can you check your mondrian properties (results.limit,...
  18. Replies
    5
    Views
    559

    Hi, Can you be more specific, where do you want...

    Hi, Can you be more specific, where do you want to automate. The key word 'automate' looks interesting. Infact i m also trying to automate the application to build dynamic measures and mdx queries.
  19. Hi Matt, I test on 3.5 with the modified query...

    Hi Matt,

    I test on 3.5 with the modified query and system memory configurations. Here I am attaching the results.

    System configuration:
    In Eclipse: Run Configuration as:
    -Xms1024m -Xmx2048m ...
  20. Hi, Here I am attaching the sql log files for...

    Hi, Here I am attaching the sql log files for both versions (3.4 and 3.5) on same schema and mdx.
    I have schema with degenrated dimension as fact_auto_incr_id (transaction_id), which has 25 lakh...
  21. Hi, Thanks for the reply. Here is my...

    Hi, Thanks for the reply.

    Here is my mondrian.properties file options

    mondrian.foodmart.jdbcURL=jdbc:mysql://localhost:3306/StarTest?user=user&password=passwd...
  22. Getting different/wrong results in version 3.5 while correct results in 3.4

    Hi all,
    I m getting correct results when i was worked with schema_workbench 3.4 and using my java code with mondrian.jar. (comapared with sql results). Now i switched to version 3.5, getting worng...
  23. how to make fact-table PK as a dimenstion.

    Hi All, I 've a schema scenario like, one of the transaction_table column (auto-incr PK) as a dimension. Means, I want to trace back to the transaction_table based on the customer_ids tripped in MDX...
  24. Replies
    5
    Views
    1,044

    11902 HI, Thanks for the reply. I have this...

    11902

    HI, Thanks for the reply. I have this schema structure. Now, i want to filter based on country and sales. Something like


    Select Measures.[Something] on Axis(0),
    Filter...
  25. Replies
    0
    Views
    426

    Star and Snow Flake Schema

    Hi,
    I am unable to join 3 tables as described in http://mondrian.pentaho.com/documentation/schema.php#Star_schemas . How to join three tables to be a dimention.
    Lets say,

    factTable
    col1
    ...
  26. Replies
    3
    Views
    685

    Hi Reshma, Can you tell me how you are adding...

    Hi Reshma, Can you tell me how you are adding dimensions to the schema dynamically. I mean, are you building the schema using
    @Override
    public String filter(String schemaUrl, Util.PropertyList...
  27. Replies
    3
    Views
    685

    Hey, I m not sure about your application but this...

    Hey, I m not sure about your application but this link might help you in Cache Control.

    http://julianhyde.blogspot.in/2007/02/mondrian-cache-control.html

    and How you are using...
  28. Replies
    5
    Views
    1,044

    Hi, I m trying to make a new measure in virtual...

    Hi, I m trying to make a new measure in virtual cube with a table present in the parent cube (like we put conditions in measureExpression as [case when condition then value else 0 end]). In my App i...
  29. Replies
    2
    Views
    627

    how can we add new measure in the virtual cube (...

    how can we add new measure in the virtual cube ( like [case when condition then value else 0 end]) ?
  30. can we Add dynamic Measures to the existing schema

    Hi, I am triying to add dynamic measure expression to the existing schema.
    The scenario is like this,
    I have 7 dimensions all are link to the one single measures with different conditions,...
  31. mondrian.rolap.RolapConnection cannot be cast to org.olap4j.OlapWrapper

    Hi, I tried to get the customise Results to get the cell values. Here is the code and got stuck while casting.

    Connection connection;
    ...
  32. if you are using Eclipse, put the...

    if you are using Eclipse, put the log4j.properties file in your worksapce/project/bin/.
    else,
    export TOMCAT_OPTS="-Dlog4j.debug -Dlog4j.configuration=log4j.properties"
    if you want you can,
    Add...
Results 1 to 32 of 32