Viewing 15 posts - 316 through 330 (of 1,354 total)
Additional information would be helpful. First, what is the granularity of the fact table(s)? Is it every change in the application? Part of your discussion makes me think of an...
October 12, 2017 at 11:06 am
Wow, all the complaints just hit my snowflake radar and all I could think of was "suck it up, buttercup."
You may want to consider lowering the sensitivity...
October 7, 2017 at 9:34 am
Getting a seemingly easy question wrong is a good jolt to start the day. But I'm certain based on the explanation, percentages, and comments, that HAVING is the correct answer. ...
September 29, 2017 at 6:58 am
StarTrek Discovery premiered this past week as a new entry in the Star Trek seriesthat has been a part of my life since I was a...
September 29, 2017 at 6:51 am
At previous companies we were assigned an admin account and a regular account. Only used the admin account when necessary. Even on my home machine I do most things from...
September 26, 2017 at 7:23 am
if each calendar has a different name, then the CalendarName in DimCalendar is the column you need to filter on for each query / cube you setup against this...
September 25, 2017 at 12:24 pm
In Kimball Group Reader, on page 339, they talk about "Multi-Enterprise Calendar Dimensions" which is what I believe you are trying to implement.
Yes, this is what...
September 25, 2017 at 11:36 am
Well, I may be getting ahead of myself here. I'm not really focusing on Kimballs methodology here because regardless if Kimball posted an article on not, I'm more focused...
September 24, 2017 at 5:37 pm
Anyways, my question would be how do you filter for the right calendar with OrderDateKey (FactSales) -> DateKey (DimDate) -> DateKey (DimCalender) when the CalendarKey does not exist...
September 22, 2017 at 8:39 am
Well, if you have multiple business units sharing the DimDate table, then you copy over 365 records (i.e.: one record per day indexing on the date key) for each...
September 22, 2017 at 7:20 am
I do however support multiple fiscal calendars, but that's easily solved if they are all using the same fields, but a key to filter their fiscal based on the...
September 21, 2017 at 5:40 am
I have to admit to Googling the various normal forms. Normalising data structures and knowing why I am doing it is something I just do.
The descriptions...
September 20, 2017 at 9:26 am
Sometimes I'll ask myself what is ACID or try to go through the Normal Forms. If I can't, I review. If I were to ask this question in the interview,...
September 20, 2017 at 5:00 am
Are you using the CalendarName column in DimCalendar to filter the results to give the 1:1 relationship to DimDate?
Beyond setting the property as non-aggregatable and setting a default,...
September 13, 2017 at 7:12 pm
Actually, I think there are two very short word/phrase that atually go further than that sentence: learn to say "please" and "thank you"; even if you say something...
September 4, 2017 at 8:13 pm
Viewing 15 posts - 316 through 330 (of 1,354 total)