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 |
|
burkaans
Starting Member
8 Posts |
 Posted - 2005-10-20 : 06:21:19
|
| Hello, all!I am new to OLAP Cubes. I have a SQL Server 2000 DB and have installed SQL Analysis Services. In the table "Contracts" is the information about contract times for the "Person" – Contract_Start_Date and Contract_End_Date. I have defined dimensions for OLAP Cube, have created a "Time" table (Time_ID, Date, Month, Year). I would like to have a fact table with information about persons with contract and days left to the end of the contract. How can I create/define fact table? Thanks in advance!Burkaans |
|
|
anuj164
Starting Member
49 Posts |
Posted - 2005-10-20 : 16:51:34
|
| you want to store data per day in the fact tables; if i try to Visualize what you have mentioned; then contract id, days left, time_id in the fact table can solve your problem.Good Luck |
 |
|
|
|
|
|
Creating OLAP Cubes