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

How to calculate columns when loading data into ActivePivot

In the CSV file that I use for loading ActivePivot, I have 2 fields that need to be multiplied together to compute my record's value: price * quantity. I am using the CSV source with topics and channels. Where can I perform this computation?
Jack
  • 145
  • 1
  • 1
  • 11
0
votes
1 answer

DISTINCT COUNT aggregation with ActivePivot

In ActivePivot, what is the most efficient way to configure DISTINCT COUNT aggregation? For instance if I want to configure a measure that for each cell returns the number of distinct products that contribute to that cell.
Jack
  • 145
  • 1
  • 1
  • 11
0
votes
1 answer

ActivePivot: Any code to convert the CellSetDTO object to csv, excel or other formats?

I am new to activePivot. We invoked a mdx query and got a CellSetDTO back. Is there any library code available to convert this CellSetDTO object to CSV, Excel, or other type of formats? I am looking at the javadoc from quartetfs on the CellSetDTO…
user3474390
  • 71
  • 3
0
votes
1 answer

Active pivot DrillThrough header aliasing and specify on runtime which column to be extracted

Anyone did this, aliasing the header name in the drillthrough and also specifying which column to be extracted during runtime. The reason is every user has specified set of column to be displayed in the drillthrough. Some example is really…
chris
  • 1
  • 1
0
votes
1 answer

ActivePivot isAllMembersEnabled=false dimension default value

How to specify what is the default member value, if we set the dimension isAllMembersEnabled=false. sample data for the dimension are [A,B,C,D,E] and when I select the dimension I want the default value will be C.
chris
  • 1
  • 1
0
votes
1 answer

Example how to specify QueryLimitTimeOut programatically in ActivePivot CUBE

Anyone implemented custom querylimit timeOut during runtime while retrieving data to the CUBE. Can I do this via xml configuration for each user. Thanks in advance Chris
chris
  • 1
  • 1
0
votes
1 answer

ActivePivot Indexer data removal

Anyone encountered this use case? When we removed data from the indexer using the objectkey, AP successfully returned that all data was removed. We tried to confirm by executing the same removal criteria and AP returns 0 count. But when we try to…
chris
  • 1
  • 1
0
votes
1 answer

Add new measure to ActivePivot?

I'm trying to add a new measure to an existing ActivePivot cube. I started adding a measure to the Sanbox project. It worked fine. I was able to see the new measure and i got the sum of all element. I added following…
overf7owed
  • 29
  • 6
0
votes
1 answer

Update ActivePivot continuous queries with external data?

In our ActivePivot solution we have written a post processor that computes the price of an stock option depending on the price of the stock (and a volatility parameter). When it is evaluated the post processor connects (for now) to the Google…
Jack
  • 145
  • 1
  • 1
  • 11
0
votes
1 answer

How to bind ActivePivot Instances to physical cores

We deploy two ActivePivot Instances on the same server (mutualization). The server has 12 logical cores. We have a 4-cores license for ActivePivot instance A and a 2-cores license for ActivePivot instance B. How can we be sure that the two instances…
Jack
  • 145
  • 1
  • 1
  • 11
0
votes
1 answer

How to perfom a cumulative sum that does not rely on level comparators?

We have a cumulative measure that is based on the Stream2PositionPostProcessor (from ActivePivot). We use it to sum on the fly our cach flow along a time dimension. We want to do the sum in chronological order but display the result in reverse…
Jack
  • 145
  • 1
  • 1
  • 11
0
votes
1 answer

Performance when using a filter and Instr in a MDX query

I have an MDX query of the following form, which I am using with ActivePivot. I need to filter the results (in my on rows), by the presence of a part of string in another dimension (columns): SELECT NON EMPTY Hierarchize({[CODE].[CODE].Members}) ON…
doc
  • 765
  • 1
  • 6
  • 24
0
votes
1 answer

Which web services should we use to send MDX queries to ActivePivot?

In our company, users already query activepivot through standard front-end (Excel). But we would like to build a custom MDX application in Java to query ActivePivot. The goal is to be able to subscribe to several specific views and to retrieve…
JBE
  • 11,917
  • 7
  • 49
  • 51
0
votes
1 answer

How can I diagnose an empty ActivePivot cube?

Starting from ActivePivot Sandbox 4.3.2 I changed my object feeding into the cube and redefined the fields, dimensions and measures of the cube. When I start the cube I see no error message in the logs. However when I connect to the cube using…
jolivier
  • 7,380
  • 3
  • 29
  • 47
0
votes
2 answers

Can I connect ActivePivot to the tableau software?

I would like to know if it is possible to connect activepivot to tableau software ? By the way is it possible to connect to microsoft reporting services ?
jsotogaviard
  • 21
  • 3
1 2 3 4
5
6