August 11, 2011 at 1:07 pm
Greetings all 😀
I am alright with cubes at a basic level but adding additional functionality is a bit over my head still. After much research and experimentation, I finally managed to add a distinct count to my cube that works on the specic dimension I created it on. The problem is doing this across multiple dimensions does not work right.
Basically I am getting a count of customers. Which works if I toss in say 'customer region' as a row, it will give me the distinct count in each region which is expected. But this is in a sales type Cube, so if I wanted to split this by Month or year, the count does not seem to work right.
I have tried playing with the dimension usage tab to see if I can massage this into working, but after 2 hours of playing with it, I am still at a loss. Can someone please explain how to do this? There is no direct relation between the customer table and the date dimension, so this has become rather difficult 😀
Link to my blog http://notyelf.com/
August 11, 2011 at 1:39 pm
Also, I am using SQL Server 2008 if that helps 🙂
Link to my blog http://notyelf.com/
August 11, 2011 at 2:01 pm
Nevermind I am an idiot :w00t:
For some strange reason I had it in my head that the distinct count would have to be unique across multiple dimensions...after writing several sql validation scripts against my database I realized that the distinct counts were returning resuts exactly as expected :-D.
I think I have been looking at these cubes too long :hehe:
Link to my blog http://notyelf.com/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply