For example , the pivot currency can be set to united states dollars , and the fact table stores transactions in usd 例如,先导货币可以设置为美元( usd ) ,而事实数据表使用usd来存储事务。
Surrogate keys are artificial keys that link dimension and fact tables and that are used to ensure uniqueness and to improve performance 代理键是链接维度表和事实数据表的假键,用于确保唯一性并提高性能。
Transactions are stored in the fact table in the pivot currency , and then converted to one or more other reporting currencies 一对多交易以先导货币存储在事实数据表中,然后换算为一种或多种其他报表货币。
Analysis services now supports many - to - many relationships between fact tables and dimension tables by using association tables 通过使用关联表, analysis services现在支持事实数据表和维度表之间的多对多关系。
When processing fact tables , earlier versions of analysis services ignored rows that contained an undefined member for a dimension 在处理事实数据表时,早期版本的analysis services忽略包含未定义维度成员的行。
Dialog box in business intelligence development studio to specify the source of fact table data for a partition 使用business intelligence development studio中的“分区源”对话框,可以为分区指定事实数据表数据的源。
For example , if you are loading data into a star schema , you can build a separate package to populate each dimension and the fact table 例如,如果将数据加载到星型架构中,则可以生成一个单独的包来填充每个维度和事实数据表。