The dimension tag has no wiki summary.
2
votes
0answers
29 views
How to remove leaf member values?
I have a dimension hierarchy that is related to multiple fact tables with different granularities. In the case of one fact table, it relates to the middle level of a three level hierarchy.
When you ...
1
vote
0answers
100 views
How to aggregate calculated measures involving dimension attributes?
The business case is as follows -
I have a cube of sales transactions and a dimension of parts. One of the attributes of a part is the current cost, which is non-aggregatable. A user needs to model ...
2
votes
2answers
96 views
Open source and commercial tools to build dynamic queries of fact tables in star schema
What user interfaces or tools (commercial and/or open source) can query a star schema model (Ralph Kimball dimensional model)? So for example, if we have X fact tables, and Y dimension tables, and Z ...
1
vote
2answers
137 views
Data warehouse support tickets
I'm starting to design a data warehouse for a company. The first questions we're trying to resolve are regarding their support ticketing system. My initial schema is as follows
Now one of the ...
2
votes
1answer
187 views
In star schemas, what should I do when a dimension has a date attribute?
I'm trying to learn about dimensional models and star schemas. Say I have a Sales fact table recording the total sales at retail stores, with, say, four dimensions, Date, Customers, Stores, and ...
6
votes
1answer
103 views
Dimension and Fact for same entities?
I'm rather new at DW design and am working on a DW to model some IT infrastructure.
The major problem/question at this point is how to model drive information.
We will be collecting aggregate data ...
2
votes
1answer
359 views
Does surrogate key assignment for a fact table require that the source data has natural keys?
Let's say I have a simple OLTP database with orders, products, and customers:
And from it, I am building a data mart with an orders fact table, product dimension, customer dimension, and date ...
7
votes
1answer
135 views
Dynamic Dimension Security
I have a cube in SSAS 2012 with about 30 dimensions, one of which is Company.
The Company dimension contains a list of companies, of which there are several hundred in the cube. Our security model ...
14
votes
3answers
957 views
Dynamically Define a Range in a Dimension
I have an issue that i face every time i decide to build a cube, and i haven't found a way to over come it yet.
the issue is how to allow the user to define Range of things automatically without ...
