×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

see here

The command timeout in OLAP Manager is set to 30 seconds. If the counting of the members takes longer than 30 seconds, you receive the error message.
Report

Replies, comments and Discussions:

  • 工作学习 / 专业技术讨论 / 请教关于OLAP CUBE的问题,高手们来帮帮忙哈: 最近想给个cube加个新dimension,可是。。。
    一到count dimension members就报错。 "Unable to count the members of the 'XYZ'level. Unable to open the record set. Error: Timeout expired."

    aggregation storage space 也足够

    原有的cube都能有,但是如果把已有的dimension删除,再add,也会报同样的错

    请高手们给指点一下吧,我都折腾了好久了:S
    • see here
      The command timeout in OLAP Manager is set to 30 seconds. If the counting of the members takes longer than 30 seconds, you receive the error message.
      • Thank,but our server is running service pack 3 now... still doesn't work. any other advice...
    • can you manually query this dimension? how big is it?
      • Yes,I can run the query from SQL server....
    • OLAP? not interested.
      • :S me either, but have to fix it...
    • 我到另外一个DB下的cube试着去add a new dimension (time dimension),count到days才报错。是因为space的问题吗?
      • how about add a smaller dimension to you cube and count it? (like lowest level is monthly not daily), if it works, the problem must be from ur huge dimension
        • en, I thought the problem is from the size of dimension...Do you know how to fix it?
          • is there any configuration like default size for dimension from your cube? some of my freind could help it for sure. unluckily, they are not online
    • Members 不能超过64K, 超过需要用GROUP: 比如1M ACCOUNT 就不能在一个LEVEL
      • 这个我知道,但是现在这个new dimension是date, 也不过就是7-8年的data,应该没问题d
        • 是不是DIM的MEMBER KEY COLUMN不UNIQUE? 把生成DIM SET的SQL 语句COPY 出来运行一下.