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 |
|
akmrfleck
Starting Member
2 Posts |
 Posted - 2003-05-16 : 17:16:26
|
| I have a fact table I need to do some calculations on and am having a hard time visualizing what I need to do. I am new at Analysis services. the fact table has a bunch of columns grade, rs1, rs2, rs3, rs4, rs5 etc. These are scores such as 03,72,85,25,45,65,82 etc.There is another table with what these scores mean. This table has grade, category, advanced,profcient,belowprofcient. The catagory relates to the columns in the fact table rs1, rs2, etc What I need to summarize is if the record is a third grade record, look at the rs1 score, go find third grade in the other table, look at the category column for the rs1 scores and if the fact score is <= belowProfcient, they are below, if <= advanced and >= prof they are profcient. If >= advanced they are advanced. I need to have the cube summarize by grade and rs1, rs2 etc... if they are bp, prof or advanced.To try to clarify as the above is a bit confusing, here are a couple of rows in eachfactTable:grade rs1 rs2 rs3 rs4 rs503 52 64 85 45 2506 45 48 54 85 22Score Key Tablegrade Category advanced prof below prof03 rs1 85 65 3203 rs2 75 60 3803 rs3 78 62 4506 rs1 68 54 3206 rs2 78 62 31Any help is appreciated!Thanks,Mike |
|
|
|
|
|
|
|
Cube Calculation Problem