Stack Overflow
Stack Overflow

Questions tagged [iccube]

A JAVA in-memory OLAP/MDX server coupled with a modern Web/Tablet Reporting Javascript solution.

icCube is a Java in-memory OLAP/MDX server coupled with a Web/Tablet Reporting JavaScript solution.

340 questions
77
votes
3 answers

MongoDB - The argument to $size must be an Array, but was of type: EOO / missing

Trying to create a MongoDB data source with icCube. The idea is to return the size of an array as a new field. Something like : $project: { "people": 1, "Count myFieldArray" : {$size : "$myFieldArray" } } But I'm getting for some records the…
ic3
  • 7,917
  • 14
  • 67
  • 115
6
votes
2 answers

MDX: Filtering and slicing on different members of the same dimension

I am using icCube's Sales cube to learn MDX. I would like to write an MDX query to show the revenue from sales in 2009 for those countries where the revenue from sales in 2010 was over $80,000. I tried the following, but it returned an empty table…
AlwaysLearning
  • 7,257
  • 4
  • 33
  • 68
5
votes
1 answer

MDX: count number of members selected in filter

I have one dimension that I want to put into filter, and created calculated member that should dynamically show number of selected members from the dimension. The dimension does not have an All member. So this is my attempt with member…
vldmrrdjcc
  • 2,082
  • 5
  • 22
  • 41
5
votes
2 answers

MDX Query to find the last ever non empty value in icCube

Following the post from Chris Web I am looking for a fast way to find the last buy from a customer. I use an MDX statement like the following: WITH FUNCTION previous_buys() AS tail( nonempty({NULL:[Time].[Time].currentmember.prevmember}…
Arthur
  • 1,692
  • 10
  • 14
5
votes
1 answer

MDX - large crossjoin with nonempty - how to optimize performance

I have built a model in icCube on top of a General Ledger codeblock, which has the following dimensions (not limitative): Time Entity Cost center Account Intercompany party Project Activity Amount (this is the value) With this model loaded in a…
Arthur
  • 1,692
  • 10
  • 14
4
votes
1 answer

The purpose of NON_EMPTY_BEHAVIOR

I need the clarification about the meaning and purpose of NON_EMPTY_BEHAVIOR when defining calculated member. As I understood so far the purpose of NON_EMPTY_BEHAVIOR is to tell icCube that if NON_EMPTY_BEHAVIOR measure is null then entire…
vldmrrdjcc
  • 2,082
  • 5
  • 22
  • 41
4
votes
3 answers

MDX: Filter a Dimension on its properties

I want to filter a dimension on its properties. My Dimension consists of various categories with parent Leaf-categories. Each Category has an online status (true or false). Within the dimension I define the property "is_online". Now I want to…
David
  • 41
  • 1
  • 3
4
votes
3 answers

icCube - set serie color for 2 dimensions in the columns in a amCharts combo chart

I have got the following dynamic chart (see attached picture). For the sake of reproducability I have created a very simple chart based on the standard icCube's sales model. The idea is to have two facts on the column axes with the data for the…
Arthur
  • 1,692
  • 10
  • 14
4
votes
0 answers

Connect to icCube server through Pentaho

I want to fetch data from icCube olap server with Pentaho (5.2.0.0), to create a report. I created a new Data Source with the Data Source Wizard: And when clicking on 'Next' button to get the Schemas I got the following error: In the icCube logs I…
István
  • 5,057
  • 10
  • 38
  • 67
4
votes
1 answer

How do I create custom rollup types in icCube?

How do I create custom rollup types in icCube? Say, I need WAvg (which is already implemplemented there) instead of plain Avg function. But I it is not on the dropdown list in measure creation form. What should I do now?
Alexander Egurnov
  • 177
  • 1
  • 2
  • 9
3
votes
1 answer

How to Autogenerate the cube and dimension design from the Builder Schema file in icCube?

I want to document the model design in the Builder in icCube. Initially it will not be too much work to document it using MS Visio or something similar, but I foresee the issues when the model will get changed over time with designs not matching the…
Arthur
  • 1,692
  • 10
  • 14
3
votes
2 answers

how to avoid the error "Category member XXX defined as an empty set" in icCube?

I've got the following MDX code to create a category dimension with 4 members: all members that make up of 0-50% of the measure (TopPercent) members 50-80% members 80-95% members 95-100% The code works perfectly on levels with a lot of…
Arthur
  • 1,692
  • 10
  • 14
3
votes
3 answers

Getting results for even years only

MDX has a nice feature whereby I can specify a range of members: SELECT ([Canada],[2006]:[2011]) on Rows, [Measures].members on Columns FROM [Sales] Is there a way to calculate the set of even years: {[2006], [2008], [2010]}? I am looking for…
AlwaysLearning
  • 7,257
  • 4
  • 33
  • 68
3
votes
1 answer

icCube - developing a java plugin for ODATA, how to debug the server connection?

We are developing a java plugin to make an Odata feed available as a data source using Olingo. There are authorization issues for the specific data provider we want to connect to, but we can not get into the tiny details to debug what is going wrong…
Arthur
  • 1,692
  • 10
  • 14
3
votes
1 answer

Error on building a model "no member found for key ... but dimension has an "Unknown member" (icCube)

Not sure if I am doing something wrong. But in the BUILDER I defined a dimension with the "Unknown Member" field set to 'Unknown'. The facts table - based on an in memory file - has some empty values for the key that is used. Now I expect icCube to…
Arthur
  • 1,692
  • 10
  • 14
1
2 3
…
22 23