Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ProgrammerX
Starting Member
1 Post |
 Posted - 2009-08-06 : 08:38:47
|
| Hi there,I'm doing a migration from ssas 2000 to ssas 2008. Many things have changed since then so this is all very new to me and i must say a lot more complicated. I tried to use the migration tool that came with ssas2008 but i've noticed that it doesn't do the best job at converting and when i try to process my cube i get numerous errors where i have no clue what they mean and where to start (is it me or do the errors give little to no real info about what the problem is?)So i started just building a small cube to experiment a little and see how things work. This went pretty well and i've learned much by doing it. The problem i've run into now however is a strange one for me. When i make a cube with 1 measure (simple count of rows of my fact table) and 1 dimension which is a field out of my fact table (for simplicity reasons i'm only using my fact table and that's it). When i process this and look in the cube browser everything looks fine.The real problem starts when i start to add more dimensions. When i add 1 more dimension out of my facttable everything still processes fine and all, but when i go to the cube browser and select the same measure and dimension i did earlier i don't see any numbers for some reason just empty cells. Only when i add the second dimension to the browser, i start to see numbers again. As you may have guessed this continous with 3 dimensions and so on. I can add some screenshots if my problem description isn't clear.Another smaller problem i have is that i used to use the DatePart function on some datetime fields to extract the month and year (this was used to build a hierarchy with Years->Months). I've noticed that you can't type anymore in the datafield value field. I've experimented a bit with the Type property to change it from Regular to say Years in Calendar, but i don't think this is the way to go.Is there any information in general for people who come from ssas2000, since i'm feeling overwhelmed by the new options/functionality :)Thanks in advance for any help on the subjects!With kind regards,Chris Arets |
|
|
|
|
|
Data gone in cube browser unless i use all dimensi