XML for Analysis (XML/A) format of member names?
The meaning of unique names in MDX is a string that guarantees that it defines a unique MDX entity when parsed. There is no possible collision with another MDX entity. The way to write it depends on the XMLA provider. Even though it's 'unique' there are multiple ways creating it,...
icCube - InterpolateRGBColors based on min & max values?
colors,mdx,interpolation,iccube
InterpolateRGBColors expect a numerical between 0 and 1 for interpolation. So we need to scale our measure to ensure we get the right colors. There is an example in our live demo , here. What we need is to scale [Measures].[NbSejours] between 0,1. There are two no documented function in...
icCube cascading Filters with multiple selections
filtering,iccube,iccube-reporting
In that report's case if the first filter is a multi-select one, you have to add this mdx in the second's Query Wizard: Descendants(@{category}). UPDATE: If you want to return just the first level children, you have to add a parameter for the level, like this: Descendants(@{category}, 1). Without the...
Configuring stop times for scheduler
There is currently no way to configure the internal scheduler like that. Nevertheless, for custom scheduling, you can use a cron and external icCube commands related to schema management (www). The error does not seem to be related to a missing data source. Please contact icCube directly to troubleshoot that...
drill down on reversed hierarchy gives incorrect results
Short answer. Sorry, the current version of iccube's pivot table is not supporting the post flag....
How to go from rows to a hierarchy in icCube
Using standard MDX you can't solve the problem as you can not navigate across hierarchies on a single MDX statement. What we're looking for is to define our own hierarchy for navigation. Using icCube you've two different ways : 1) You can use Categories to define at will a new...
Javascript synchronous request to icCube
javascript,iccube,iccube-reporting
As icCube is using jQuery here is a possible solution using the when/done feature of jQuery. var res1_done = $.Deferred(); var res2_done = $.Deferred(); var res2_done = $.Deferred(); var res1, res2, res3; function onAllResultDone() { // handle here your results (res1/res2/res3) } $.when( res1_done, res2_done, res3_done ).done(function() { onAllResultDone(); });...
Can't edit scheduler in 4.8.2
This is unfortunately a regression (missing UI icons). You can follow this issue - this should be fixed in the upcoming 4.8.3 version. In the meantime your workaround is correct.
How to perform a YTD aggregation on data arranged in parent child hierarchies with unary operators?
parent-child,mdx,cumulative-sum,iccube
The current version of icCube - 4.8.2 - does not support the Aggregate function for measures with Aggregation type 'unary operator'. See Aggregation function doc here. The Aggregate function is a bit dodgy if you're using many-2-many relations as well as special measure aggregation types. For example : Aggregate( {...
IcCube - AmChart scrollbar drag icons not showing
The path to images was not set in the icCube's amChart integration. Will be fixed in the next release....
Connect icCube with Reshift
A first solution is using the Postgres jdbc driver. Redshift is based on Postgres so it also works (for how long is a good question). The second is a bit more complicated as you need to add Reshift jdbc driver to icCube. First download jdbc driver from amazon from here,...
format_string in icCube does not format null values
It is a bug (ic3pub_159) that is going to be fixed in the next version. As a workaround you can use the coalesceEmpty MDX function. CoalesceEmpty( [MyValue] , 0.0 ) ...
How do you format Web Reporting pivot table data?
For formatting cells you've two different options : 1) You can use MDX (this includes float formatting & colors). See FORMAT_STRING and Cell Properties for all options ( CLASSNAME example is worth checking ). 2) You can also define in the reporting : Widget / Columns / Cell Renderer /...
Usage of joda.time in icCube
Unfortunately, now() is creating an internal date/time object that do not support yet all the JODA methods (we'll add them in the next release). In the meantime, here are several way to compute the end of month: with // Be aware it is the server's end of month not the...
How to suppress missing rows in a pivottable drill down action
This issue has been solved in 5.1. I was not looking in the right direction. To enforce a non empty drilldown on children do the following: open the widget select the tab Navigation select drilldown strategy mdxExpression and for the MDX expression type: non empty $member.children And voila, you only...
MongoDB - The argument to $size must be an Array, but was of type: EOO
mongodb,aggregation-framework,iccube
You can use the $ifNull operator here. It seems the field is either not an array or not present by the given error: { "$project": { "people": 1, "Count": { "$size": { "$ifNull": [ "$myFieldArray", [] ] } ] }} Also you might want to check for the $type in...