Questions tagged [data-cube]
56 questions
4
votes
0 answers
RDF Data Cubes, AttributeProperty, units of measurement & QUDT
I'm doing some work with RDF Data Cubes vocabulary for publishing time-series of various data, among others sensors. The measurement of the sensor is taken at a specific time at a specific station.
Both time and station I will model as…
Adrian Gschwend
- 664
- 8
- 16
3
votes
1 answer
Select top X results per group
I have a bunch of RDF Data Cube observations that have an attached attribute, in my case the date on when that value was recorded.
The pattern is simple, for example (leaving out other dimension/measure/attributes):
a qb:Observation ;
…
Adrian Gschwend
- 664
- 8
- 16
3
votes
1 answer
MDX - Retrieving a level of members currently used in where clause
I have a simple data cube with organization structure hierarchy defined. In my calculations inside the cube I would like to have different calculations depending on which level of organization items is currently used in WHERE clause in MDX query.…
Bartek Boro
- 155
- 1
- 3
- 11
3
votes
1 answer
RDF Data Cube uses property as object?
as i read the RDF Data Cube Vocabulary document, one thing confuses me: MeasureProperties (in the following example I use eg:lifeExpectancy are first defined as properties. however, when defining the data structure they are used as objects. is this…
beta
- 5,324
- 15
- 57
- 99
2
votes
1 answer
Getting specific cell value from NetCDF file slow on first execution
I am accessing a netcdf file using the xarray python library. The specific file that I am using is publicly available.
So, the file has several variables, and for most of these variables the dimensions are: time: 4314, x: 700, y: 562. I am using the…
dbilid
- 279
- 2
- 10
2
votes
1 answer
Xarray select dataarray according to an non-dimension coordinate
I want to select a Dataarray according to a criteria from a non-dimension coordinate. In the example below, I have my coords 'sat' which depend on the coord 'time', which is exactly what I need. When I use Dataarray.sel(time='2021-05-04'),…
FarAway21
- 51
- 5
2
votes
1 answer
How to construct RDF using Data Cube Vocabulary with SPARQL
I have CSV data set and I want to construct RDF using Data Cube Vocabulary.
Now I have triplifier, which constructs "regular" RDF with tarql:
PREFIX data1:
PREFIX data2:
PREFIX xsd:…
Alex
- 350
- 5
- 20
2
votes
2 answers
Regards fact table as dimension table in data cube
I have a view in my sqlserver database,but now,I want to build a data cube instead of the view,aim to more select efficiency.
the view design picture.
two tables connect and select many column in this view.NOW,the trouble is in data cube, you have…
return
- 21
- 1
2
votes
2 answers
Optimizing a nested-loop operation
I have this datacube containing data for each pixel of an image (pretty much like hyperspectral imaging).
I'm trying to fit a line on each pixel of the image, in an efficient way.
Right now, I do it like this:
My datacube is a 6X1024x1024 numpy…
PhilMacKay
- 865
- 2
- 10
- 22
1
vote
1 answer
SSIS Can't Process DataCube
Trying to create an SSIS package to process a Datacube. Using SMS 2008, I've created a package to run where the cube lives and I keep getting an error,
SSIS package "SalesCubeProcess.dtsx" starting.
Error: 0x0 at Sales Cube Analysis Process in…
GabrielVa
- 2,353
- 9
- 37
- 59
1
vote
1 answer
Converting pandas DataFrame to datacube?
I have a DataFrame with four columns: X, Y, Z, and t. The values in the first three columns are discrete and represent a 3D index. The fourth column is a floating-point number. For example,
df = pd.DataFrame({'X':[1,2,3,2,3,1],
…
DYZ
- 55,249
- 10
- 64
- 93
1
vote
1 answer
Mean spectra over multiple pixels from datacube
I have a fits datacube with galactic longitude, latitude and velocity in the 3 axis. To extract the spectrum from the datacube at a particular pixel value of longitude and latitude, I use the function
cube[:, 1935, 1407].quicklook()
plt.show()
and…
Lidia
- 27
- 5
1
vote
0 answers
Open Data Cube: Unable to connect to database within opendatacube Conda environment
I followed the steps listed at https://cubes.readthedocs.io/en/v1.0.1/install.html
and did the following:
Installed Python
Installed PostgreSQL
ssudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" >…
Supriya Sharma
- 11
- 1
1
vote
0 answers
Loop through all available OLAP cube filter values
Tried to find a solution here, but was not successful.
I have a pivot table in Excel, which is connected to a data cube. What works is setting filters on values inside the Pivot Table with the…
smartini
- 404
- 6
- 18
1
vote
0 answers
How can Bokeh DataCube widget's SumAggregator to sum more than 1 field
How can Bokeh 1.3 new widget DataCube to sum more than 1 field?
Bokeh 1.3 doc :https://blog.bokeh.org/posts/release-1-3-0
From the sample code of Bokeh doc, it will sum 1 field only, I have tried with a list of 2 fields but no luck.
Sample…
Wing
- 11
- 1