Viewing 15 posts - 1 through 15 (of 49 total)
Jim1234 (1/28/2014)
We need process a cube dimensions incrementally. Only for first load of the dimension table all the dimensions in the cube need to be processed after that when...
January 28, 2014 at 12:51 pm
Jim1234 (1/28/2014)
We need to partition our cube dynamically based on year and period(ex 201306). So when there is a data load/update is happening in the fact only the particular...
January 28, 2014 at 12:43 pm
I think at the moment it's probably still more value to have your BI cubes locally, unless most of your IT architecture lives in the cloud, it's going to be...
August 29, 2013 at 2:22 pm
Wanted to raise this back up as it's still a challenge.
August 22, 2013 at 3:11 am
Sorry, I wasn't clear enough - I am not trying to execute packages, I want to execute whole projects. Each project will have packages within it, deployed as a project....
April 5, 2013 at 12:17 pm
Ahhh figured it out when checking bypassing the bootstrap (thank you for that suggestion). The local dev box is currently running in 32bit, and MDS is 64bit and doesn't exist...
January 3, 2013 at 9:22 am
sam.dahl (6/5/2012)
A M:1 relationship from dimension to fact.
A dimension tracking events.
I'm getting a Mr Squiggle feeling here.
Your case events log table sounds an awful lot like a fact...
June 5, 2012 at 11:31 am
CaseID + Formname + Name is indeed always unique. Thanks so much for the help here people, even though (after reading Jeff's ettiquette article) my question was poorly presented. Will...
June 4, 2012 at 9:57 am
Jeff Moden (6/3/2012)
ProKelly (5/31/2012)
I cannot seem to do this with pivot, as it want's to aggregate and the responses are text fields. Any clues?
What's wrong with using MAX as the...
June 3, 2012 at 11:31 am
RonKyle (5/31/2012)
May 31, 2012 at 7:40 am
Thankyou for your help here. I did think it would be more of an ETL process than something I could do within SSAS to accommodate the way the structure lies...
May 30, 2012 at 6:37 am
I only have that single fact reference, CaseID, in my fact table so when a case is created, a row is added with CaseID = 10001 and all subsequent case...
May 30, 2012 at 6:07 am
Koen - thanks for your suggestions.
I understand the principle of adding another layer to the fact table to include a Business Key to the case events - honestly i'm reluctant...
May 30, 2012 at 5:31 am
Wait a minute, do you mean you don't use Fuzzy Grouping but...
no i'm only joking. Thought i'd flog that dead horse.
May 25, 2012 at 2:00 am
I did read your original post... but read what I quoted. This component has existed inssis at least as early as SQL server 2005 standard edition, this isn't a new...
May 23, 2012 at 9:30 am
Viewing 15 posts - 1 through 15 (of 49 total)