谁将在蒙德里安的事实表中添加行?开发商还是蒙德里安本身?
我想问与蒙德里安有关的非常非常基本的问题。 我创建了一张事实表来构建蒙德里安立方体。目前该事实表不包含任何行。所以,我想知道谁会在蒙德里安的事实表中添加行?开发商还是蒙德里安本身?
I want to ask very very basic question related to Mondrian.
I have created one fact table to build Mondrian cube. Currently that fact table does not contain any rows. So, I would like to know Who will add rows in fact table of Mondrian? Developer or Mondrian itself?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
开发商。
粗略地说,Mondrian 只是一个接受 MDX 查询并将其转换为 SQL 查询的引擎。
更重要的是,通常您将拥有一个用作数据仓库的数据库(其中有蒙德里安立方体)和一个操作数据库(或多个),实际数据来自其中。 您在cubename.mondrian.xml 文件中声明了该多维数据集,但您没有向 Mondrian 提供有关操作数据库的外观的任何指示(它甚至可能看起来不像数据库——我们维护了几个由 Apache 日志填充的多维数据集!)
尽管 作为开发人员,您有责任填充多维数据集,在 Pentaho 世界中,我们通常使用 Pentaho 数据集成(也称为 Kettle)作为我们的 ETL 工具(也就是说,它是我们用来从任何来源提取数据的工具,将其转换为对我们的目的更有用的形状,并将其加载到数据仓库中)
The developer.
Mondrian is, roughly speaking, simply an engine that takes MDX queries and translates them into SQL queries.
More to the point, typically you'll have a database that serves as data warehouse (where you have your Mondrian cubes) and an operational database (or several), where the actual data is coming from. Though you declared the cube in a cubename.mondrian.xml file, you have given no indications to Mondrian on what the operational database looks like (it might not even look like a database -- we maintain several cubes populated from Apache logs!)
Since it's your responsibility as the developer to populate the cube, in the Pentaho world we usually use Pentaho Data Integration (also known as Kettle) as our ETL tool (which is to say, it's the tool we use to Extract data from whatever sources, Transform it into a shape more useful for our purposes, and Load it into the data warehouse)