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

MDX - icCube - How to get a DYNAMIC topcount/toppercent with other aggregated?

Using the following mdx, I'm able to retrieve correct data dynamically. create CATEGORY MEMBER [Stats].[Top].[All Etabs].[Top 5 Etablissements] as topcount( [Etablissement].[Etablissement].[Etablissement].allMEMBERS, 5,…
Bertrand Miot
  • 929
  • 5
  • 12
3
votes
2 answers

How to perform a YTD aggregation on data arranged in parent child hierarchies with unary operators?

I am using a parent-child relationship for accounts in the OLAP database icCube. To include financial logic I make use of unary operators. In addition, I have set-up several account hiearchies using the many-2-many relationship and all is working…
Arthur
  • 1,692
  • 10
  • 14
3
votes
1 answer

How to display values in thousands in MDX icCube

How to display the value for a measure in thousands. I would assume to do it as follows: FORMAT_STRING="#,," But the data returns: 10000000.001 while I would expect: 10,000
Arthur
  • 1,692
  • 10
  • 14
3
votes
1 answer

how to rename drill-through columns in icCube?

Is it possible in icCube to name the columns returned from a drillthrough statement. Now they are just technical names and it is not end-user friendly?
Arthur
  • 1,692
  • 10
  • 14
3
votes
1 answer

iccube: how to define hierarchy dimension with intermediate table

I am newbie, and can't find how to define dimension for such structure: invoices: -------- id id_company date invoices_data: ------------- id id_invoice id_product amount price companies: ---------- id caption How to define companies dimension…
Oleksandr Voytsekhovskyy
  • 176
  • 1
  • 6
3
votes
1 answer

icCube with olap4php

We started to build a PHP application to connect to icCube and I want an example for olap4php, because I couldn't find it anywhere in the icCube documentation. In particular, I need the Provider to use in building connection object to icCube. //…
user3086436
  • 41
  • 1
3
votes
1 answer

Is there a better way to calculate the moving average in an MDX in iccube?

I'm using the following calculated member to calculate the moving average for my visits for the last 30 days period; is there a shorter way to do this? WITH MEMBER [Measures].[Visits Moving Avg] AS AVG( [TIME].[Time].Prevmember :…
Aron
  • 73
  • 6
3
votes
1 answer

MDX: Showing a zero count for non-existing members

I'm still a newbie at MDX, so maybe this will be a simple question. I want to do something like see sales revenue by product: more specifically, products are classified in "classes" (where class can be A,B or C), so I want to see the amount of sales…
Pedro
  • 105
  • 5
3
votes
1 answer

icCube Schema Refresh Time

I'm using icCube Web reports and I'd like to display the refresh time of the cube but could not find how to do it. I guess there's a way using a dedicated MDX statement but could not find any reference in the documentation. Any idea how to do it?
Mathias Philippe
  • 145
  • 5
2
votes
1 answer

MDX - calculating distinct count on date range

i've got a cube (multidimensional) with [Person], [Arrival Date] and [Departure Date] dimensions, [Measures].[persons #D] - distinct count of [Person], and fact table containing dates of person's departures and arrivals. I need to calculate distinct…
megalap
  • 21
  • 1
2
votes
1 answer

How can you provide translations (localization) for attributes and properties in the icCube schema definition?

In the icCube - Builder, defining a database schema: How can you provide localizations for attribute members and properties of members in the Schema Builder. When generating a template, these are excluded in the download file?
Arthur
  • 1,692
  • 10
  • 14
2
votes
1 answer

IcCube Reporting V8 - possible to use Gantt chart?

Using IcCube Reporting V7, I was able to create AmCharts Gantt charts as following : Using following mdx behind the scene : with member HDebut as [Measures].[Bloc Début Intervalle], format_string = "hh:mm" member HFin as [Measures].[Bloc Fin…
Bertrand Miot
  • 929
  • 5
  • 12
2
votes
1 answer

IcCube Excel Xmla opens one session (connection) per PivotTable

We have produced some Excel files using Xmla Pivot Tables against Iccube schemas. Everything is working well except the fact that we noticed : Each Pivot Table on a single file (even single worksheet tab) triggers a connection to the server. Thus,…
Bertrand Miot
  • 929
  • 5
  • 12
2
votes
2 answers

MDX Get a TopCount over multiple dimensions and add a rest/remainder (icCube)

I would like to create a TopCount over multiple dimensions, and include a "rest"/"remainder" and a sub-total. I use the following MDX on the default Sales schema in icCube: with member [Product].[Product].[All Products].[rest] as "All…
Arthur
  • 1,692
  • 10
  • 14
2
votes
1 answer

icCube - How to create Excel compatible thousands formatting?

I have an icCube report where I want "1500000" to be formatted as "1,500K". If I set FORMAT_STRING="#,##0\K,", the formatting works in icCube but not in the exported Excel sheet. If I set FORMAT_STRING="#,##0,\K", the formatting works in the…
Joel Doe
  • 41
  • 3
1 2 3
…
22 23