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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-21 : 07:03:17
|
| Gennadiy writes "Hi,I'm trying to create cube from huge and ugly structured database. To get useful data I need to restrict fact table (it has approx. 600000 rows), and I'm doing it setting cube property Source Table Filter into [field]=[value]. So Fact Table Count shows right number of rows - approx. 160000. But whenever I process the cube - it processes all 600000 rows and I simply don't understand why. Would be grateful for response. Gennadiy" |
|
|
JenniferS
Starting Member
5 Posts |
Posted - 2003-04-06 : 17:48:24
|
| Gennadiy,Do you get all rows showing up in your cube or just the filtered data?JenniferS |
 |
|
|
|
|
|
When Cube is processing - Source Table Filter for the Fact Table is simply ignored.