Unfortunately I still have not gotten this entirely figured out...

I have a little more understanding of how MDX is working, but obviously still not even an intermediate in it.

The problem...

Yeah, I just noticed I forgot that on there 🙁 Ugh.! Thanks 🙂

Hmm I don't think so. The division is there to properly calculate our forecast actuals and needs to be applied across the board. I had attempted to do...

Haha yeah, sorry about that...ugh. The pseudo is not strong in this one.

Yeah, not quite there yet. A large part of it is that I am pretty new to MDX.

Pseudo code would be:

for every member of product

divide x by y

only...

Thanks...I have it almost figured out, but what's odd is putting in my filter for the value is what's throwing it off now. The IsLeaf is working, it's calculating,...

We are essentially trying to calculate how much revenue is generated per unit filtering it down to a specific branch of a product. Seems like this should be really...

Yeah, this will take a while...seems like it might be overly cumbersome in terms of code as we are trying to keep our calculated members pretty concise as we have...

Thanks for the quick response. I'll start looking into those right now and hopefully be able to fix my errors 🙂

There's quite a bit of documentation in books online, as well as blog posts on using the new features in 2012 SSIS.

The $ sign is a new addition for accessing...

PocketJoshua (1/26/2012)

---

It is interesting to see such an article published on a home grown process framework.

What is interesting to me is how close this solution is to the one...

For...