Highest Voted 'iccube' Questions

3

votes

1 answer

icCube XMLA request documentation

Is there any documentation on how to formulate a request to the XMLA? The icCube XMLA endpoint for me is: http://localhost:8282/icCube/xmla I want to make a demo call to the endpoint using postman or something similar, but I am not sure which…

soap iccube xmla

asked Aug 08 '16 at 17:33

Ryan27

453
4
16

3

votes

1 answer

CREATE SET in Script error - 'is neither a dimension or a hierarchy within the cube'

I'm trying to create a SET in the Script use case of icCube's Schema Manager: CREATE SET [TOP_10_SALES] AS TopCount([BRAND].members - [BRAND].all, 10, [Measures].[Sales]) When I use this set in the reporting, I get the following error…

mdx iccube

asked Jul 06 '16 at 14:42

Christian Welsch

424
2
10

3

votes

1 answer

IcCube - Leaves in Pivot table

If I have a parent-child-dimension, whose data I show in the IcCube/PivotTable and I want to show the leaves only (with descendants([categories].[categories].[All-M],,leaves)), those leaves are shown hierarchically. So a level5 leave of one category…

pivot parent-child iccube

asked Jun 30 '16 at 15:17

UlrichWuenstel

460
2
10

3

votes

1 answer

icCube connecting to Excel 2016

I get the following warning when I open a xlsx spreadsheet, connected to iccube, in Excel 2016. It works in Excel 2013 but not 2016. Excel cannot connect to your database with the driver you specified in your data source. The driver does not…

xmla iccube excel-2016

asked Oct 16 '15 at 14:26

Paul

31
1

3

votes

2 answers

Adding complex measures in MDX

I have successfully added basic sum/count/etc.. simple measures, but have no idea how to add more complex one. Let's assume that data structure represent tracks with goods and have next structure: date id_track id_articte amount cost And want to…

mdx iccube

asked Oct 11 '15 at 10:07

Oleksandr Voytsekhovskyy

176
1
6

3

votes

1 answer

How to go from rows to a hierarchy in icCube

I want to create a one-column hierarchy from multiple columns using mdx. I got this result: from the Sales cube with this mdx: SELECT { {[Measures].[Amount]} } ON COLUMNS, { [Customers].[Geography].firstNotAllLevel().allmembers }*{…

mdx iccube

asked Jun 17 '15 at 15:45

Tom van den Berg

95
6

3

votes

1 answer

format_string in icCube does not format null values

I was trying to display values that are null as 0 using format_string. I currently have the following: WITH MEMBER [test] AS null, FORMAT_STRING = '0.#;Neg (0.#);0.00;0.00' SELECT [test] ON COLUMNS FROM [Sales] The fourth value (;0.00) should…

mdx iccube

asked Jun 05 '15 at 12:45

Tom van den Berg

95
6

3

votes

1 answer

Creating Mongo/mapReduce data source in icCube

I would like to create a MongoDB/mapReduce data source into icCube (http://www.iccube.com/support/documentation/user_guide/schemas_cubes/ds_mongodb.php#mapReduce), The below script works fine from Mongo shell, how it should be formatted to be…

mongodb iccube

asked May 18 '15 at 08:53

Ruzsa Balint

51
1

3

votes

1 answer

Usage of joda.time in icCube

I would like to use the following MDX statement: with member [x] as now()->plusMonths(1)->withDayOfMonth(1)->minusDay(1) select [x] on 0 from sales But I get the error "withDayOfMonth" is unknown. I know the function "plustMonths()" works fine. How…

jodatime iccube

asked May 15 '15 at 13:16

Arthur

1,692
10
14

3

votes

1 answer

icCube cascading Filters with multiple selections

Looking at this, http://www.iccube.com/livedemo/?ic3reportName=I%20want%20a%20BigMac I want to do the same thing but with a multi-selection (Buttons) first filter which would reduce the choices list on a second filter (TreeFilter) Thanks.

filtering iccube iccube-reporting

asked May 13 '15 at 15:14

Bertrand Miot

929
5
12

3

votes

2 answers

Assigning a value to an icCube Event in Reporting

I am using icCube 5.0 Reporting I want to assign the value of an Event to that returned by the icCube MDX function UserName()--sort of like @{eventname} = UserName(). Eventually, @{eventname:reportParm} will be sent to a launched report for use in…

reporting olap iccube

asked Apr 09 '15 at 10:33

Bart

43
5

3

votes

1 answer

python olap.xmla mdx queries returning single value?

I am always getting a single value in MDX query using python. I am connecting to icCube which has xmla support. provider = xmla.XMLAProvider() con = provider.connect(location='conn_str',username='q1',password='q2') cmd="""WITH MEMBER Measures.[Avg…

python olap xmla iccube

asked Apr 03 '15 at 06:29

Animesh Saxena

449
4
11

3

votes

1 answer

Is it possible to re-use schema specific reports on different schemas in iccube?

I have created standard dashboards connected to a single schema. Now I would like to re-use the same dashboards definition on different schemas. These schemas are all equivalent (same dimensions, measures, but different client data). Is this…

security dashboard iccube

asked Feb 19 '15 at 13:58

Arthur

1,692
10
14

3

votes

2 answers

icCube - InterpolateRGBColors based on min & max values?

I understand that InterpolateRGBColors function is returning a color by position of value between 0 and 1... So its seems to be doable only with percentages, not numbers... Is there a way to have the same functionality, but based on the min and max…

colors mdx interpolation iccube

asked Feb 04 '15 at 10:39

Bertrand Miot

929
5
12

3

votes

1 answer

IcCube - AmChart scrollbar drag icons not showing

In IcCube reporting, I added an amchart, in the widget advanced properties, I set the Scrollbar.Hide Resize Grips to "no" in order to show the scroll... The scroll is visible but not the drag icons... if I look in chrome's debugger, I can see that…

amcharts iccube

asked Feb 02 '15 at 10:07

Bertrand Miot

929
5
12

Questions tagged [iccube]