我正在寻找信息，哪些方法或现有系统可以让 BI 系统的最终用户了解报告中的数据是如何准备/处理的。就我而言，高级 BI 用户希望了解哪些数据库集成在 ETL 流程中（可能遗漏了某些内容）或应用了信息质量过滤器（可能导致丢失重要数据）。我的目标是了解在现实世界场景中部署的最佳解决方案。
I am looking for information what are approaches or existing systems that let an end user of a BI system to have insight how data in the report was prepared/processed. In my case, an advanced BI user would like to know, e.g., an insight which databases were integrated in a ETL process (maybe something was missed) or Information Quality filter applied (could cause loosing important data). My aim is to learn about solutions -- the best -- deployed in a real world scenario.
发布评论
评论（1）
我将您的问题理解为“我们如何向用户展示我们显示的数字背后的故事/业务规则”。
如果我是对的，您也许可以允许用户使用构建的摘要数据来深入了解详细数据。在大多数情况下，这可能非常困难，因为当时是数据+业务逻辑。因此，最好的选择是开始在报告中显示业务规则（报告规范？）。对于汇总信息的关键业务报告，您也可以将详细报告作为子报告（并尽可能提及应用的任何业务规则）
I read your question as "How can we show the users the story / business rules behind the numbers we show".
If I am right, you may be able to allow the users to drill down the detail data using which summary data is built. It can be very difficult in most cases since it is data + business logic at that point in time. So the best bet would be start showing the business rules in the reports (the report specifications?). For business critical reports which summarise information, you can have detail reports as a subreport as well (and also mention any business rules applied as much as possible)