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

MDX Calculated member filter by dimension attribute

I want to create a calculated member and filter it by dimension. This is WORKING example: ( [Policy].[Policy Status].&[Void], [Policy].[Tran Type].&[Renewal], [Measures].[FK Policy Distinct Count] ) But if I want to filter it like…
ilija veselica
  • 9,414
  • 39
  • 93
  • 147
15
votes
2 answers

Using a DATE field as primary key of a date dimension with MySQL

I want to handle a date dimension in a MySQL datawarehouse. (I m a newbie in the DW world) I made some searches with google and saw a lot of table structures (most of) date dimension where the Primary Key is a simple UNSIGNED INTEGER. Why don't use…
nemenems
  • 1,064
  • 2
  • 9
  • 27
15
votes
1 answer

Is there a concept of slowly changing FACT in data warehouse

In data warehousing, we have the concept of slowly changing dimensions. I am just wondering why there is no jargon for 'slowly/rapidly changing FACTs' because the same Type1, Type 2 measures can be used to track changes in the FACT table.
Victor
  • 16,609
  • 71
  • 229
  • 409
14
votes
3 answers

Reference another dimen in dimen

Is it possible to use the reference of a dimension resource in another dimension? What i mean is something like this: File dimen.xml: 18sp @dimen/test1
leuchtdiode
  • 477
  • 3
  • 12
12
votes
1 answer

Precision Measurement with Opencv python

I am actually working on a Machine Vision project using OpenCV and Python. Objective : The objective of the project is to measure the dimensions of a component with high accuracy. Main Hardware : Basler 5MP camera (aca-2500-14gm) A red backlight…
Abhijit Balaji
  • 1,870
  • 4
  • 17
  • 40
12
votes
4 answers

RecyclerView#onMeasure() did not set the measured dimension by calling setMeasuredDimension()

I have a fragment with RecyclerView attached with the LinearSnapHelper so to get the view in the center and highlight it by scaling its size. it is working fine , but when pop this fragment from backstack on back press, it throws following…
Gurpreet Kaur
  • 434
  • 1
  • 4
  • 16
11
votes
1 answer

Loading Rdata files from url

I'm having difficulty loading a file so that it doesn't lose its dimensions. So here is where I'm at: > mood_data <- read.table("http://www.psychology.mcmaster.ca/bennett/psy710/datasets/mood_data.Rdata") If I do this it just gives me all the…
y3trgfhsfgr
  • 467
  • 8
  • 17
11
votes
5 answers

How to iterate over n dimensions?

How can I iterate over a n-dimensional array given the number of dimensions and the size of each as variables? int n; int size[n]; Since the number of dimensions is not fixed, I cannot write a nested loop for each dimension. I need the code to work…
danijar
  • 32,406
  • 45
  • 166
  • 297
10
votes
3 answers

Method return type in Dimension class of java.awt

I am surprised to see that getters of height and width members has return type double, albeit they are int. Moreover, setSize method with double parameters has the following definition: /** * Sets the size of this Dimension object to …
Ahamed
  • 39,245
  • 13
  • 40
  • 68
10
votes
1 answer

What is the best practice using dp and sp dimensions in Jetpack Compose?

I would like to understand how is better to use dp and sp values in the Compose project. I checked several open-source Compose projects, and most of them are hardcoding the dimensions. But it's definitely not a way to support flexibility and…
sergpetrov
  • 1,506
  • 1
  • 11
  • 20
10
votes
2 answers

joining across multiple fact tables with a dimension in between

What's a good approach to data warehouse design if requested reports require summarized information about the same dimensions (and at the same granularity) but the underlying data is stored in separate fact tables? For example, a report showing…
Justin Grant
  • 44,807
  • 15
  • 124
  • 208
9
votes
1 answer

Which part of Pytorch tensor represents channels?

Surprisingly I have not found an answer to this question after looking around the internet. I am specifically interested in a 3d tensor. From doing my own experiments, I have found that when I create a tensor: h=torch.randn(5,12,5) And then put a…
Rohan Singh
  • 461
  • 2
  • 5
  • 20
9
votes
1 answer

Delete a dimension in a NetCDF file

I have a netCDF file with 8 variables and 4 dimensions: latitude (dim: 26), longitude (dim:17), time (dim: a lot) and level (dim:1, pressure level). In order to use it in a specific program I need to have only 3 dimensions: latitude, longitude and…
Douie
  • 201
  • 4
  • 11
8
votes
0 answers

Loading a database table with "slowly changing dimensions" in Python

Ok, I can load records into a table using to_sql in pandas. (Unfortunately, I cannot use bcp or bulk insert, because my (SQL Server) database server is remote). How about a table with (Type 2) slowly changing dimensions? In SSIS, I would use SCD…
Dimitri Shvorob
  • 495
  • 1
  • 6
  • 24
8
votes
2 answers

Expand dimensions xarray

Is there an existing method or approach to expand the dimensions (and coordinates) of an xarray.DataArray object? I would like to obtain something similar to np.expand_dims while at the same time defining a new dimension and coordinate variable for…
rafa
  • 235
  • 1
  • 2
  • 10
1
2
3
…
52 53