Questions tagged [oracle-olap]
10 questions
3
votes
1 answer
Oracle OLAP Java implementation - Proper source joining
I am trying to achieve the following with the Java API:
for this purpose I am using the default schema/example GLOBAL from the Oracle OLAP download section.
This is the modified version of the code from the Oracle OLAP Java guide:
MdmCube…
Adnan
- 25,882
- 18
- 81
- 110
2
votes
1 answer
Querying Oracle 11g multidimensional cube from sqldeveloper
Im new to oracle multidimensional models...
I have followed the "Creating a Multidimensional Model" 15 min Oracle tutorial. Tutorial Link
Note: This tutorial use sql developer data modeler.
I would like to know how to query the created data cube…
zd5151
- 395
- 1
- 3
- 15
1
vote
1 answer
How to deploy Oracle Dimension table for OLAP Cubes
I followed First Example as well as Second Example to create Cubes in Oracle 10g.
I tried to create cube using query rewrite mechanism in Oracle 10g.
(Intailly tried to create using Analystic workspace manager we got error in that too so only we…
shanmugamgsn
- 820
- 5
- 16
- 27
1
vote
1 answer
ORA-37409 Cannot drop analytic workspace in AWM
I wanted to delete an Analytics Workspace in AWM,but the action stopped with this error :
ORA-37409: cannot delete or truncate AW used by CUBE ORGANIZED table
After I closed AWM and open it again, the list of dimensions and cubes was empty but I…
hgr 296
- 39
- 6
1
vote
1 answer
How to create OLAP cube using Oracle DW
Whether it's possible to create cube using SSAS by establishing connection with Oracle DW?
Whish is the best tool to use SSAS/Oracle OLAP?
What are the requirements?
How to install the tool?
PS: I have very limited knowledge on data cubes
Durai Murugan
- 11
- 2
1
vote
0 answers
How to use Oracle OLAP cube with Oracle locator?
I have built an Oracle OLAP cube with 3 dimensions (time, products, location(lat,long)).
So far I can query time and get all the products in all locations.
What I dont know is...How can I use Oracle Locator with Oracle OLAP cube so that I can…
zd5151
- 395
- 1
- 3
- 15
0
votes
0 answers
How to add a cumulative sum or and aggregated calculated field in Analysis Server?
I'm currently working in an OLAP Cube for a company.
I have 3 main fields that the customer wants to be able to pull on excel.
Actual
Forecast
Budget
And along with it he wants a comparison between them, and the % variation. For instance (Actual -…
Vinicius Savordelli
- 11
- 3
0
votes
0 answers
Oracle data warehousing for creating data cubes
I have to create an Oracle data warehouse so that I can create data cubes on that database, but I don't know how to start. I have an oracle database running as a production database. Using this database I get all my production data and dump that…
Khizar Khan
- 1
- 1
0
votes
0 answers
Oracle 12c OLAP Option enable "on commit" refresh mode
I've created a cube using Oracle 12c OLAP option.
I would like to refresh the cube automatically when the data in the underlying tables change.
Is it possible without using materialized views?
With materialized views, couldn't enable refresh mode…
sowdri
- 2,193
- 5
- 23
- 36
0
votes
1 answer
Can't get data from Essbase
I'm new at OLAP services.
I want to get data from Essbase using olap4j.
I'm sending this request:
SELECT {[Year].[Jan]} on COLUMNS from [Demo.Basic]
and get an error that database Basic does not exist:
XMLA provider gave exception:…
vdj TAB
- 31
- 7