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

ActivePivot: Find the CURRENT MEMORY SIZE?

Find the CURRENT MEMORY SIZE ? Does Active Pivot cube expose the current memory size on the cube ? or Is it possible to find the current Date's memory Size ? EXample: Total used Size = 400Gb CobDate = 2014040 , Total used Size = 200GB
swordfsh354
  • 13
  • 1
  • 3
1
vote
2 answers

ActivePivot QueriesService.retrieveObject on a distributed cube

I've been trying to create a new action in ActivePivot Live, that calls retrieveObject on the QueriesService. Something like this: IQueriesService queriesService = getSessionService(IQueriesService.class); ObjectDTO dto =…
Anders Blaagaard
  • 145
  • 6
1
vote
2 answers

Excel/OLAP and HTTP Basic Authorization - Can Excel Remember That It Has Logged In?

We are trying to enable a custom credential handling layer to our ActivePivot tomcat servlet by intercepting incoming requests to the Cube and authenticating them as needed using a Spring Security Filter. Our system provides an "API Key" to logged…
Burton Samograd
  • 3,652
  • 19
  • 21
1
vote
2 answers

Handlers for File Removal

After loading our initial facts into the cube, we then load a second file that adds measures to the existing facts (so no new facts are created by the second file). We use a Handler to do this. When the second file is removed from the filesystem,…
obrienk
  • 481
  • 5
  • 10
1
vote
1 answer

Mixing data at different levels

I've edited to rephrase this question: We want to store trade and sub-trade data. So to give an idea of data, we have input data like this: Trade Data (Relational Store) | TradeKey1 | TradeLevelMeasure1 | | TradeKey2 | TradeLevelMeasure2…
obrienk
  • 481
  • 5
  • 10
1
vote
1 answer

Relational Stores & Many-to-one joins

David, could I ask for some clarification on what you say about joins in this answer When you say "You cannot, using the join of the relational stores, join one entry to multiple ones", does that mean in any direction? E.g. Store 1: | Key1 |…
obrienk
  • 481
  • 5
  • 10
1
vote
1 answer

How to hide unwanted measures

AP 4.4.3, APL 2.7.0 Hi, When defining a post-processed measure we end up with two measures available to us in Active Pivot Live. E.g. the definition below will give us the measures "Yield Curve.SUM" and "Yield Curve.TenorDetail". As we've got a…
obrienk
  • 481
  • 5
  • 10
1
vote
1 answer

Sparse vectors aggregation with ActivePivot

In our ActivePivot project we aggregate large vectors of simulated data (the length of the vectors can reach one million values) and the memory consumption is very high. Most of the time, most of the values in the vectors are zero. Can ActivePivot…
Jack
  • 145
  • 1
  • 1
  • 11
1
vote
1 answer

ActivePivot context dependend formatting

I have a price measure that I want to format differently in different locations, e.g. the formatting depends on the value of a dimension. I could have multiple measures with different formatting, but that would complicate a lot of other things. The…
Anders Blaagaard
  • 145
  • 6
1
vote
1 answer

ActivePivot real-time push along Analysis Dimensions

We use ActivePivot to monitor real-time PnL (profit and loss) over financial trades. New trades (new records) are added or updated to the cube in real-time during the day, and ActivePivot is also connected to real-time sources of market data that…
Jack
  • 145
  • 1
  • 1
  • 11
1
vote
2 answers

How can i create a hierarchical dimension for dates in ActivePivot?

I'm a newbe in ActivePivot and i want to create a dimension with DimensionType = time, where the dates a shown in hierachical manner. E.g. for 30.01.2013 i need one level for the year -> 2013 (sort descending), one level for the month (also sort…
overf7owed
  • 29
  • 6
1
vote
1 answer

Is there an easy alternative to DistinctCount by using an ActivePivot Post processor

I have a slow MDX query that does the following: WITH MEMBER Measures.DistinctCode as 'DistinctCount({[CODE].Children})' SELECT NON EMPTY Hierarchize({DrilldownLevel({[DATE].[ALL].[AllMember]})}) ON ROWS, NON EMPTY…
doc
  • 765
  • 1
  • 6
  • 24
1
vote
2 answers

How to compute a MDX weighted average measure

We are implementing ActivePivot at a logistics service provider and we would like to build a view to help us find out the shipments that are not moving fast enough, and help understand how to improve this KPI. We have a simple MDX view that shows…
user1731897
  • 11
  • 3
1
vote
1 answer

How to correctly use InStr with ActivePivot?

I am trying to use the INSTR() function with ActivePivot. I am testing by using an Instr call that should always return > 0. Here is my initial MDX query that works fine: SELECT { {[CODE].[ALL].[AllMember]} } ON ROWS FROM [Cube] WHERE…
doc
  • 765
  • 1
  • 6
  • 24
1
vote
1 answer

ActivePivot cluster management in horizontal distribution

We are currently using ActivePivot 4.3 on a horizontal distribution. We split our data per historical days. Even if the loading is fast, we do not want to let users have access to a partially loaded node. We would like to have a node outside the…
bendoubs
  • 11
  • 2
1 2
3
4 5 6