Questions tagged [dimension]

In physics and mathematics, the dimension of a space or object is informally defined as the minimum number of coordinates needed to specify any point within it. In the dimensional modeling, a dimension is a table in a star schema of a data warehouse. It is collection of reference information about measurable event. Dimensions categorize and describe data facts and measures in way that support meaningful answers to business questions.

Dimension table

A dimension is a table in a Star Schema or Snowflake schema of a data warehouse. It is collection of reference information about measurable event. These events are known as facts and stored in a fact table. Dimensions categorize and describe data warehouse facts and measures in way that support meaningful answers to business questions. They form the core of dimensional modeling.

Dimensions provide the "who, what, where, when, why, and how" context surrounding a business process event. Every dimension table has a single primary(surrogate) key. The primary key is embedded as a foreign key in any associated fact table. Dimension tables are usually wide, flat denormalized for analyzing data.

Links

782 questions
5
votes
1 answer

SQL Analysis Services OLAP TIME dimension

Hi i'm struggling with adding time dimension to OLAP cube. I can get everything in cube to work except date. In my source data view I have datetime column. I go by using Dimensions->New Dimension->Generate time dimension on the server. I end up with…
Pavel
  • 383
  • 3
  • 6
5
votes
4 answers

Finding (loaded) image size in AS3 (Action Script 3.0)

Im currently using the following function to load an image, however i could not figure out a way to find the width of the loaded image, which i intend to use before placing the next image using the same function. Note that q is a a variable (a…
eugene
5
votes
0 answers

Efficiently `apply` on array and preserve structure

I have an array of matrices. dims <- c(10000,5,5) mat_array <- array(rnorm(prod(dims)), dims) I would like to perform a matrix-based operation (e.g. inversion via the solve function) on each matrix, but preserve the full structure of the array. So…
Alexey Shiklomanov
  • 1,592
  • 13
  • 23
5
votes
1 answer

Find the Dimensions (Height ,width) of an Object using Camera

I want to find the solution to get the dimensions of an Object Using Camera, Well it sounds like Duplicate one How to measure height, width and distance of object using camera? But the solution doesn't help me out.Well from the Above link i got…
Janmejoy
  • 2,721
  • 1
  • 20
  • 38
5
votes
2 answers

Naming dimensions in python?

There is something that I would very appreciate, it is the ability to name the dimensions in an array in python. For example I have a numpy array with 3 dimensions and I will regularly have to sum it along a specific dimensions. So I can do with a…
François Laenen
  • 171
  • 4
  • 14
5
votes
4 answers

Java how to make JFrames maximised but not resizable

Originally (See my previous question "Java how to make JFrames start off as a maximised window") I wanted to make a window which starts out maximised. This code accomplishes this: public static void main(String[] args) { JFrame frame = new…
Jack O'Connor
  • 185
  • 1
  • 4
  • 11
5
votes
1 answer

Java how to make JFrames start off as a maximised window

I want to know how to make a java JFrame start out maximised. I don't want it to be fullscreen (no window around it) I just want it to start out like a normal program such as a web browser. I already know about using: Dimension screenSize =…
Jack O'Connor
  • 185
  • 1
  • 4
  • 11
5
votes
1 answer

How to model process and status history in a data warehouse?

Let's say that we have D_PROCESS, D_WORKER and D_STATUS as dimensions, and the fact F_EVENT that links a process (what) with a worker (who's in charge) and the "current" status. The process status changes over time. Shoud we store in F_EVENT one…
Francois
  • 10,730
  • 7
  • 47
  • 80
4
votes
2 answers

Understand the shape in tf.keras.Input?

I just learn tensorflow and keras. Here is a code example: # Create a symbolic input input = tf.keras.Input(shape=(2,), dtype=tf.float32) # Do a calculation using is result = 2*input + 1 # the result doesn't have a value result calc =…
Feng Chen
  • 2,139
  • 4
  • 33
  • 62
4
votes
2 answers

Using R for variable/dimension reduction on large data set

I have some data in R with various variables for my cases: B T H G S Z Golf 1 1 1 0 1 0 Football 0 0 0 1 1 0 Hockey 1 0 0 1 0 0 Golf2 1 1 1 1 1 0 Snooker 1 0 1 0 1 1 I also have a vector of my expected output per case: 1,…
Paul
  • 1,874
  • 1
  • 19
  • 26
4
votes
1 answer

Dimension mismatch in Julia

I created a matrix A, which is 300x4 array. And in the objective, i should minimize A*x, where x is a 1x4 vector. and my code is the following: k = 3 m = length(u) n = k + 1 A = zeros(m,k+1) for i = 1:m for j = 1:k+1 A[i,j] =…
4
votes
3 answers

List width and height of all images in a folder from Linux command line

I want to see the image dimensions of all the jpg images together in a list through a command line in Linux. Following code works for only one image. identify -format "%wx%h" xxxx.jpg
Areeb Muzaffar
  • 197
  • 2
  • 15
4
votes
1 answer

Ralph Kimball's Data warehouse toolkit book - Order lifecycle mart design

I'm reading Ralph Kimball's book on Data warehouse and Dimension Modeling. I am reading one of the case studies, and it is about dimension modeling for an order system, where the requirement is to capture an order lifecycle, from order to…
4
votes
0 answers

Keras - specify output shape of LSTM layer

I have sequential model in Keras where input and output data have shape (10000, 10, 300) each: model = Sequential() model.add(LSTM(input_shape=(10,300), units=300, return_sequences=False, activation="sigmoid", kernel_initializer="glorot_normal",…
Spook
  • 331
  • 1
  • 6
  • 16
4
votes
1 answer

How to work with variable-sized image in CNNs using Keras?

I am currently working on CNN on a image for feature extraction using keras. All the images as 276 rows, x columns and 3 color dimensions (RGB). The number of columns is equal to the length of the output feature vector it should generate. Input…
user7654132
  • 123
  • 10