Stack Overflow
Stack Overflow

Questions tagged [data-cube]

56 questions
1
vote
0 answers

Interactive application to aggregate and visualise data: is pandas+plotting library the right tool?

Consider this example. I have a pandas data frame with three "dimensions": day, location, item id, and some values, let's say sales and demand. I would like to aggregate sales and compute and visualise statistics over either dimensions. For…
Andreas
  • 41
  • 3
1
vote
0 answers

opendatacube ingestion of a Sentinel3 product

I would like to ingest a Sentinel 3 OLCI Level 2 product so I'm trying to make the 'prepare_dataset.py' script. I can't get the 'grid_spatial/projection' details, particularly 'geo_ref_points'. I've tried to use RasterIO, as recommended here, but…
Liliana Martirano
  • 11
  • 1
  • 1
1
vote
1 answer

How to get dates inside of SSAS cubes to display in a different format

The dates in SSAS data cube are processing like 201801-201802-201803 and so on. for some reason I can't figure out how to get them to display like June-2018. I know there's got to be a way to code dates in dimensions that will display them like…
Cade
  • 38
  • 7
1
vote
1 answer

How do I automate a translation across an EELS Spectrum Image

I would like to perform a y-axis intensity offset to the counts on spectra across this spectrum image. Is there anyway to script this addition to the spectra to all positions in a data cube? Single EELS Spectra
Alvin Lee
  • 11
  • 2
1
vote
1 answer

switch axis for a data cube (fits file)

I've some problems and I could not find any answer to my problem. I'm trying to create a datacube in python, where the three axis are (RA,DEC,z), that is 2 sky position and red shift. I think my code for generating the cube works, I define the cube…
GreatMonark
  • 33
  • 3
1
vote
1 answer

Using index position to filter an array by values in another array - javascript

I'm working with an extremely large data cube that I need to manipulate for data visualization purposes. I have a multidimensional array contains arrays of every possible combination of objects, with the final object of each array being an…
DGaffneyDC
  • 152
  • 1
  • 2
  • 12
1
vote
3 answers

SSAS Data Cube, how can I get an average instead of a sum as a dimension aggregation?

I am working with a data cube that has a calculated member that is a percentage, and I need to get the aggregation for that member to be an average and not a sum. Here is a screenshot or the cube in Excel: The bolded percentages are a sum, which…
Alex Saurus
  • 49
  • 6
1
vote
1 answer

Not aggregatable measure referenced by hierarchy

I have measure which holds dedicated value for each item in hierarchy level. Can you help me how can I design this measure to avoid aggregations for each item across all children items? I tried to do something like this, but I did something…
wbargiel
  • 69
  • 7
1
vote
2 answers

Cross join same hierarchy columns

I have a SQL data cube with following hierarchy I want to cross join Warehouse division and Code warehouse Desc. I wrote a MDX as follows SELECT NON EMPTY { [Measures].[Total Value]} DIMENSION PROPERTIES CHILDREN_CARDINALITY,…
udaya726
  • 1,010
  • 6
  • 21
  • 41
1
vote
1 answer

insert data to relational table from data cube

I have SQl data cube. I want to export data to a relational data table from the cube. I tried to use SSIS data flow task to extract data. But there are several data conversion issues and some others(I used data conversion action but it doesnt solve…
udaya726
  • 1,010
  • 6
  • 21
  • 41
1
vote
0 answers

how should the dataset be provided to nanocubes?

If anyone could help me with how the dataset should be fed into nanocubes, it would be wonderful. Github link https://github.com/laurolins/nanocube Paper http://www.research.att.com/techdocs/TD_101151.pdf Example dataset…
sparco
  • 85
  • 1
  • 7
1
vote
1 answer

Extracting third axes, data cube pyfits

I have a data cube fitsfile, consisting of an intensity at a regular (512x512) 2d grid. There is also a third axes however; each value on this axis corresponds to a frequency. At each frequency, a such 2d picture is taken. I have been trying to find…
user1991
  • 584
  • 1
  • 4
  • 18
1
vote
1 answer

OLAP/Datamart How to get started pushing data off of my database to a reporting database

I work for a company We have many customers all hosted on one Database and one Schema. All the customers need to be able to see their own data, but currently im using permissions and views joined to force them to their own data only based on data…
Rico
  • 1,258
  • 4
  • 17
  • 35
1
vote
1 answer

How to pass parameters to data set behind a data cube in BIRT?

I have a data cube which is based on a data set. The data set takes a number of parameters. So far I have not been able to find out how to pass parameters to that data set. I see that it is possible to set a filter on the data cube but that doesn't…
paul
  • 13,312
  • 23
  • 81
  • 144
0
votes
1 answer

Best way to transform data to intermediate DB for OLAP

I am doing research to see what is the best way to take data from a live database, and transform it to be able to put the data into data cubes. Currently as a prototype, we used normal queries, to copy data from the live database as a sequence of…
Mez
  • 4,666
  • 4
  • 29
  • 57
1
2
3 4