Error: 50200, SQLState: HYT00
[sonar:sonar] 20:20:34.363 ERROR - Timeout trying to lock table "PROJECT_MEASUREScreated_at as col_0_0_, measuremod0_.metric_id as col_1_0_, measuremod0_.value as col_2_0_ from project_measures
我们使用的是hyperion,但是这个简单的mdx导致了错误:“未知-查询中使用的成员measures.unit_name”。为什么?hyperion中是否提供了"Measures“?WITH MEMBER [Measures].[Unit_Name] AS '[Organization].currentmember.member_name'
[Measures].
我有一个使用MDX查询从SSAS多维数据集获取数据的数据集,我执行并确认MDX查询在SSMS查询设计器中检索度量值。但是,当我将字段拖到SSRS报告中的Table上时,只显示维度值,而不显示度量值(显示为空)。我在过去的两天里才开始遇到这个问题。在此之前,报告在Visual Studio 2017中正确显示值。
.&[170],[Measures].[Quantity]) MEMBER [Measures].[Phobio Trade-In] AS ([Measures]..&[118],[Measures].[Quantity]) MEMBER [Measures].[New HUM] AS ([Measures].[Sam S9 and S9 Plus], [Measures].[Gizmo], [Measures].[Gizmo watc