Stack Overflow
Stack Overflow

Questions tagged [data-cube]

56 questions
0
votes
1 answer

Deploying UDF (User defined functions) to SSAS using ADOMD.NET

I'm very new to this and kind of confused as to how I should setup my project in Visual Studio (2022) and how to deploy UDFs and Stored Procedures to a SSAS instance. I already have a solution with a SSAS data cube project. The cube is deployed and…
Plaktil
  • 1
0
votes
0 answers

How do I create a data cube on Postgres from an existing 2d table

Our database is in Aurora Postgres on AWS. I access it using psycopg2 in python. The data is such that each row represents an instance of an item being brought. There areI multiple columns such as the time_when_sold, item_name, item_category,…
insafian
  • 21
  • 1
0
votes
2 answers

Matplotlib: Creating a 3d cube plot

I am trying to learn how to create a 3D cube plot to visualize data. Here I am creating some mock data to represent sales of items. On the x axis, I am trying to plot the year, Y axis I am trying to plot the items sold, and the Z axis would have the…
LeGOATJames23
  • 101
  • 7
0
votes
1 answer

BIRT Report: I have performed Data cube operation. But want to group medicine with qty for each record

The sql query is as follows: SELECT ROW_NUMBER() OVER() AS row_num, v.INVOICE_DATE, v.EMPLOYEE_ID, v.PATIENTNAME_AR, v.USER_LABEl, v.OFFICE_ID, v.ITEM_NAME, v.ITEM_QTYSOLD FROM ( SELECT…
Luke
  • 51
  • 7
0
votes
1 answer

BIRT Report: How to add table borders in Data Cube

I have a report with the output as follows: no Date Patid Patient Name Doctor Name Medicine Qty 1. 2 Feb 2023 100 Patient A Doc AB Adol 30 …
Luke
  • 51
  • 7
0
votes
0 answers

BIRT: I have grouped data using data cube but there are is not outline for the cross tab how to insert outline in cross tab

I have grouped data using data cube but there are is not outline for the cross tab how to insert outline in cross tab Please specify the exact step
Luke
  • 51
  • 7
0
votes
1 answer

How to set Data cube config file?

I'm trying to work on a new project and I red about Data Cube that can really help me. In order to use it and to try to work with it, I installed postgres as required on the official website:…
Ohads
  • 63
  • 1
  • 1
  • 6
0
votes
1 answer

Xarray most efficient way to select variable and calculate its mean

I have a datacube of 3Gb opened with xarray that has 3 variables I'm interested in (v, vx, vy). The description is below with the code. I am interested only in one specific time window spanning between 2009 and 2013, while the entire dataset spans…
Nihilum
  • 549
  • 3
  • 11
0
votes
1 answer

Datacube Xarray sort and select arrays by time

I have a datacube opened with Xarray, which has several variables and a time vector ("mid_date", dimension 18206) in format datetime64. The variables are 18206 x 334 x 333. The issue is that the time vector is not sorted at all, and I would like to…
Nihilum
  • 549
  • 3
  • 11
0
votes
2 answers

Can't select "Build Solution"

I am getting trouble to use Build solution in Visual Studio. I was building data cube and I needed to use Build solution to finalize my project. However, I couldn't find Build solution from the Build menu. For example ....…
NBB
  • 137
  • 2
  • 6
  • 14
0
votes
1 answer

SPARQL: Is there a way to pivot on a property?

I am querying a DataCube (RDF statistical data) that has 3 dimension and 1 measure. In this datacube, each observation is then composed of 4 statements (3 for the dimensions and 1 for the measure like the following exemple (that may be queried at…
dodecaplex
  • 1,119
  • 2
  • 8
  • 10
0
votes
1 answer

1D interpolation optimization on 3D data cube

I would like to make a 1D interpolation on a 3D data cube in Python. I have 18 images taken at fiducial wavelengths. I want to make a 1D interpolation on each pixel to form a new image for 185 given specific wavelengths. My problem is a problem of…
Julien Drevon
  • 322
  • 2
  • 17
0
votes
1 answer

Extract 3 dimensional data from csv file in R

I am trying to extract my data from a csv file into R. The data is currently formatted in the following: ,"[{time=2014-01-01T00:00:00, NDVI=0.3793765496776215}, {time=2014-02-01T00:00:00, NDVI=... ,"[{time=2014-01-01T00:00:00,…
eviep
  • 17
  • 5
0
votes
1 answer

BIRT: How to find average of derived measure in cross tab in spago BI?

I my BIRT Report i am using a data cube to show some data with the help of cross tab.In the cross tab i added a derived measure with the help of other measures. Question: How to calculate the average of that derived measure in the cross tab? Please…
user6328945
0
votes
1 answer

Creating a HDF5 datacube in Python with multiple FITS files

I am currently struggling with a problem. I have 1500 fits files that contain 3800 x 3800 arrays. My objective is to create a single HDF5 datacube with them. Unfortunately I cannot provide with the fits files (due to storage problems). So far, I…
Alejandro Serrano Borlaff
  • 3
  • 2
1 2
3
4