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.
Questions tagged [iccube]
340 questions
2
votes
1 answer
icCube : Geo Chart limiting region not working
Specifying the "Region" in a Google Geo Chart does not limit the map to the given region but instead is generating an error about the requested map not existing. I'd like to limit the map to the Europe region.
pinkpanther
- 139
- 6
2
votes
1 answer
icCube Reporting : Cannot save Report with accent
When saving a report with accent "Dépenses", the generated filename is having some weird ? characters and then the report cannot be opened/deleted. Neither from the reporting nor from the Docs application.
pinkpanther
- 139
- 6
2
votes
1 answer
Discovering tables on an Oracle Database return an empty list
When creating a connection to an Oracle database in icCube 'Select existing DB Tables' is returning an empty list of tables.
The connection is fine and I can query the schema creating SQL queries.
ic3
- 7,917
- 14
- 67
- 115
2
votes
1 answer
icCube gauge with multiple band colors
I'm trying to make a gauge and want to have two band colors (wrong/red, good/green). I've an example of the amchart in their online Chart maker https://live.amcharts.com/new/edit/. But I'm not able to get this working in icCube.
current we have…
Niels
- 131
- 5
2
votes
1 answer
load data on the all member in icCube
The all member in a dimension in icCube has no key.
But for a specific case I need to load data on this level.
How can I do that?
Note: if I have a NULL value, the 'unknown member' property is fired, and I do not want that.
Arthur
- 1,692
- 10
- 14
2
votes
1 answer
Is it possible to have multiple Keycloak realmsconnect to the same icCube server?
use case
in icCube
one server instance
icCube users only need to access the reporting
icCube is used to for a standard reporting solution for an industry vertical and can be used by multiple clients, each having their own (copy of the) structures…
Arthur
- 1,692
- 10
- 14
2
votes
1 answer
icCube Reporting - Labels using Events: Formatting and Syntax
What is the correct syntax for using the event variable within the label boxes (e.g Header Title).
Having a defined event (e.g. Test), what are the possible use?
What is the meaning of the following expression?
@{Test:'Alternate Text'!} @{Test}
Are…
Luca Ligios
- 71
- 2
2
votes
1 answer
Drillthrough to underlying text data in icCube?
How to set-up a model in icCube to allow to drill down to the details, when details contain text fields?
The idea is to get a list, with column names containing the text fields (in combination with amount fields). Just like a simple SQL statement…
Arthur
- 1,692
- 10
- 14
2
votes
1 answer
How do you specify an icCube permission to deny access to all members of a dimension but allows access to one?
I trying to set a permission for a user such that this user can only access a specific value of a dimension, other values are denied on this dimension.
Tried this but does not seem to work
:schema [Sales]
-tuples DC { [Countries].members}
+tuples DC…
mpjw
- 21
- 1
2
votes
1 answer
Automatic backup/restore at start server
I would like an automatic backup of a schema to a file on every load and at a restart of icCube an automatic restore of the last backup. And of course an automatic cleanup of those files. This way we would have a lot less downtime on a restart.
It…
Remco
- 69
- 3
2
votes
1 answer
Memory leaks icCube 6.8.5
After a few days we experience severe memory leaks that effectively halts our icCube server. We have only 4 schemas with estimated memory usage of 1551MB, 878MB, 1017KB and 1284MB. We have 72GB physical memory. The last memory message in the log…
Remco
- 69
- 3
2
votes
1 answer
Dimension default members not getting displayed in MDX Filters on Reporting tool
We have a Cube where we got a dimension called - "Report Currency". Default member is set as - [Report Currency].&[0].
Now if I create a filter of "Report Currency" on MS Excel based on the cube, I get to see 5 currencies (EUR/GBP/JPY/USD/CHF). But…
Somdeb
- 21
- 1
2
votes
1 answer
How does Sum Square aggregation work and how to use it for the calculation of the Standard Deviation in icCube
One of the aggregation types in icCube is "Sum Square".
I thought it would calculate the sum of squares as defined in the link, but I get different results.
What exactly is the Sum Square aggregation and how can I use it to calculate the standard…
Arthur
- 1,692
- 10
- 14
2
votes
1 answer
How do I connect to iccube using Snowflake?
after copying the latest version of the Snowflake driver in to the lib folder of iccube, starting the server and then performing the following:
Schema create - Wizard (Dimensions/Measures -> Table)
Relational Database
Connection…
Graham Middleton
- 21
- 1
2
votes
1 answer
how to add custom dimensions in existing icCube schema file
I need to add custom dimensions in existing icCube schema file. not sure how to do that using REST API.
Please give me example code.
Ajay A
- 59
- 2