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
3
votes
1 answer
iccube : how to count number of members with where clause in a mdx?
Using the following mdx, the result is the same if I run it with or without the where clause : It returns the total nbr of years in the hierarchy.
with member nbYears as [Time].[Year].[Year].count
select nbYears on 0
from [Sales]
where…
Bertrand Miot
- 929
- 5
- 12
3
votes
1 answer
Is it possible to create a hierarchy (drill-down structure) based on other flat hierarchies in icCube?
I would like to build hierarchies with as much as depth possible to offer users "navigation paths" to their data.
Often, I am blocked as the metadata can not be properly placed into multilevel hierarchies due to source data constraints. Or if I…
Arthur
- 1,692
- 10
- 14
3
votes
1 answer
Using R in icCube MDX+, how to pass and retreive an array?
you can use R functions in icCube as demoed on https://www.iccube.com/support/documentation/mdx_integration/r_integration.php
I need to invoke a more complex custom R script that does a calculation on a matrix that I want to provide. The result…
Arthur
- 1,692
- 10
- 14
3
votes
1 answer
Calculating Percentile in MDX
Does icCube provide any function that can be used for creating calculated members with aggregated percentile, like Median or 95th percentile?
Vejsil Hrustić
- 179
- 1
- 7
3
votes
1 answer
How to retrieve cell data from different table then current widget in icCube
In icCube reporting tool 6.1
is there a possibility to retrieve data like a cellValue(rowindex,columnindex) while i'm in a diffrent widget like chart box for example and wanna get a cell value from different table in the report? with Widget's…
Itay Regev
- 191
- 8
3
votes
2 answers
IcCube reporting preselected dates in date slicer
what can i put in the 'Preselection from' label to get the beginning of current month?
Itay Regev
- 191
- 8
3
votes
1 answer
icCube - function calling another function results in NULL
Below the MDX statement on icCube. (Note that icCube has a non-native language component, called function).
with function article_list() as topcount([Product].[Product].[Article], [amount], 10)
function benchmark_best_index2(i) as…
Arthur
- 1,692
- 10
- 14
3
votes
0 answers
Access to font blocked by CORS policy
I want to display icCube report in my app which is runing on Wildfly server with Angular 1.5 as frontend framework.
Report is displayed using Javascript code snippet from official docs, but I get few errors related to CORS policy, e.g.:
Access to…
Vejsil Hrustić
- 179
- 1
- 7
3
votes
0 answers
Displaying report - ic3ready is not defined
I work on displaying a IcCube report in a web application that runs on a server.
This is a code snippet we use:
mbelmin
- 113
- 1
- 6
3
votes
1 answer
How to fireRowClick in iccube 6
I'm trying to fire auto click on first row for a 'table' After Render. in icCube 6 (3961)
but when i use
function(context, data, $box) {
context.fireRowClick(0)
}
i get error
context.fireRowClick is not a function
Itay Regev
- 191
- 8
3
votes
1 answer
ICCube reporting Google maps setup
How to configure icCube so it can show Google maps widget. I can not find the guide in documentation, nor the option in the application itself.. I am familiar with using google maps api with for example JS, but how to do it in icCube? Some help…
ah123
- 73
- 3
3
votes
1 answer
How to create a link inside a table in Iccube 6 Reporting?
is it possible to generate a link in a table in Iccube reporting 6?
I want to have a clickable link in a table that url is generated by a value in the table row.
Thanks
user2520673
- 118
- 4
3
votes
1 answer
How to create a Combo Chart in iccube Reporting 6?
There is the possibility to select a google combo chart in the new iccube 6 reporting. But I am not able to add one bar chart with a line series.
Has anybody got this working?
user2520673
- 118
- 4
3
votes
1 answer
How can I add empty space at the bottom and right of an icCube report?
Is there a way to add empty space at the bottom and right of a report? I could add an empty text box in the bottom right corner, but I'd like to avoid that.
Christian Welsch
- 424
- 2
- 10
3
votes
1 answer
porting multidimensional SSAS to ICCube. Scope() equivalent? other gaps/issues?
Has anybody ever ported a complex ssas multidmensional cube to iccube? and have any advice to offer on lessons learnt/gaps between the two tools etc?
The major one i can see is scope(). What's the equivalent in iccube? nested if/case statements?
I…
jkmelbs
- 444
- 5
- 14