从sqldeveloper查询Oracle 11g多维多维数据集 [英] Querying Oracle 11g multidimensional cube from sqldeveloper
问题描述
我是oracle多维模型的新手...
Im new to oracle multidimensional models...
我遵循了15分钟的Oracle教程创建多维模型". 教程链接 注意:本教程使用sql developer数据建模器.
I have followed the "Creating a Multidimensional Model" 15 min Oracle tutorial. Tutorial Link Note: This tutorial use sql developer data modeler.
我想知道如何使用SQL Developer(即使用常规SQL DML语句的IE)查询创建的数据立方体.每次我在线查找信息时，最终都会获得有关如何使用的链接. Oracle Analytic Workspace管理器.为什么?我只想构建多维数据集并对其进行查询，而不必使用Oracle Analytic Workspace Manager.
I would like to know how to query the created data cube using SQL Developer (I.E. using regular SQL DML statements). Every time I look for information online I end up getting links on how to use the Oracle Analytic Workspace Manager. Why? I would like to just build the cube and query it without having to make use of the Oracle Analytic Workspace Manager.
如果我错过了一些步骤，请somone告诉我，我将不胜感激. (一个简单的简单示例就可以了)
I would appreciate if somone could let me know if I am missing some steps. (a short simple example would be nice)
谢谢.
推荐答案
我意识到您在2013年8月问过这个问题，但是如果它仍然对您或其他人有帮助，那么从2014年2月开始，SQL Developer具有一个OLAP扩展，它似乎可以成为您想要的...
I realize you asked this in August 2013, but in case it still helps you or others, as of Feb 2014, SQL Developer has an OLAP extension which seems to be what you were looking for...
OLAP扩展使您可以使用熟悉的SQL环境 开发人员在Oracle数据库中创建和管理维对象 12c版本1(12.1.0.1.0)或更高版本. Oracle OLAP提供高级 多维分析功能和内部存储 数据库，包括出色的查询性能，快速的增量数据 更新，汇总数据的有效管理和丰富的分析 内容，例如时间序列计算以及累加和 非加性聚合.
The OLAP extension enables you to use the familiar environment of SQL Developer to create and manage dimensional objects in Oracle Database 12c Release 1 (12.1.0.1.0) or higher. Oracle OLAP provides advanced multidimensional analytic capabilities and storage within the database, including excellent query performance, fast incremental data updates, efficient management of summary data, and rich analytic content, such as time series calculations and both additive and nonadditive aggregations.
这篇关于从sqldeveloper查询Oracle 11g多维多维数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
