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
2
votes
1 answer

how to define Root member with PARENT_ID = NULL or PARENT_ID = ID for Parent/Child Dimenssion

I am getting an error [BUILDER_UNEXPECTED_ERROR] Parent/Child View 'Dim_Parent_Child' without a single root member, at least one root member is mandatory. A Root member is defined with PARENT_ID = NULL or PARENT_ID = ID. location: Please suggest…
Ajay A
  • 59
  • 2
2
votes
0 answers

Hide default member of Utility dimension in icCube

Is it possible to hide default member of Utility dimension, since I do not want to see it when I use the dimension in Excel pivot table. I have tried to hide it in default perspective but then I am getting an error that default member is…
vldmrrdjcc
  • 2,082
  • 5
  • 22
  • 41
2
votes
1 answer

MDX drill intermediate level in iccube

Working with IcCube 6.8, I Have a Hierarchy called [Pole_UM_UF_PH].[Pole_UM_UF (PH)] with 4 levels as following : Pole Structure UM UF Using MDX, I want to show only Poles and their UM (possibly the ALL-M on TOP, but not the Structure nor UF) I…
Bertrand Miot
  • 929
  • 5
  • 12
2
votes
1 answer

IcCube schema load speed optimization

When I load big tables into an IcCube schema, the number of lines being fetched per second differs strongly between different tables from the same database. Unfortunately I have no idea, how to optimize this, since I don't know, what this speed…
UlrichWuenstel
  • 460
  • 2
  • 10
2
votes
1 answer

Overlapping Label in IcCube Reporting

I have a problem with overlapping labels in a bar charts. The settings in the Axis label appear to be correct, because others settings do affect the rendering (bold, etc..) but spacing does not seem to be taken into account. Any way to do a proper…
Nicolas Modrzyk
  • 13,961
  • 2
  • 36
  • 40
2
votes
0 answers

icCube & dynamic hierarchies that show its structure depending on TIME

I would like to display a parent/child hierarchy (e.g. Costcenter) for a specific period in time. The business case, is that the organizational structure in the Costcenter changes over time and the end-users would like to see the historical data…
Arthur
  • 1,692
  • 10
  • 14
2
votes
1 answer

icCube ETL - Java View - group by on more than 1 column + retrieve max and min value

In the icCube Builder ETL, I want to group the data on more than one field. Also, as aggregation function, I would like to make use of MAX and MIN. Example data: (same data in text) groupId phase startDate endDate 100 start 1-May-2018 …
Arthur
  • 1,692
  • 10
  • 14
2
votes
1 answer

MDX : get members from a subselect (FILTER BY in MDX+)

I've got the following MDX statement: WITH MEMBER [Measures].[ist] AS __get_time_member__ SELECT // Measures {[Measures].[ist],[Measures].[soll]} ON 0, // Rows FROM [Finance] FROM ( SELECT [Time].[Time].[month].&[2018-04-01] on 0 from…
Arthur
  • 1,692
  • 10
  • 14
2
votes
1 answer

Solving indirect relations / many-to-many tables : How to solve this in icCube?

I need to create a subdimension in icCube, for example: I have two dimensions, the dimension Student and the dimension Localization. The dimension Student has a foreign key from Localization dimension and the fact table join with student…
EDUARDO CERON
  • 31
  • 2
2
votes
1 answer

Is there a way to enter data at non-leaf levels in iccube?

I'm looking to evaluate iccube as an embedded OLAP server. Before doing so, is it possible to enter data at non-leaf levels? If not natively, is there a workaround? This is one of the major requirements. Also, what are the different methods to…
Gerd Pranoto
  • 21
  • 1
2
votes
1 answer

Generating range of months using multi-level hierarchies

I want to filter the months of [ComptaEcriture Date] by selecting only the months from [ComptaPlanId].[ComptaDateDebut] to [ComptaPlanId].[ComptaDateFin], but since [ComptaDateDebut] and [ComptaDateFin] are not from the same level and bot are not…
Joker
  • 67
  • 4
2
votes
1 answer

How to use FORMATTED_VALUE in a cumulated graph?

At first, from the Data Render panel in icCube report, I used context.cumulativeCol(); in the Value field in order to create my cumulated graph. Now, since the format of my data is not well suited for my application (I have values such as…
Joker
  • 67
  • 4
2
votes
1 answer

how can you check the data type of a MDX Measure in icCube?

I am using a project-to-date calculated member in a STATS dimension that aggregates the data. But I am also using string measures (e.g. to display some text). Now, the string measures show an error when using the PTD view: "Aggregation SUM is not…
Arthur
  • 1,692
  • 10
  • 14
2
votes
3 answers

How are OLAP-cube operations and MDX related?

I would like to understand how OLAP-cube operations (i.e. drilling up/down, slicing/dicing and pivoting) and MDX are related. My current guess is that OLAP-cube operations to MDX are like relational algebra to SQL. However, I do not see how some…
AlwaysLearning
  • 7,257
  • 4
  • 33
  • 68
2
votes
1 answer

calculate the cumulative % of a hierarchy member in icCube | TopPercent but than different

With the function TopPerent, you can get the set of members - ordered top down - that comply to the % value provided. I would like to switch this function and get the cumulative % given the member. Description of the image: TopPercent in icCube,…
Arthur
  • 1,692
  • 10
  • 14
1 2 3
…
22 23