Stack Overflow
Stack Overflow

Questions tagged [activepivot]

ActivePivot™ from ActiveViam is an in-memory analytics solution that provides real-time OLAP capabilities through its transactional engine and multi-threaded processing.

ActivePivot™ from ActiveViam is an in-memory analytics solution that provides real-time OLAP capabilities through its transactional engine and multi-threaded processing. ActivePivot is an easily extendible Java software that can be queried by the standard XMLA / MDX protocols while being accessible via web services, Microsoft Excel or ActiveViam's own web client, ActiveUI.

More information can be found at https://www.activeviam.com

78 questions
12
votes
2 answers

How does NUMA architecture affect the performance of ActivePivot?

We are migrating an ActivePivot application to a new server (4 sockets Intel Xeon, 512GB of memory). After deploying we launched our application benchmark (that's a mix of large OLAP queries concurrent to real-time transactions). The measured…
Jack
  • 145
  • 1
  • 1
  • 11
5
votes
2 answers

High performance pivot grid for pre-aggregated data

I have been tasked with coming up with a high performance front-end for a live ActivePivot back-end. I already have a client-side service layer that provides a continuous stream (IObservable) of pre-aggregated, pre-formatted data, as well as…
Kent Boogaart
  • 175,602
  • 35
  • 392
  • 393
4
votes
2 answers

SUM of dynamic Columns in PIVOT table in SQL Server

I have a Dynamic PIVOT query in which Columns are dynamically generated. My table: ATTENDANCE_MASTER Contains: ID, Stud_id, ATT_DATE, PRESENT which stores data like: ID Stud_id ATT_DATE PRESENT 1 1 2015-08-1 1 2 2 2015-08-1 …
QuaBizIT
  • 67
  • 1
  • 1
  • 8
3
votes
2 answers

ActivePivot retrieve CSV output by sending MDX query through python?

How can I retrieve CSV output file by sending MDX query to ActivePivot by using python? Instead of XMLA or Web Services.
Valee
  • 43
  • 5
3
votes
1 answer

Rendering ActivePivot in a web page

I would like to retrieve data from activePivot's cube by sending MDX with Rest request. I tried to do it and I retrieved a json object then I parsed this json object to retrieve just specific information (look to the picture). I had a look on this…
steky
  • 101
  • 3
  • 11
3
votes
2 answers

Prevent custom aggregated object from being serialized and send to ActivePivot Live

We are aggregating some large matrices and have a custom Matrix class. These are aggregated with a custom aggregation function. A formatter takes care of showing part of the aggregated matrix measure for debugging, but it seems that even with a…
Anders Blaagaard
  • 145
  • 6
3
votes
1 answer

Distributed Cubes in the same JVM

A quick question on distributed cubes. I've seen them suggested as the solution to several questions here (Such as this) and I'm curious if it's possible to run two or more polymorphic distributed cubes within the same JVM - so a single ActivePivot…
obrienk
  • 481
  • 5
  • 10
3
votes
3 answers

ActivePivot testing strategy

I was thinking of implementing automated tests for different part of an ActivePivot Servers and most importantly post-processors. Since I am at the very beginning, I would like to know more about the state of the art in this field, what are the best…
Ashock
  • 29
  • 2
3
votes
1 answer

How do we make the post processor measure not show data when mandatory dimensions are not selected?

We do not want the post processor to execute when certain mandatory dimensions are not selected. For example, We have dimensions called risk type, sensi curve, maturity, currency1 and display currency. We also have post processing measure called…
Josh Lambert
  • 115
  • 1
  • 5
3
votes
2 answers

ActivePivot leaf level aggregation and Analysis dimension

lets say I have an ActivePivot cube with facts containing just Value, and Currency. lets say my cube has Currency as a regular dimension. We fill the cube with facts that have many currencies. We have a forex service that takes the currency and…
Hamid
  • 43
  • 5
3
votes
2 answers

When configuring a relational store join, can I do a one-to-many join from the ActivePivot store?

Using Relational Stores, is it possible to do a one-to-many join from the ActivePivot store to a joining store. Suppose my ActivePivot store joins to another store on SOME_ID, but the key for the other store is SOME_ID,SOME_TYPE. Then it is possible…
doc
  • 765
  • 1
  • 6
  • 24
2
votes
1 answer

How to load MongoDB data source to ActivePivot cube?

How to load MongoDB data source to ActivePivot cube? Is there any library available for that purpose? Thanks.
John Watson
  • 103
  • 8
2
votes
2 answers

How can I retrieve the location in a drillthrough postprocessor ?

I would like to apply some logic in a drillthrough postprocessor which depends on the location where the drillthrough has been requested. For instance, let's say I have a risk vector and a list of maturities. If the user executes its drillthrough…
ChristopheCC
  • 97
  • 6
2
votes
3 answers

Is it possible to show totals last in Active Pivot Live?

Feels like I'm asking something very obvious, but I can't seem to find a configuration for showing 'Grand Total' last (bottom or right) instead of first (top or left). It is the first question asked by new Active Pivot Live users
Anders Blaagaard
  • 145
  • 6
2
votes
1 answer

Conditional ActivePivot Configuration

I'm setting up a polymorphic cube on top of a horizontal one as described on the confluence site (http://support.quartetfs.com/confluence/display/AP4/Polymorphic+scalability+on+top+of+horizontal+scalability), but it anoys me that it seems I need to…
Anders Blaagaard
  • 145
  • 6
1
2 3 4 5 6