Thanks for the reply.

We've raised a support ticket with Microsoft, and they have confirmed that there is a memory leak during the hash table build.

We've found other design patterns that...

Have you thought of using SSIS and the RS scripting utility?

I developed a solution using that technique to render PDF versions of a specific report once per month.

Do some...

sneumersky (2/3/2014)

---

One thing I forgot to mention (because I didn't want to force you into that path).....a drillthrough action can get you the most detailed cube data. Are you familiar...

In case anyone has a similar problem: the solution that ended up working was a combination of the UNION and CROSSJOIN functions in the FROM clause of my MDX. Importantly,...

sneumersky (1/31/2014)

---

Defeating the purpose of SSAS IMO.....but try this:

In pseudocode...

NonEmpty( (Day Level of Date Dimension) * (Seattle Member of Departure City) * (Seattle Member Of Arrival City)

)

ON ROWS

FlightTime

ON COLUMNS

FROM [YOUR...

sneumersky (1/31/2014)

---

If you just wanted one cell to display as an answer, I would put the destination city member of Seattle and the departure city member of Seattle in the...

sneumersky (1/31/2014)

---

If you just wanted one cell to display as an answer, I would put the destination city member of Seattle and the departure city member of Seattle in the...

sneumersky (1/31/2014)

---

Off topic a bit:

Also, from a design perspective, I would have only one PHYSICAL dimension for the airport and use role playing dimensions.....one for the departure city and one...

sneumersky (1/31/2014)

---

Do you need to display one sum of flight time for the whole set of 2 members collectively; or, do you need to group the data in a different...

My pleasure, Woody. I have learned and gained much from the SQL community - hopefully someone finds this interesting...

Jeff Atherton (10/10/2013)

---

Great Article. Thanks for sharing your experience. I've been thinking about getting into BI but it sounds like I'll really need to prepare myself if I decide to...

Greg Edwards-268690 (10/10/2013)

---

Great article! Coming from the BI side, I can see now you understand just how different it can be from the old SQL world. Some of it requires...

I totally agree that 'fit' is at least as important as technical acumen. To that end, I try to create a scenario during an interview with a candidate where I...

Joe - definitely go with Dedicated dev environments for RedGate's SQL Source Control. They've got quite a few resources on their website that explain the differences (videos, whitepapers, etc), but...

I'm with Ben. I invested the time and money in RedGate's SQL Source Control several years ago, and have never looked back. Having not had much experience with source control...