When you’re developing attributes that have a bunch of members, let’s say more than a million (1,000,000,000), you should definitely use numeric keys. Don’t use strings or anything like that or you will suffer delays. With business intelligence cube development we’re talking about airport length delays here! So next time you’re tearing through some ETL... Continue reading →

So here I am plugging in some dimensions and getting some measures in Visual Studio when I stumble on the fact that I can’t get the MDX from what I’m doing. What should I use to do this? One tool I know that will get the MDX for a report is ProClarity, but are there... Continue reading →