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 |
|
learntsql
524 Posts |
 Posted - 2010-02-02 : 08:01:24
|
| Hi..I am developing SSAS project.Can We have NULL Values in Fact Table?Currently i am maintaining in fact table values as if sales happen it puts salesamount against that Store else NULL.Is this correct way?But while deploying i am getting error as Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Sale_KEY of Dimension: Store1 from Database: SalesCube, Cube: SalesCube, Measure Group: FactStoreSales, Partition: FactStoreSales, Record: 2. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-02 : 09:38:55
|
| nope. if no sales means it should be 0 rather than NULL.NULL value causes problems in cube. |
 |
|
|
learntsql
524 Posts |
Posted - 2010-02-02 : 23:34:31
|
| Thanks Visakh,Any article on this please. |
|
|
|
|
|
|
Can We have NULL Values in Fact Table