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

How to create pop-up widgets and filters in icCube Reporting version 6.5?

How to create menu’s & filters that appear and disappear by pressing a button? The icCube 5.x demo showed how to have widgets appear and disappear on a button click. This technique has been used by me in project dashboards (see image). How could the…
Arthur
  • 1,692
  • 10
  • 14
0
votes
1 answer

How to connect icCube to mysql?

I just installed icCube and I would like to connect to a local mysql datasource and trying some reporting. I can't find explanations in the doc. A starting point would be enough
Glasnhost
  • 1,023
  • 14
  • 34
0
votes
1 answer

Using a set in the filter condition

I am trying the following query on the demo Sales cube of icCube: WITH SET [Amer.Countries] AS Descendants([North America],[Country]) SELECT Filter([Amer.Countries],([Measures].[Amount], {[2009], [2010]}) > 13240) on Rows, …
AlwaysLearning
  • 7,257
  • 4
  • 33
  • 68
0
votes
1 answer

icCube: multiple dimensions in MDX output

The documentation of icCube states: However, a SELECT is not limited to two axes. We could have columns, rows, pages, chapters, and sections. And you could still continue beyond these by specifying a number for the axis. Indeed, when I try…
AlwaysLearning
  • 7,257
  • 4
  • 33
  • 68
0
votes
1 answer

Why does icCube require Data Table for a time dimension

The documentation states (the words in brackets are mine): [A time wizard dimension] allows us to define/generate a time dimension without any underlying data table. The accompanying image in the documentation does not show a field for entering…
AlwaysLearning
  • 7,257
  • 4
  • 33
  • 68
0
votes
0 answers

IcCube returning null for currentmember.lag(1) when other dimension attribute is used in slicer

I'm trying to create a measure that holds the prior period value Normally what you do is: WITH Member Measures.PrevAmt AS ([Time].[Calendar].CurrentMember.Lag(1),Measures.Amount) SELECT {Measures.Amount,MEasures.PRevAmt} on…
jkmelbs
  • 444
  • 5
  • 14
0
votes
1 answer

IcCube - accessing Report Code with Javascript

When I am editing a report, I can click on "Report Code" to see information about the report structure. It loks like this: { "classID": "ic3.ReportGuts", "guts_": { "ic3Version": 12, "schemaName": "test_schema", "cubeName": "Cube", …
UlrichWuenstel
  • 460
  • 2
  • 10
0
votes
1 answer

Append table via jQuery

I am trying to automatically add a table to a report after the end of the loading process. I tried that using the jQuery .append() Method on the report (context.$report): function consumeEvent( context, event ) { …
UlrichWuenstel
  • 460
  • 2
  • 10
0
votes
1 answer

Link multiple times to a dimension

I would like to link multiple times to the same dimension without making a copy of the dimension. I understand that other products have such a feature (role-playing dimensions) but I can't find such functionality in icCube. Is it really not…
Remco
  • 69
  • 3
0
votes
1 answer

Filter Set by another Set

I want to filter a set by another set, which is returned by the event @{date}. The following code only works if the @{date} event returns a single member (e.g. [TIME_DIMENSION].[YEAR].[2010]). Any suggestions how to filter if the event returns more…
Christian Welsch
  • 424
  • 2
  • 10
0
votes
0 answers

IcCube - accessing a chart at runtime

We would like to write a piece of (javascript-)code, that automatically runs in every report and that manipulates all of our charts. Doing so we would like to add tooltips with descriptions of our measures and dimensions and rename some of the…
UlrichWuenstel
  • 460
  • 2
  • 10
0
votes
1 answer

Invalid operation: relation "fs_fsentry" already exists;

I have an icCube setup, icCubeRepository.xml, to use Postgres as JCR repository. When starting icCube I get the following error java.sql.SQLException: Amazon Invalid operation: relation "fs_fsentry" already exists; Looks as the driver used in the…
Prabesh Shrestha
  • 2,732
  • 4
  • 29
  • 44
0
votes
1 answer

IcCube - How can I Make The Histogram (AMCHARTS/ Serial) Hidden

my report contain a PieChar and a Histogram , at first i'm need that just The PieChart is shown and the Histogram is hidden, what i'm need is when I click on the pieChart the Histogram must be shown. I change Behavior-> "Pop-up" but it's still…
Baini.Marouane
  • 579
  • 2
  • 8
  • 18
0
votes
2 answers

How can I put the differents functions of the script together in the same html page?

I want to use the DIV to display my report, so i see the icCube documentation icCube Web Reporting : Displaying a Report but when i try to apply it i'm confused about how can I putting the differents functions of the script to gather in the same…
Baini.Marouane
  • 579
  • 2
  • 8
  • 18
0
votes
0 answers

icCube - MDX - Putting The Two Dates Of The DateRangePicker ( Start Date , End Date ) In the PieChart Columns

When I apply a filter by (Start date, End date ) using DateRangePicker on the PieChart, I need to export it to Excel , so it's important to export including those two dates. I hope that any one help me to find a solution for this problem. Txs,…
Baini.Marouane
  • 579
  • 2
  • 8
  • 18
1 2 3
22
23