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

How can I determine a location corresponding to a PivotCell click ?

Lets say a user double click or right click on a pivot cell. How can I determine the location that has been selected ? For instance, a user may want to select a location to reevaluate its position. Therefore, according to the location, I would need…
2
votes
2 answers

Change window title for ActivePivot Live

I want to change the window title for ActivePivot Live, so that users having multiple Live instances open, can better find the right one. I've tried calling Window.setTitle from my GinBootstrappers.afterApplicationLoaded method, but that seems to…
2
votes
1 answer

MDX Drill-Down Query Generation

I'm writing some client code to integrate with ActivePivot. As part of this, I need to be able to handle drill-down requests and generate the appropriately modified MDX query before submitting it to the server. Here's a simple example using the…
Kent Boogaart
  • 175,602
  • 35
  • 392
  • 393
2
votes
1 answer

How to load files in a specific order

I would like to know how I can load some files in a specific order. For instance, I would like to load my files according to their timestamp, in order to make sure that subsequent data updates are replayed in the proper order. Lets say I have 2…
2
votes
1 answer

Can Active Pivot dimension/measure field names or aliases contain spaces?

A search of the QuartetFS Confluence for 'field name spaces' gives little other than a snippet of a document saying: The names are shown here with spaces, for clarity; in ActivePivot, the names do not have spaces "Do not have spaces" doesn't mean…
Burton Samograd
  • 3,652
  • 19
  • 21
2
votes
1 answer

How to use Relational Stores with a position based data file?

I have different data files that are mapped on relational stores. I do have a formatter which contains the separators used by the different data files (most of them csv). Here is an example of how it looks like: DQKI 435741198746445…
Seif Eddine Mouelhi
  • 2,161
  • 3
  • 19
  • 25
2
votes
1 answer

Getting a reference to the current ActivePivotManager

How do you get a reference to the current ActivePivotManger? I've found code that uses it but no way to actually get ahold of it.
Burton Samograd
  • 3,652
  • 19
  • 21
2
votes
1 answer

Relational Store and Cube Inspection/Reflection

Relational stores and cubes are defined in ActivePivot through the various XML configuration files available, like Formats.csv, LoadInstructions.csv, WhatverCube.xml, and SchemaFields.xml. Can the configuration information specified in these files…
Burton Samograd
  • 3,652
  • 19
  • 21
2
votes
1 answer

Can I use my C++ DLL within ActivePivot?

ActivePivot being a Java solution, how can I re-use existing C++ libraries in it? I consider a CVA (CounterParty Value Adjustment) project based on ActivePivot and I would like to reuse my existing C++ code to apply my Collateral logic on array of…
blacelle
  • 2,199
  • 1
  • 19
  • 28
1
vote
1 answer

How can i get my aggregated exposure by identifiers across a hierarchy?

Let's say I have the following data : Trade Data : TradeId,CptyID,Exposure T1 , C3, 100 T2 , C2, 50 T3 , C6, 200 Business Hierarchy Data : CptyID,L1-Acronym,L2-Acronym,L3-Acronym C3, H1, H2, …
1
vote
1 answer

Sum and count aggregate functions in dynamic pivot table

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

How do I go about using hadoop with active pivot?

I am using version 5.1 of Active Pivot, but plan to upgrade to 5.2. I would like to read data in using the CsvSource and receive realtime updates.
Hal
  • 21
  • 2
1
vote
1 answer

Use a dimension only as a slicer

Users often want to be able to filter on high cardinality dimensions such as ISIN or counterpartyID. Is there a way to use such dimensions as slicers but block them for being used in rows / columns ? Best regards, Christophe
1
vote
1 answer

How do I cleanly shutdown a distributed ActivePivot setup?

We have an ActivePivot cube that is a polymorphic cube (2 nodes) where 1 node is itself a horisontally distributed cube (8 nodes). Running in Tomcat using JGroup TCP for distribution. It is restarted on a daily basis, but every time it is shut down…
1
vote
0 answers

Infragistics ADOMD ClassCastException when connecting to ActivePivot's XMLA server

I am trying to edit the Infragistics WPF PivotGrid Sample so that it will connect to the ActivePivot Sandbox Server. ActivePivot supports XMLA and I can connect to the same Sandbox Server using the 'From Analysis Services' DataSource option in MS…
doc
  • 765
  • 1
  • 6
  • 24