January 24, 2011 at 5:27 am
Darnit!
I've got the table in the cube, but I just realized it doesn't appear to be hooked up with the rest of the data.
Every year from 1900 - 2076 shows the exact same amounts and counts. The records just repeat for every year. So adding DimDate to Dimension Usage doesn't help me.
To clarify, the Date table has an integer PK and the tables that link to it use that PK for their "date" columns. So "SoldDate" on the Fact table would equal 40284(for example) which, in the Date table, is the PK for 04/18/2010.
Would this cause a problem in SSAS? Or am I looking at the wrong thing to determine the cause of my issue?
January 24, 2011 at 5:47 am
Brandie Tarvin (1/24/2011)
Darnit!I've got the table in the cube, but I just realized it doesn't appear to be hooked up with the rest of the data.
Every year from 1900 - 2076 shows the exact same amounts and counts. The records just repeat for every year. So adding DimDate to Dimension Usage doesn't help me.
To clarify, the Date table has an integer PK and the tables that link to it use that PK for their "date" columns. So "SoldDate" on the Fact table would equal 40284(for example) which, in the Date table, is the PK for 04/18/2010.
Would this cause a problem in SSAS? Or am I looking at the wrong thing to determine the cause of my issue?
Usually when a measure is repeated over all the rows, it is because I screwed up in the dimension usage tab.
How is the relationship between the date dimension and the fact table defined in the dimension usage?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 24, 2011 at 8:13 am
Koen (da-zero) (1/24/2011)
Usually when a measure is repeated over all the rows, it is because I screwed up in the dimension usage tab.How is the relationship between the date dimension and the fact table defined in the dimension usage?
You're right, we forgot to add that. But I think I've found out why choosing the table in the Wizard didn't bring the table in the cube. Every time I try to define the relationship in the Dimension Usage tab, SSAS will not let me define a DimDate.TimeKey to FactTable.TimeKey relationship.
I've defined this relationship in the DSV, so I don't get why it won't let me define it in the DU tab. I guess I need to go back and futz with the DSV more to see if I can find the problem.
January 24, 2011 at 10:10 am
Hey Brandie, when you say that BIDS won't let you, does it return any sort of error message or warning with this?
Steve.
January 24, 2011 at 10:25 am
stevefromOZ (1/24/2011)
Hey Brandie, when you say that BIDS won't let you, does it return any sort of error message or warning with this?
No, actually. That's what has me so frustrated. It processes the cube as if nothing is wrong, but the DimDate table just doesn't show up.
When I look in Dimension Usage (after processing), add DimDate, then click in Measure Groups to connect it, TimeKey just isn't available except as a Granularity Attribute. No matter what I put in Granularity, it's no available to match down in the relationship section of the window.
I think rather than editing my current DSV, I'm going to create a new one from scratch and see what happens from that. Maybe I did something wrong in the first one.
January 24, 2011 at 12:06 pm
Homer Simpson "DOH!" moment.
I created DimDate as a normal dimension, not a Time Dimension. No wonder I couldn't get it to pull into the cube properly.
Well, I won't make THAT mistake again.
January 24, 2011 at 11:59 pm
Brandie Tarvin (1/24/2011)
Homer Simpson "DOH!" moment.I created DimDate as a normal dimension, not a Time Dimension. No wonder I couldn't get it to pull into the cube properly.
Well, I won't make THAT mistake again.
Glad you found the issue. 🙂
Is everything working OK now?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 25, 2011 at 6:58 am
It seemed to be at first glance, until I realized I forgot to add dimension attributes to the new dimensions in my new cube build. So I'm starting once again from scratch and building a new cube.
Sometimes I just need to repeat a process several times for the information to stick in my head. Good thing this is a Dev project at the moment. @=)
I'll let everyone know if I still need help with this. Cube is processing right now. Thanks to all for the advice you've given. It has helped me learn a few things.
Viewing 8 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply