Stack Overflow
Stack Overflow

Questions tagged [cubes]

Cubes is an open-source light-weight Python framework and OLAP HTTP server for easy development of reporting applications and aggregate browsing of multi-dimensionally modeled data.

Cubes is an open-source light-weight Python framework and OLAP HTTP server for easy development of reporting applications and aggregate browsing of multi-dimensionally modeled data.

Features:

  • OLAP and aggregated browsing (default backend is for relational database - ROLAP)
  • multidimensional analysis
  • logical view of analysed data - how analysts look at data, how they think of data, not not how the data are physically implemented in the data stores hierarchical dimensions (attributes that have hierarchical dependencies, such as category-subcategory or country-region)
  • localizable metadata and data
  • SQL query generator for multidimensional aggregation queries
  • OLAP server – HTTP server based on Flask Blueprint, can be easily integrated into your application.
168 questions
44
votes
2 answers

Postgresql for OLAP

Does anyone have experience of using PostgreSQL for an OLAP setup, using cubes against the database etc. Having come across a number of idiosyncracies when using MySQL for OLAP, are there reasons in favour of using PostgreSQL instead (assuming that…
davek
  • 22,499
  • 9
  • 75
  • 95
30
votes
2 answers

Anyone know anything about OLAP Internals?

I know a bit about database internals. I've actually implemented a small, simple relational database engine before, using ISAM structures on disk and BTree indexes and all that sort of thing. It was fun, and very educational. I know that I'm much…
benjismith
  • 16,559
  • 9
  • 57
  • 80
18
votes
8 answers

Datamart vs. reporting Cube, what are the differences?

The terms are used all over the place, and I don't know of crisp definitions. I'm pretty sure I know what a data mart is. And I've created reporting cubes with tools like Business Objects and Cognos. I've also had folks tell me that a datamart is…
S.Lott
  • 384,516
  • 81
  • 508
  • 779
15
votes
4 answers

View MDX query generated while browsing a cube in SSMS

In Sql Server Management Studio once I browse a cube I can drop column fields, row fields and filter fields. This displays the required data. I want to know if there is a way to view the MDX query being generated behind the scenes to display the…
stackoverflowuser
  • 22,212
  • 29
  • 67
  • 92
12
votes
1 answer

MDX Calculated Member CrossJoin question

I have an MDX query with the following calculated member: with member [Measures].[BBOX] as Count( Filter( CrossJoin([Dim Response].[Response ID].Children, [Dim Question].[Question Text].Children), [Measures].[Question Bottom Box]…
Ryan
  • 121
  • 1
  • 3
9
votes
6 answers

Simulated OLAP

We have a client that has Oracle Standard, and a project that would be ten times easier addressed using OLAP. However, Oracle only supports OLAP in the Enterprise version. Migration to enterprise is not possible I'm thinking of doing some manual…
juan
  • 80,295
  • 52
  • 162
  • 195
7
votes
3 answers

Is there any way to use LINQ for MDX queries?

Anyone know if there are plans for LINQ to MDX . Does any way currently exist to use LINQ with MDX / CUBES
Stuart
  • 11,775
  • 6
  • 33
  • 31
5
votes
3 answers

Filtering a Measure (or Removing Outliers)

Say I have a measure, foo, in a cube, and I have a reporting requirement that users want to see the following measures in a report: total foo total foo excluding instances where foo > 10 total foo excluding instances where foo > 30 What is the best…
Colin
  • 309
  • 2
  • 5
  • 15
4
votes
5 answers

Fast way to check if long integer is a cube (in Java)

I am writing a program in which I am required to check if certain large numbers (permutations of cubes) are cubic (equal to n^3 for some n). At the moment I simply use the method static boolean isCube(long input) { double cubeRoot =…
konewka
  • 620
  • 8
  • 21
4
votes
1 answer

How to texture a "perfect cube" drawn with triangles?

I'm trying to map a texture on a cube which is basicly a triangle strip with 8 vertices and 14 indicies: static const GLfloat vertices[8] = { -1.f,-1.f,-1.f, -1.f,-1.f, 1.f, -1.f, 1.f,-1.f, -1.f, 1.f, 1.f, 1.f,-1.f,-1.f, …
q9f
  • 11,293
  • 8
  • 57
  • 96
3
votes
1 answer

How to get back aggregate values across 2 dimensions using Python Cubes?

Situation Using Python 3, Django 1.9, Cubes 1.1, and Postgres 9.5. These are my datatables in pictorial form: The same in text format: Store table ------------------------------ | id | code | address | |-----|------|---------------| | 1 |…
Kim Stacks
  • 10,202
  • 35
  • 151
  • 282
3
votes
3 answers

Free controls for showing OLAP cubes

is there a free set of controls to be used for representing the OLAP cubes in aspx pages? something like the ones from Dundas, but free and (if possible) cross-browser. Thanks, Lucian
lmsasu
  • 7,459
  • 18
  • 79
  • 113
3
votes
2 answers

Efficient program to check whether a number can be expressed as sum of two cubes

I am trying to write a program to check whether a number N can be expressed as the sum of two cubes i.e. N = a^3 + b^3 This is my code with complexity O(n): #include #include #define ll unsigned long long using namespace…
Srivatsa Sinha
  • 193
  • 2
  • 12
3
votes
1 answer

Python Cubes Olap Framework Date PointCut

So i am trying to implement some BI with Python Cubes Framework and i am running into some problems. Basically i am trying to do a "simple" PointCut/slice and dice and i am not having any luck with it. I am using a PostgreSQL database with PostGis.…
psychok7
  • 5,373
  • 9
  • 63
  • 101
3
votes
1 answer

get output of last Process on SSAS cube

I have processed a SSAS cube. After it was done processing, I hit the close button - and then realized that I should have saved the output. I think SSAS stores the processing log as a text or XML file, but I do not know what folder to look into. Can…
Raj More
  • 47,048
  • 33
  • 131
  • 198
1
2 3
…
11 12