Stack Overflow
Stack Overflow

Questions tagged [degenerate-dimension]

In a data warehouse a degenerate dimension is a key in a fact table that does not have any corresponding dimension table.

In a data warehouse a degenerate dimension is a key in a fact table that does not have any corresponding dimension table.

See also: Star schema and Snowflake schema

11 questions
5
votes
0 answers

Is it possible to consider points coplanar in CGAL Delaunay triangulation (or any other supported triangulation) even if they are not?

I have got a polyhedron and the face points (for each of the faces) are basically coplanar but CGALsays they are not, this makes sense as the points are read from a file and there are only 14 significant digits so they will not be exactly coplanar.…
lucmobz
  • 453
  • 3
  • 8
1
vote
3 answers

Poor Performance of Mondrian w/ Degenerate Dimensions

I have an application that collects performance metrics and stores them in a datamart. I then use Mondrian to enable analysis and ad-hoc exploration of the data. I'm collecting about 5e6 rows per day and total size of the METRIC table is about…
sceaj
  • 1,573
  • 3
  • 12
  • 24
1
vote
1 answer

A Data Cube using single Table

I have a single table of data that consists of 40 cols. Everything I need is in there. I was wondering if I could Build a Data Cube on this table alone. How can I say to the cube that these are the dimensions, these are Measures? Could you please…
SarangArd
  • 1,115
  • 3
  • 12
  • 18
0
votes
1 answer

What are some common degenerate cases for structures or functions in computer science?

I can think of only a few for example the zero length list or set. The zero length string. How about empty matrices or tensors? How about parallelograms with all zero degree angles? How about a rectangle with two sides zero length? Or a triangle…
Jules Manson
  • 214
  • 2
  • 13
0
votes
0 answers

Dimensional Modeling: same degenerate dimension in multiple fact table or using conformed dimension

I have a retail sales system and want to create a data warehouse using Dimensional Modeling by ralph kimball. I have a simple order fact table that measures order quantity and order dollar amount. From what I read in the book and internet, the order…
billyzaelani
  • 567
  • 1
  • 5
  • 18
0
votes
1 answer

How to use Timestamp from PostgreSQL in Mondrian 4 Schema?

In my fact table (from PostgreSQL) i have a timestamp that looks like this: 2016-07-01 How can i use this timestamp to show a Year/Month/Quarter/Day dimension? A Mondrian 4 Schema example would be helpfull. I don't want to use a extra time table…
Spenhouet
  • 6,556
  • 12
  • 51
  • 76
0
votes
1 answer

MDX Query behaving abrupt with degenerate dimension on CDE dashboard

Following is my query: WITH SET [sp] AS ([time.fin].[day].[${parDate}]:[time.fin].[day].[${partoDate}]) SET [factory] AS {[organization].[org].[Fact1],[organization].[org].[Fact2],[organization].[org].[Fact3]} MEMBER [btype].[b]…
user2564512
0
votes
1 answer

Mdx Sum measure of dimension by Date

I'm introducing into mdx language and I came up with a problem. I want to sum up length of streets (DimStreet) from dimension as calculated member in cube with hierarchy date to day level (e.g: [DimDate].[Alldate].[Day]) I done in SQL to give a…
Fabio
  • 28
  • 2
0
votes
1 answer

Fact dimesion/ Degenerated dimension

Is there any alternative of fact relationship? How to get rid of de-generated dimension / fact relationship?
user999896
  • 129
  • 2
  • 6
  • 21
0
votes
1 answer

How do I handle this scenario related to degenerate/fact dimension in SSAS cube?

I have an SQL Server 2008 SSIS/SSAS Datawarehouse cube that I am publishing, in this cube I have the following: Dimensions ---------- Company Product Sales Person Shipped Date (time dimension) Facts ----- Total Income Total Revenue Gross For…
user1709091
-1
votes
1 answer

Star schema imperative for using Mondrian?

I am seeing different implied answers to this question. Can a single 'flat' fact table be used simply referencing the different columns from the Mondrian schema?
Forward
  • 9
  • 2