问题描述
你好
我有一张信息通信技术表格,有很多是,没有人在桌面上的问题
I have a form for ICT that have a lot of YES,NO questions over person table
例如
PERSON_KEY
PERSON_KEY
HAS_COMPUTER
HAS_COMPUTER
HAS_TELEPHONE
HAS_TELEPHONE
HAS_SMARTPHONE
HAS_SMARTPHONE
HAS_LAPTOP
HAS_LAPTOP
HAS_TABLET
HAS_TABLET
HAS_INTERNET
HAS_INTERNET
。
。
。
以及很多YES,NO栏......
and a lot of YES,NO columns...
为SSAS表格设计立方体和星型模式的最佳方法是什么?我应该超过50个redendent diminsion吗?
what is the best way to design the cube and star schema for SSAS tabular... should I pull over 50 redendent diminsion?
或者我应该加入与事实表的diminsion ... 。
or should I join the diminsion with the fact table...
因为ssas不会接受连接同一个表中只有1个diminsion的多个列
since ssas will not accept connecting multiple columns from same table with only 1 diminsion
谢谢
推荐答案
对于星型模式,事实表将通过外键连接到其他维度表。所以我对你的问题不是很清楚,我认为你可以将维度与事实表联系起来。我不知道你将如何使用50个redendent尺寸?它们是一样的吗?
For star schema, the fact table will connect to other dimension table by foreign key. So I am not very clear about your problem, I think you could just link dimension with fact table. I don't know how will you use 50 redendent dimensions? Are them same?
您可以参考 Dimensions - Introduction and
SSAS中的星型架构和Snowflake架构了解详情
You could refer to Dimensions - Introduction andStar schema and Snowflake schema in SSAS for details
最诚挚的问候,
Zoe Zhi
这篇关于设计很多(是的,没有问题)事实和维度的最佳方式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!