最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

Transaction detail missing from MR reports

网络文摘 William 1498浏览 0评论

After you rebuild the MR data mart, previously generated reports are missing transaction detail. If you try to drill down, the detail is missing. Once the report is re-generated, the transaction detail is there again.

Transaction level detail is reliant on the detail from the data mart. In older versions of MR, the transaction detail was stored in the MR database. This caused the MR database to grow very rapidly. Starting in CU5, the transaction detail was removed from the MR database and links to transactions in the data mart database were used. This link was established to dramatically reduce the amount of data that is stored in the Management Reporter database with each report generation. When the data mart is rebuilt, the link used for the dimensions in the data mart changes. Any previously generated reports would be using the old links and would no longer match the new links created. For example, dimension 1100 may have had a link of 25. When the data mart is rebuilt, it may have a link of 26. The generated report has the old dimension link which is no longer valid in the rebuilt data mart. Because of this, MR cannot find the transaction detail to display.

This can also happen if you update MR to a newer build.

In either case, the only way to get the transaction detail back is to re-generate the report.

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址