January 18, 2011 at 12:42 pm
I have a Date Dimension table in the DSV, then created the Dimension for it (Dim Date). When I finally got my cube to process, the Date Dimension didn't show up in the cube browser.
Now, I am using Dim Date as the Time dimension, but would this cause it to not show up in the browser for me to move date parts into the column list?
I'm very confused here. But I will note, two of my other dimension tables have dates in them, and the Fact table has several dates in it. Would connecting all of these to DimDate cause it not process properly?
January 19, 2011 at 6:49 am
I should add that this Date table is based off a Named Query pre-exists in the DSV, so it's not one I'm creating from scratch.
January 19, 2011 at 9:14 am
GAH. My boss figured it out.
Had to go into Dimension Usage on the cube screen, right click in the "white space" and add new cube dimension.
But I don't know why it didn't add it when the cube originally processed.
January 19, 2011 at 9:28 am
damn those bosses huh 😉
Just FYI on the Dim Usage tab, this is where you can implement role playing dims too, so if you have this date dimension already in use, you can add it again (and again etc etc), just giving it a different display name each time. The other key factor is to join it to the/a measure group using a different date column (ie the one date dim can be used for say Order Date, Delivery Date, Dispatch Date etc).
Steve.
January 19, 2011 at 9:29 am
Hmm, sorry no one tried to help Brandie, but I suspect that not many of us (including myself) on this site know a lot about cubes yet. Hey, then maybe you can be our BI Guru! :w00t:
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
January 20, 2011 at 12:11 am
Brandie Tarvin (1/19/2011)
GAH. My boss figured it out.Had to go into Dimension Usage on the cube screen, right click in the "white space" and add new cube dimension.
But I don't know why it didn't add it when the cube originally processed.
When something doesn't work in a cube, I usually check the dimension usage tab first. 90% of the time it is there where I screw up 🙂
SSAS doesn't add the dimension itself to the cube, unless you used the cube wizard.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2011 at 4:49 am
Cube wizard will just provide a "doable" structure. Good for learning. Cannot be used for live systems/projects 🙂
Raunak J
January 20, 2011 at 5:45 am
Koen (da-zero) (1/20/2011)
SSAS doesn't add the dimension itself to the cube, unless you used the cube wizard.
I did use the cube wizard. That's what was so frustrating. No matter how many times I went through it, trying different options, the wizard added every dimension by the DimDate.
And I couldn't figure out what. Still don't know why. I just know how to fix it when it happens in the future.
January 20, 2011 at 5:45 am
Raunak Jhawar (1/20/2011)
Cube wizard will just provide a "doable" structure. Good for learning. Cannot be used for live systems/projects 🙂
I'm curious. Why do you say it can't be used for live systems or projects?
January 20, 2011 at 6:38 am
Brandie Tarvin (1/20/2011)
Koen (da-zero) (1/20/2011)
SSAS doesn't add the dimension itself to the cube, unless you used the cube wizard.I did use the cube wizard. That's what was so frustrating. No matter how many times I went through it, trying different options, the wizard added every dimension by the DimDate.
And I couldn't figure out what. Still don't know why. I just know how to fix it when it happens in the future.
Ah. Indeed very frustrating. And you couldn't select the dimension in the "Select Existing Dimensions" screen in the wizard?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2011 at 6:40 am
Brandie Tarvin (1/20/2011)
Raunak Jhawar (1/20/2011)
Cube wizard will just provide a "doable" structure. Good for learning. Cannot be used for live systems/projects 🙂I'm curious. Why do you say it can't be used for live systems or projects?
I think there is no escape using the cube wizard. If you select "create new cube", the wizard is automatically launched.
However, I believe it is better to create your dimensions first and then the cube, instead of letting the cube generate the dimensions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2011 at 6:43 am
Even better. I think I was misquoted for the wizard stmt. My bad. 🙂
Raunak J
January 20, 2011 at 8:07 am
Koen (da-zero) (1/20/2011)
Brandie Tarvin (1/20/2011)
Koen (da-zero) (1/20/2011)
SSAS doesn't add the dimension itself to the cube, unless you used the cube wizard.I did use the cube wizard. That's what was so frustrating. No matter how many times I went through it, trying different options, the wizard added every dimension by the DimDate.
And I couldn't figure out what. Still don't know why. I just know how to fix it when it happens in the future.
Ah. Indeed very frustrating. And you couldn't select the dimension in the "Select Existing Dimensions" screen in the wizard?
This is 2k5. It has "Identify Fact and Dimension Tables" and Review Shared Dimensions" screens, but not a "Select Existing Dimensions" screen. And in the first, I did choose the Date table, along with everything else.
January 20, 2011 at 8:09 am
Koen (da-zero) (1/20/2011)
I believe it is better to create your dimensions first and then the cube, instead of letting the cube generate the dimensions.
All my dimensions were created prior to using the Cube Wizard. So that wasn't the problem.
In fact, I couldn't create the cube at first because I forgot to create any dimensions. When I figured that out, I just created all of them at the same time.
January 20, 2011 at 1:45 pm
Brandie Tarvin (1/20/2011)
Koen (da-zero) (1/20/2011)
Brandie Tarvin (1/20/2011)
Koen (da-zero) (1/20/2011)
SSAS doesn't add the dimension itself to the cube, unless you used the cube wizard.I did use the cube wizard. That's what was so frustrating. No matter how many times I went through it, trying different options, the wizard added every dimension by the DimDate.
And I couldn't figure out what. Still don't know why. I just know how to fix it when it happens in the future.
Ah. Indeed very frustrating. And you couldn't select the dimension in the "Select Existing Dimensions" screen in the wizard?
This is 2k5. It has "Identify Fact and Dimension Tables" and Review Shared Dimensions" screens, but not a "Select Existing Dimensions" screen. And in the first, I did choose the Date table, along with everything else.
Dammit, you're right. I checked it on a 2008 installation.
But anyway, I still have no idea why it didn't work in the first place.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply