olap4j

Gayathri
2014-01-29
2014-02-06
  • Gayathri
    Gayathri
    2014-01-29

    I am doing association rule mining on DataCubes. Right now i established the connection to SQLserver2008 and getting the MDX results.
    Now i want to understand that how do i get the column values as string from the cellset. May i get more sample programs on how to use the cellsetaxis, preparedolapstatment and etc

     
  • Gayathri
    Gayathri
    2014-01-29

    Yes, I got from Julian Hyde, SimpleQuerySample.java

     
  • Gayathri
    Gayathri
    2014-01-29

    with small queries, it is fine.
    select {([Measures].[Fact Climate Count])} on columns,
    order( filter(
    {nonempty([Dim Humy].[Hum Key].[Hum Key].Members

    [Dim Tempe].[Temp Key].[Temp Key].members

    [Dim Rain].[Rain Key].[Rain Key].members)},
    ([Measures].[Fact Climate Count]>50))
    ,([Measures].[Fact Climate Count]),BDESC)
    on rows from weather

    I want to collect the cross joined row values from [Hum Key],[Temp Key],[Rain Key] as the itemset.[3, 4, 1],[4,2,1]....Can someone help me to get this crossjoined values.

     
  • Can you post the output of org.olap4j.layout.RectangularCellSetFormatter and org.olap4j.layout.TraditionalCellSetFormatter format for us to check the result I think this classes will show what you need. But I'm curious to understand the output of your MDX. I'm researching to convert CellSet to be used with RESTfull requests.