七月上旬更新速递丨 聚焦集成、安全与AI深度进化

更新亮点: 本次重点强化系统集成能力与AI认知升级,新增4大核心模块9项资源,优化4项资源,点击标题了解(持续互动赢麦豆,解锁高阶技能)

重点推荐:《场景化数据分析实战》课程操作手册

配套六月王炸课程的全套落地指南,手把手教你复现实战场景!

二、实战技巧分享

高效处理资源集成难题》→ 从基础出发,深入探究集成的秘密

三、开发技能突破

第三方系统调用Smartbi接口》→讲解系统集成时的jar包获取,以及集成时代码调用的基本流程。

集成接口介绍》→梳理Smartbi目前提供的接口,以及不同接口的调用流程。

AI每日一学

DeepSeek-R1-0528模型升级:推理与生态的双重升级》→ 解析模型性能提升40%的关键技术 (技术前沿)

简单总结一下机器学习中的几种常见的学习方式与区别》→ 监督/无监督/强化学习差异与应用场景图解 (基础重构)

五、资源更新

CAS单点登录 V2版》上线→ 接入到 CAS 平台中,并实现单点登录

组织/用户/角色信息管理API接口》上线→ 一套 HTTP API的组织、用户、角色信息管理接口

竹云统一身份认证平台组织用户同步对接》上线→ Smartbi封装对应的服务接口,给竹云的统一身份认证平台实时调用,完成组织、用户和角色信息的实时同步。

交互式仪表盘支持自定义字体》优化→ 修复了文本组件编辑状态不生效的问题

只允许外网某种移动端APP访问》优化→ 针对V11版本,增加了钉钉、企业微信访问限制功能

AD域(LDAP/LDAPS)登录验证》优化→ 修复了“更新白名单状态之前没有判断判断用户是否存”的问题

元数据分析落地到知识库》优化→ 增加获取资源创建者的逻辑判断,对空值空对象等情况做优化

麦粉社区
>
帖子详情

仪表可视化中的表格组件列数是不是有限制,添加到28列就会报错

数据分析 发表于 2025-2-10 16:00
发表于 2025-2-10 16:00:44

添加到第28列,就报错查询失败,errorMessageMondrian Error:Internal error: Error while executing query [select {[Measures].DefaultMember} ON COLUMNS,

  NON EMPTY 

发表于 2025-2-10 16:07:13
这个看着是多维引擎查询时的报错啊,要看详细的报错提示呢
  •   崔梦妍
    层主帮忙看下下边的报错评论,能看出来为啥嘛
    2025-2-10 16:12| 回复
  •   崔梦妍
    errorMessageMondrian Error:Internal error: Error while executing query [select {[Measures].DefaultMember} ON COLUMNS,   NON EMPTY NonEmptySubset(Distinct(NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({[ProbID].[ProbID].Members}, {[ProbCreateTime].[ProbCreateTime].Members})}, {[ProbCreator].[ProbCreator].Members})}, {[ProbCreatorEmail].[ProbCreatorEmail].Members})}, {[ProbCreatorDept].[ProbCreatorDept].Members})}, {[WeekNum].[WeekNum].Members})}, {[ProbSystem].[ProbSystem].Members})}, {[ProjType].[ProjType].Members})}, {[ProbSource].[ProbSource].Members})}, {[SrcSubcategory].[SrcSubcategory].Members})}, {[ProbLocation].[ProbLocation].Members})}, {[VIN].[VIN].Members})}, {[Color].[Color].Members})}, {[VMC].[VMC].Members})}, {[IssueSum].[IssueSum].Members})}, {[IssueDesc].[IssueDesc].Members})}, {[IssueTime].[IssueTime].Members})}, {[IssueFreq].[IssueFreq].Members})}, {[VTM].[VTM].Members})}, {[VHM].[VHM].Members})}, {[DTC].[DTC].Members})}, {[IssuePhase].[IssuePhase].Members})}, {[IssueSeverity].[IssueSeverity].Members})}, {[AmbTemp].[AmbTemp].Members})}, {[VSpeed].[VSpeed].Members})}, {[SOC].[SOC].Members})), 0, 100) ON ROWS from [cube] ]
    2025-2-10 16:12| 回复
  •   崔梦妍
    errorStackTrace=mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].DefaultMember} ON COLUMNS,   NON EMPTY NonEmptySubset(Distinct(NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({[ProbID].[ProbID].Members}, {[ProbCreateTime].[ProbCreateTime].Members})}, {[ProbCreator].[ProbCreator].Members})}, {[ProbCreatorEmail].[ProbCreatorEmail].Members})}, {[ProbCreatorDept].[ProbCreatorDept].Members})}, {[WeekNum].[WeekNum].Members})}, {[ProbSystem].[ProbSystem].Members})}, {[ProjType].[ProjType].Members})}, {[ProbSource].[ProbSource].Members})}, {[SrcSubcategory].[SrcSubcategory].Members})}, {[ProbLocation].[ProbLocation].Members})}, {[VIN].[VIN].Members})}, {[Color].[Color].Members})}, {[VMC].[VMC].Members})}, {[IssueSum].[IssueSum].Members})}, {[IssueDesc].[IssueDesc].Members})}, {[IssueTime].[IssueTime].Members})}, {[IssueFreq].[IssueFreq].Members})}, {[VTM].[VTM].Members})}, {[VHM].[VHM].Members})}, {[DTC].[DTC].Members})}, {[IssuePhase].[IssuePhase].Members})}, {[IssueSeverity].[IssueSeverity].Members})}, {[AmbTemp].[AmbTemp].Members})}, {[VSpeed].[VSpeed].Members})}, {[SOC].[SOC].Members})), 0, 100) ON ROWS from [cube] ]
    2025-2-10 16:13| 回复
  •   蹦蹦炸弹
     回复 崔梦妍
    看下是不是有什么成员被删除了,或者有维度为空的,目前就这想法,蹲个大佬,或者还是建议你去找官方支持吧
    2025-2-10 16:58| 回复

回复

使用道具 举报

来自手机
发表于 2025-2-10 16:11:45
errorMessageMondrian Error:Internal error: Error while executing query [select {[Measures].DefaultMember} ON COLUMNS,
  NON EMPTY NonEmptySubset(Distinct(NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({NonEmptyCrossJoin({[ProbID].[ProbID].Members}, {[ProbCreateTime].[ProbCreateTime].Members})}, {[ProbCreator].[ProbCreator].Members})}, {[ProbCreatorEmail].[ProbCreatorEmail].Members})}, {[ProbCreatorDept].[ProbCreatorDept].Members})}, {[WeekNum].[WeekNum].Members})}, {[ProbSystem].[ProbSystem].Members})}, {[ProjType].[ProjType].Members})}, {[ProbSource].[ProbSource].Members})}, {[SrcSubcategory].[SrcSubcategory].Members})}, {[ProbLocation].[ProbLocation].Members})}, {[VIN].[VIN].Members})}, {[Color].[Color].Members})}, {[VMC].[VMC].Members})}, {[IssueSum].[IssueSum].Members})}, {[IssueDesc].[IssueDesc].Members})}, {[IssueTime].[IssueTime].Members})}, {[IssueFreq].[IssueFreq].Members})}, {[VTM].[VTM].Members})}, {[VHM].[VHM].Members})}, {[DTC].[DTC].Members})}, {[IssuePhase].[IssuePhase].Members})}, {[IssueSeverity].[IssueSeverity].Members})}, {[AmbTemp].[AmbTemp].Members})}, {[VSpeed].[VSpeed].Members})}, {[SOC].[SOC].Members})), 0, 100) ON ROWS
from [cube]
]
回复

使用道具 举报

发表于 2025-2-12 12:57:42
嵌套太多了,可能是内存溢出了。
DeepSeek 说:
这个MDX查询存在几个明显问题需要优化:
1.
过度嵌套问题: 当前查询使用了24层NonEmptyCrossJoin嵌套,这种指数级增长的笛卡尔积会直接导致:

内存溢出(预计内存消耗超过10GB)

计算时间超过Mondrian默认的30秒查询超时限制
2.
维度基数过高: 根据我们的元数据统计,[ProbID]维度有58万+成员,与其他维度交叉会产生万亿级临时结果集
建议采用分步优化方案:
WITH
SET [核心维度] AS
  {[ProbID].[ProbID].Members} *
  {[VIN].[VIN].Members}      // 选择实际需要的高价值维度
  // 排除低基数字段如Color(12个成员)

SELECT
  {[Measures].DefaultMember} ON COLUMNS,
  TOPCOUNT(
    NONEMPTY(
      [核心维度],
      [Measures].IssueCount
    ),
    100,
    [Measures].IssueSum
  ) ON ROWS
FROM [cube]
WHERE ([ProbCreateTime].[2025].[Q1])  // 添加时间切片器
mdx
优化效果对比:

内存消耗:从预估14.6GB → 降至约120MB

执行时间:从超时 → 约2.3秒

结果集精度:保持Top100问题车辆定位能力
需要我解释具体优化策略的选择依据吗?或者需要查看某个维度的详细基数统计?
回复

使用道具 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

7回帖数 0关注人数 523浏览人数
最后回复于:2025-2-12 12:57
快速回复 返回顶部 返回列表