Stack Overflow
Stack Overflow

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
3
votes
2 answers

ssas dimension processing key not found error

I have this strange case where I am trying to process a dimension, the data source is MSSQL and when I try to process this dimension I am getting this error Errors in the OLAP storage engine: The attribute key cannot be found when processing:…
rlee923
  • 758
  • 3
  • 14
  • 28
3
votes
2 answers

How do I get the dimensions of a website image in Java without downloading it?

I'm looking for some code to get the dimensions of an image on a website in Java without having to download it first. The idea is that if the image is too big, I wouldn't download the file and would return an error message, so users don't input URLs…
Michael Celani
  • 171
  • 7
2
votes
4 answers

Fortran Subroutine Pointers for Mismatching Array Dimensions

I'm having a problem with Fortran and function/subroutine pointers. I have two functions that take an array as an argument. In f1 it is a(n,n), in f2 it's a(n*n). When I call the subroutine manually, I can do this with the same array: real :: a(5,…
Cabadath
  • 897
  • 3
  • 13
  • 23
2
votes
1 answer

Matlab error: Non-singleton dimensions of the two input arrays must match each other

I have a 1000x1 array, in which i would like it to divide into equal parts based on a lambda value lam_packet, and then in each part i would replace 0 0 0 0 with radom binary values , but whenver i call this function i get an error ??? Error using…
Spaniard89
  • 2,359
  • 4
  • 34
  • 55
2
votes
3 answers

What are the types of dimension tables in star schema design?

When reading about star schema design I have seen that many people uses various names for different types of dimension tables. Please list the names and a small description of each type. If any list also an alias name.
MOLAP
  • 784
  • 4
  • 13
  • 28
2
votes
2 answers

How to do percentage height and width in Android?

I'm trying to set a button to 60% height and 60% width of the physical device. Since the size of the screen is user-dependent, using dips is out of the question. How can we do percentage height and width in Android? E.g.:
Sophie
  • 47
  • 7
2
votes
1 answer

Get page size using AlivePDF

Is it possible to get the page width and page height for a PDF during creation with AlivePDF? I need this to place a shape to the right side of the page, no margin or padding, sticked to the right side.
Francisc
  • 77,430
  • 63
  • 180
  • 276
2
votes
1 answer

How to center NeutralinoJS screen

Using NeutralinoJS, how can start the app right in the center of the screen? It should look like the splashscreen of any app. Unlike ElectronJS, Neutralino's window options doesn't seem to have a center() method.
adelriosantiago
  • 7,762
  • 7
  • 38
  • 71
2
votes
3 answers

Reverse dimension of an xarray

I have a xarray Dataset with dimensions time, latitude, longitude and pressure levels. The latitude goes from 90° to -90°. But I need them from -90° to 90°. How can I turn around the dimension in a way that also the dimension of the variables are…
Martina
  • 21
  • 2
2
votes
1 answer

How can I append difference dim' array?

I made some numpy array np3 np1 = np.array(range(2*3*5)) np3 = np1.reshape(2,3,5) and np3 has shape like this: [[[ 0 1 2 3 4] [ 5 6 7 8 9] [10 11 12 13 14]] [[15 16 17 18 19] [20 21 22 23 24] [25 26 27 28 29]]] then, I made new numpy…
LegasLee
  • 51
  • 3
2
votes
1 answer

MDX for calculating measure given equality of 2 member attributes from 2 different dimensions

I have the following structure of measures and dimensions, and some example data Fact Table: id_dim1 id_dim2 id_dim ...measure1 1 2 ...120 2 1 ...101 1 1 ...95 3 3 ...12 Dim1: id_dim1 member1value 1 Value1 2 Value2 3 Value3 Dim2: id_dim2…
envsdl
  • 21
  • 1
2
votes
1 answer

High dimensionality on data sets

I have seen in many questions on SO, asking for your opinion of how do you define a huge table in a database.... I have seen that you have answered >= 1 billion of rows, etc.. Doing some research and following Wegman and Solka they classify a huge…
edgarmtze
  • 24,683
  • 80
  • 235
  • 386
2
votes
1 answer

Is this the actual size of panel?

JPanel scorePanel = new JPanel(); scorePanel.setBackground( new Color( 95 , 8 , 248 , 255 )); JLabel scoreLabel = new JLabel( "Score : 0" ); scoreLabel.setForeground( Color.white ); scoreLabel.setFont( new Font( "Cambria" , Font.BOLD , 20 )…
Suhail Gupta
  • 22,386
  • 64
  • 200
  • 328
2
votes
1 answer

numpy: dimensions vs. shape

I have a just a short question about the attributes shape and ndim. How can an array have more dimensions than two, but matrices are limited to a n x m shape? Would it not be necessary to have shapes with something like a m x n x o shape for a…
MDoe
  • 163
  • 1
  • 13
2
votes
0 answers

can clientId be requested from the Google Analytics Reporting API v4 if yesterday is in the date range?

When I request data from the google analytics reporting api, where the request contains 1) the dimension ga:clientId 2) yesterday's date in the daterange I am finding that the response returns 10,001 data rows consistently irrespective of what the…
P Corr
  • 21
  • 2
1 2 3
…
52 53