为什么我的措施在SSA中的Molap Cube中恢复为无效？
我有一个相当简单的结构的立方体：
我的测量值也很简单，我只有一个总和和计数。
但是，当我尝试部署立方体时，它会返回测量值的空值：
如您所见，我甚至不得不启用显示空细胞，否则它甚至都不会显示任何结果，只说“找不到行。单击以执行查询。”。即使我尝试简单地检索Student_ID或任何其他列而不使用任何测量值，除非我切换“显示空单元格”按钮，否则我会发现无行的语句。
这样做的原因是什么？
我检查了是否启用了所有维度的聚合，这是。桌子之间的连接也可以，我一一检查一下，即使在实践中，您也可以看到从老师和学生中选择的方式都很好：
也值得一提的是，以前的Cube是在职的。我尝试添加一些计算，然后一旦我注意到该立方体无法正常工作。目前，立方体中只有测量值，但仍无法正常工作。
I have a cube with a fairly simply structure:
My measurements are also very simple, I just have a sum and a count of the grades.
However when I try to deploy the cube, it returns null values for the measurements:
As you can see, I even had to enable show empty cells, otherwise it wouldn't even show any results and just state "No rows found. Click to execute query.". Even if I try to simply retrieve the student_id for example or any other column without using any measurements, I get the no rows found statement unless I toggle the "Show empty cells" button.
What could be the reason for this?
I checked if aggregation was enabled for all dimension and it was. Connections between the tables are also okay, I checked it one by one and even in practice you can see how selecting both from teachers and students works perfectly well:
It's also worth mentioning that previously the cube was working. I tried adding some calculations then removed them once I noticed that the cube wasn't working properly. Right now there are only measurements in the cube but it still doesn't work as expected.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我遇到了这个问题，我的措施和计算运作良好，然后开始返回“（null）”，就像在您的屏幕截图 @Kevin-Eldurson中一样。
我提出的一个问题是无意中从计算脚本的顶部删除“计算”命令。
'我发现，当我为我的测量组创建一个新分区时，数据再次返回。尝试转到.Cube文件的“分区”选项卡，并为您的度量组创建一个分区。
I ran into this issue where my measures and calculations were working great and then started to return "(null)", exactly like in your screenshot @kevin-eldurson.
One issue I made was unintentionally removing the "CALCULATE" command from the top of the calculations script. measure not showing data after calculations created
After that did not resolve my issue I found when I created a new partition for my Measure Group, data was returned again. Try to go to the Partition tab of your .cube file and create a partition for your Measure Group.