Questions tagged [dimension]
The dimension tag has no summary.
37 questions
0 votes
1 answer
126 views
Architecture for "Overlapping Dimensions"?
Take a SQL RDBMS data warehouse -- typical facts and dimensions type layout. Say you want Orders x Country. Maybe a date field, an orders field, a country field. And then if you want a report/ ...
- 1,739
2 votes
1 answer
2k views
Difference between total table size and size of all pages in postgresql
Working with Postgres I noticed the following: When I run this query I get the total table size: SELECT pg_size_pretty( pg_table_size('tenk1') ); I get 384kb. And when I run: SELECT relpages FROM ...
Piet Pro
2 votes
1 answer
1k views
Dimension modelling for HR with Employee Dimension and multiple departments in a Data warehouse
What is the best way to configure a dimension model (preferably star schema) when we have the following requirements? There is an Employees table (25 attributes) where we are required to make some of ...
- 21
1 vote
1 answer
532 views
How to handle NULL Dates in an "Accumulating fact table"
One type of fact table in Dimensional modeling is Accumulating Snapshot fact Table. if you think you need to review the meaning and definition of this type , you can take a look at this article : ...
- 1,502
0 votes
0 answers
67 views
Trying to do a fact and dim table in Sql
so far this is what i have code wise, but im getting an error 1239 . Is it not referencing something correctly . CREATE TABLE CustomerDim ( C_CustomerID_Cu INT(10) NOT NULL, ...
0 votes
0 answers
232 views
How to handle table that has an id which references multiple dimension tables?
I'm having a hard time figuring out how to create a lookup table or a table that references multiple dimension tables. I've got a "tracking" table that tracks the number of impressions for an e-...
1 vote
0 answers
1k views
Dimensional Model for CRM Sales Opportunity and Sales Leads: Fact or Dimension?
I'm working for a business lender, and trying to come up with a basic dimensional model around the subject area of loan approvals. We use a CRM, (Salesforce) and one of the core objects is a (Sales) ...
- 41
1 vote
1 answer
999 views
My Fact table has data weekly but it is not visible in SSAS cube
I have my fact table that has data in weekly basis, so I am mapping with Week dimension to pull records in Piviot table. My ssas cube doesnt show all data that is in fact. Should I add any specific ...
7 votes
2 answers
3k views
How to store high-dimensional (N > 100) vectors and index for fast lookup by cosine similarity?
I am trying to store vectors for word/doc embeddings in a PostgreSQL table, and want to be able to quickly pull the N rows with highest cosine similarity to a given query vector. The vectors I'm ...
- 379
1 vote
1 answer
235 views
SSAS Cube Only Displays Total Values
When browsing my cube it shows the correct invoice values by date when I select only a date type (the date table was generated by SSAS with hierarchies), but if I add the customer name it shows the ...
- 143
3 votes
2 answers
1k views
How to calculate a percentage over a dimension attribute and get correct aggregates?
We have a fact table with the weight trasported by truck/driver/day. And a dimension with the max weight per truck. We would like to have the % of weight transported, so we started with create ...
- 161
0 votes
1 answer
392 views
In SSAS Parent-Child-Hierarchy how to use MembersWithDataCaption
I have a parent-child-hierarchy with MemberWithData=NonLeadDataVisible. I tried different values for MembersWithDataCaption, but I always get name of datamember equal to name of inner node. I am using ...
- 105
2 votes
0 answers
124 views
When to Converge Dimensions in a Data Warehouse When There Are Few Common Attributes
I have two StudentDetails dimension tables in my data warehouse and I want to know whether I should converge them, considering that they have limited attributes in common (keeping in mind Kimball DW ...
- 165
0 votes
2 answers
709 views
Issue with DECLARE @CutOffDate DATE = DATEADD(YEAR), @NumberOfYears, @StartDate); [closed]
When executing the steps in this query. I am running into an issue with the DECLARE @CutoffDate DATE = DATEADD(YEAR, @NumberOfYears, @StartDate); I get a message of Msg 137, Level 15, State 2, Line 2 ...
1 vote
1 answer
2k views
Error when only deploying a dimension on SSDT
I'm trying to follow a tutorial on SQL Server Analysis Services (SSAS) but I'm having trouble on deployment. Summarized, what I'm doing is: Open SQL Server Data Tools (SSDT) Creating a new ...
- 195