我的多维数据集浏览器不显示度量值？
我已经执行了 ETL 操作，创建了一个数据仓库，并将数据加载到其中，到目前为止一切正常。我的 ETL 似乎工作正常，因为我的数据仓库包含我需要的所有数据。然后我按照 AdventureWorks DW 示例从我的数据仓库创建了一个 SSAS 项目。我部署了多维数据集并对其进行了处理。然后我尝试浏览立方体。但这里有一个问题，看似成员确实存在，但措施却是空的。因为我的维度包含数据，但是当我将测量值扔给它时..它只是空单元格。是什么原因造成的？
I have performed ETL operation and i created a data warehouse and i loaded the data to it and so far its fine.. my ETL seems to work allright since my data warehouse contains all the data i needed. And then i created an SSAS project from my data warehouse following the AdventureWorks DW example. I deployed the cube and processed it. Then i tried to browse the cube. But here is a problem, it seems as the members do exist but the measures are empty. because my dimensions contain the data but when i throw the measures to it .. it is just gonna be empty cells. What causes this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
在多维数据集设计器中，检查“维度使用”选项卡。确保维度和度量值组之间存在交集（如果存在关系）。
如果您拖动 & 会发生什么？将测量值拖放到浏览器中，没有任何尺寸？
另外你用的是什么版本的SSAS，是2005年的吗？我认为 IgnoreUnrelatedDimensions 设置与 2008 年不同。
In the cube designer, check the "Dimension Usage" tab. Make sure that the intersection between a dimension and a measure group has something there (If there's meant to be a relation).
What happens if you drag & drop the measure to the browser, without any dimensions?
Also what version of SSAS are you on, is it 2005? That had IgnoreUnrelatedDimensions set differently to 2008 I think..
确保您已将维度与度量值组链接起来（即事实表引用维度表）。
还要确保在数据仓库中定义了外键（只要 Visual Studio 中的向导在建议多维数据集结构时使用它们）。
Make sure you've linked your dimensions with measure groups (i.e. that you fact table references you dimension tables).
Also make sure you have foreign keys defined in your data warehouse (as soon as wizards in Visual Studio use them when proposing cube structure).
为了部署到不同的 dwh 服务器，
右键单击 CubeNAME
转到属性
在配置属性 > 中转到
“正在处理中的部署”选项 - 将“默认值”更改为“不处理”。
如果数据库非常大并保存大量数据，它将被部署，您可以稍后处理它。
对于目标 - 设置服务器名称
，单击“确定”、“部署”和后续过程
In order to deploy to a different dwh server
Right Click on the CubeNAME
Go to properties
In Configuration properties > Go to Deployment
In Processing option - change Default to - Do not Process.
if in case the DB is very large and keep huge data, it will get deployed and you can process it later.
For Target - Set name of Server
Click on OK, Deploy and later process