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 |
|
Indyyan
Starting Member
31 Posts |
 Posted - 2004-07-16 : 06:19:48
|
Hello!!I have allready established the connection to the database.Now I want to define a cube with the Wizard, but if I click on one of my tables i get the failure message "The selcected table lacks required numeric columns".The only failure i can imagine is, that i only have fields with datatype: VarcharCan somebody help me, thanks a lot  |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-07-16 : 19:18:34
|
| you need atleast one numeric datatype in the fact table, otherwise you cannot create a cube.-ec |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2004-07-17 : 03:53:08
|
| No you don't. Certainly you'll only be able to have Count measures if you don't have any numeric columns, but it's perfectly possible to create such a cube. Just not with the wizard. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-07-17 : 10:25:52
|
quote:
Originally posted by Arnold Fribble
No you don't. Certainly you'll only be able to have Count measures if you don't have any numeric columns, but it's perfectly possible to create such a cube. Just not with the wizard.
correct. I should have been more specific, but the question was regarding creating a cube using the wizard.-ec |
|
|
|
Indyyan
Starting Member
31 Posts |
Posted - 2004-07-19 : 04:15:12
|
| Thanks for the help, I created such cube with the editor but then emerged another problem.I added one fact table and one dimension table, but after saving this Cube i could not process it. The defined Dimensions should not be a problem, but i´m not sure about the measures.I defined 6 different measures but all of this have often "0" as value. Can this fact be the problem. Or is there any other reason???Thanks Jan |
|
|
|
jojo_jacob
Starting Member
24 Posts |
Posted - 2004-07-19 : 04:25:05
|
| Can you please provide the exact error message? |
|
|
|
Indyyan
Starting Member
31 Posts |
Posted - 2004-07-19 : 10:02:16
|
| The first error message i get if i process the cube is:Processing Dimension 'Please' failed. No changes have been made to the database.(i called the cube Please... i mean Please work)the next error message is:Data source provider error: ; Time:2004-07-19 15:58:36i´m not sure perhaps there something wrong with the data source, but i can test the connection without a error and i can also refresh without any failure messageThanks for the Help!!!Jan |
|
|
|
|
|
|
The selcected table lacks required numeric columns