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
1
vote
1 answer

Does activepivot support distribution?

Suppose that I have too much historical data (data from 2012 and 2011) to be put on one single computer using an activepivot. Can I split the data among the two computers (one with 2011 data and another with 2012 data) and still have a global view…
jsotogaviard
  • 21
  • 3
1
vote
2 answers

How can I implement a multithreaded PostProcessor in ActivePivot?

I consider an ActivePivot instance to compute CVA (Credit Valuation Adjustment). I have to apply a piece of logic on a large number of cells (20k for each counter-party), each being associated to a float array of size 10k. Even if ActivePivot is…
blacelle
  • 2,199
  • 1
  • 19
  • 28
0
votes
1 answer

How to build a simple moving average measure

I want to build a measure to get the simple moving average for each day. I have a cube with a single table containing stock market information. Schema The expected result is that for each date, this measure shows the closing price average of the X…
Alex
  • 1
0
votes
1 answer

Authorization by ActivePivot

When I try to navigate at http://localhost:8080/content/rest/v4/files/ui/version?recursive=-1&metadata=false I have an error 404 (file not found). While debugging I can see ActivePivot tries to define is my account granted for /ui/version. It…
user12377884
  • 130
  • 6
0
votes
0 answers

Unaccounted used memory after JVM shutdown

After shutting down a Java application (that does heavy usage of DirectByteBuffer) running inside a Docker Container, there is a lot of unaccounted used memory: $ free -hg               total        used        free      shared  buff/cache  …
JoGa
  • 85
  • 5
0
votes
1 answer

ActivePivot: Parsing Multidimensional Cellset data into JSON for React-vis Charts

I have just started working with MDX queries so I am not an expert. We have been provided with MDX queries to be triggered from our front-end application through a web socket connection. The response received is a multi-dimensional dataset rather…
CodingMum
  • 53
  • 8
0
votes
1 answer

How to aggregate on a column while grouping by several columns values using CoPPer?

I have a dataset with the current stock for some products: +--------------+-------+ | Product      | Stock | +--------------+-------+ | chocolate    | 300 | | coal         | 70 | | orange juice |   400 | +--------------+-------+ and the sales…
Rémi.B
  • 183
  • 10
0
votes
0 answers

Python ActivePivot MDX get result as CSV

Here is my code to connect AP import win32com.client conn = win32com.client.Dispatch(r'ADODB.Connection') DSN = ('Provider=MSOLAP.4;Password=XXXX;User ID=XXXX;Initial Catalog=Murex Cubes;Data…
Valee
  • 43
  • 5
0
votes
1 answer

ActivePivot with a rules engine

I have just started on a project which his regulatory in nature and the business area of the IB I work with uses ActivePivot to manage their securities (inventory). One of the tasks we need to do is that the ActivePivot data set and run some sort of…
Conor
  • 1
0
votes
1 answer

where will i get ActivePivot.lic for ActivePivot In Memory Analytical tool. I am trying to run MDX query from Java

where will i get ActivePivot.lic for ActivePivot In Memory Analytical tool. I am trying to run MDX query from Java. But getting below error, SEVERE: Error loading Quartet FS license: License could not be found either in the classpath…
Abinesh nagarajan
  • 1
0
votes
1 answer

How to remove records with partial keys in ActivePivot

I need to remove records from a store of ActivePivot 5.0. How can I achieve this when I do not know the full keys of these records?
Jack
  • 145
  • 1
  • 1
  • 11
0
votes
1 answer

How can I accelerate a series of similar queries in the datastore of activepivot?

In my activepivot solution, I have a store containing the desk and the currency for each trade. For example: 1, eur, DeskA, 10 2, eur, DeskB, 18 3, gbp, DeskA, 17 4, usd, DeskA, 54 I have a lot of queries where I want to find all the records that…
Jack
  • 145
  • 1
  • 1
  • 11
0
votes
1 answer

Dynamic bucketing in ActivePivot

In our ActivePivot project, we have designed our cube with predefined hierarchies and levels. Among them, we have our currencies which all belongs to the same level. Underlyings |_ALL |_UnderlyerCurrency Our users would like to group those…
JBE
  • 11,917
  • 7
  • 49
  • 51
0
votes
1 answer

How to make ActivePivot post-processors partition aware?

ActivePivot uses partitioning to improve parallelism and that speeds up query execution. However, when doing a query involving a post processed measure, I noticed that the evaluation of the post processor does not benefit from partitioning :…
Jack
  • 145
  • 1
  • 1
  • 11
0
votes
1 answer

How to update correctly in a monitored file with CSV Source

In ActivePivot 5.0, I'm monitoring a file containing my data to inject in the datastore. I want to have this single entry point, and that each change of the file updates or insert new data. This is my configuration of the file topic: @Bean public…
Kineolyan
  • 723
  • 8
  • 24
1 2 3
4
5 6