Viewing 15 posts - 1 through 15 (of 23 total)
I'm assuming the months are in order in your time dimension, so that record ID basically served as the MonthNo I mentioned. It just provided a number to order...
June 24, 2011 at 6:49 am
You need to make sure that attribute of the dimension is sorted by a key. I usually put a NumberOfMonth column in my date/time dimension of 1-12, and you...
June 23, 2011 at 6:11 pm
When you say from BIDS/VS - I assume you mean SSIS? You should be able to use simple SSIS logging for this, and that can be stored in a...
June 23, 2011 at 6:09 pm
I'm going to take a stab at this - though I'm not sure I understand what you're asking...
If you have different fact tables, they should be able to use the...
June 23, 2011 at 6:07 pm
I did something like this for now on the smaller rolling 30 day fact table-
http://gopika-lasitha.blogspot.com/2010/05/how-to-combine-two-fact-tables-in-ssas.html
It seems like there's a more intuitive relationship there - is there one, or...
June 23, 2011 at 6:00 pm
So a few days later, I ended up solving my own problem, but I wanted to post the answer in case somebody finds this later. My issue was that...
May 26, 2011 at 7:40 am
Thanks Raunak! Just wanted to make sure, and I'll also make sure I direct my questions to the right forum next time.
October 8, 2010 at 6:48 am
Sorry it took so long to respond to this everybody.
We ended up pulling the max date out of the dimension, then only loading records newer than that. In the...
October 8, 2010 at 6:47 am
Thanks everybody!
Basically, we ended up filtering the records into an array and eliminated the null records. It seemed to work great!
October 8, 2010 at 6:45 am
Thanks for the reply Paul. I've queried both for a specific ID, and the fields do come back the same. Any other suggestions?
July 20, 2010 at 5:39 am
Ok, so after looking at the OpenRowSet Bulk option and creating an XML format file, that does seem like a very feasible option. I want to post the report...
July 16, 2009 at 10:40 am
Thanks so much for the info. I'll be doing some research into that stuff and I'll try to post back later once we've established the solution.
July 1, 2009 at 7:44 am
StevefromOZ - Yes, one of the sheets is manual entry and the other is a report that comes from a different federal gov't organization, so I can't speak as to...
July 1, 2009 at 6:04 am
Viewing 15 posts - 1 through 15 (of 23 total)