我正在尝试用JASPER编写MDX查询,但结果与所有工具(SSMS、SSRS、MDX STUDIO)和Jasper不同。查询是度量与维度和计算总数
查询:
WITH
//GET Average of TOTAL_MONTHLY_INCOME_VALUE FOR ROWS
MEMBER [DIM_SECTOR_OF_WORK].[SECTOR_GROUPED].[TOTAL] AS
Aggregate
(
{
[DIM_SECTOR_OF_WORK].[SECTOR_GROUPED].[SECTOR_GROUPED].ALLMEMBERS
}
)
SELECT
NON EMPTY
{
[Measures].[Average of TOTAL_MONTHLY_INCOME_VALUE]
} ON COLUMNS,
NON EMPTY
UNION
(
[DIM_SECTOR_OF_WORK].[SECTOR_GROUPED].[TOTAL],
[DIM_SECTOR_OF_WORK].[SECTOR_GROUPED].[SECTOR_GROUPED].ALLMEMBERS
)
ON ROWS
FROM [Model] SSRS、SSMS、MDX Studio中的结果是:

jasper Studio中的结果是:

任何人都可以帮助我如何获得与SSRS结果相同的结果
发布于 2020-08-27 20:26:56
如果将集合转换为WITH子句,会有帮助吗?
WITH
//GET Average of TOTAL_MONTHLY_INCOME_VALUE FOR ROWS
MEMBER [DIM_SECTOR_OF_WORK].[SECTOR_GROUPED].[TOTAL] AS
Aggregate
(
{
[DIM_SECTOR_OF_WORK].[SECTOR_GROUPED].[SECTOR_GROUPED].ALLMEMBERS
}
)
SET [x] AS
{
[DIM_SECTOR_OF_WORK].[SECTOR_GROUPED].[TOTAL]
,[DIM_SECTOR_OF_WORK].[SECTOR_GROUPED].[SECTOR_GROUPED].ALLMEMBERS
}
SELECT
NON EMPTY
{[Measures].[Average of TOTAL_MONTHLY_INCOME_VALUE]} ON COLUMNS
,NON EMPTY
[x] ON ROWS
FROM [Model];https://stackoverflow.com/questions/63469270
复制相似问题