Sign in or 
Location: Oracle BI and DW
Page Threads
| Started By | Thread Subject | Replies | Last Post | ||||
|---|---|---|---|---|---|---|---|
| venkata.rahul | Is there a concept of SQL that uses Genetic algorithms? | 0 | Nov 11 2009, 10:50 AM EST by venkata.rahul | ||||
|
Thread started: Nov 11 2009, 10:50 AM EST
Watch
I was just wondering if there are ideas to work, around the usage of genetic algorithms to search large databases quickly; Quickly in the sense that they can be proven to be faster than conventional sql techniques. Is there some work done around this kind of data extraction already?
Regards Rahul
out of
found this valuable.
Do you find this valuable?
Keyword tags:
Genetic algorithms
SQL
|
|||||||
| hehayeung | BQY cannot access after Hyperion Migration from BRIO to Hyperion | 0 | Oct 14 2009, 4:50 AM EDT by hehayeung | ||||
|
Thread started: Oct 14 2009, 4:50 AM EDT
Watch
I would like to seek advise with following issue.
We are using Hyperion BI+ 9.2.0 and there has a problem to access the old bqy in BRIO. After perform the Hyperion Migration Tools, all the bqy, oce and user/group migrated successfully from BRIO to Hyperion 9.2.0. But there has some saved local BQY which cannot access to the Hyperion. It prompt the mesasge from Interactive Reporting Studio as below "Unmatched DataTypeException exception encountered" With refer to Hyperion Server Log, error message recorded in the log of server_messages_PublisherServer.log - uuidparamter is null server_messages_DataAccessServlet.log - Error in retrieving document from disk Anyone would provide solution or experience on above. |
|||||||
| nmrezzini | Using OBIEE with the OLAP Option to Oracle Database 11g | 0 | Mar 2 2009, 11:22 AM EST by nmrezzini | ||||
|
Thread started: Mar 2 2009, 11:22 AM EST
Watch
For whom would like to see some details about using Oracle Business Intelligence Enterprise Edition with the OLAP Option to Oracle Database 11g, then please login on Oracle Technology Network (http://www.oracle.com/technology/index.html) site and download the White Paper (http://www.oracle.com/technology/products/bi/olap/Oracle_OLAP_11g_BIEE_TWP.pdf) on that.
|
|||||||
| nmrezzini | Cube Organized Materialized Views | 0 | Mar 2 2009, 9:26 AM EST by nmrezzini | ||||
|
Thread started: Mar 2 2009, 9:26 AM EST
Watch
Using cube organized with materialized view, we have got a query performance and fast for incremental updates.
Summary sql queries that are directed at relational fact tables are automayically rewritten on the olap cube to deliver faster query performance. Cube MVs is existing since 11g, they are integrated with the Oracle Database SQL Optimizer. The 11g SQL Query Optimizer treats OLAP cubes as MVs and rewrites queries to access cubes transparently. A single cube provides the equivalent of tens, hundrends, or thousands of summary combinations. The cube MV is refreshed using standard MV procedures. There are four general tasks required to implement cube MVs. The first three tasks are specific to OLAP cube MVs, while the last task is important for any type of MV. Tasks for implementing cube MVs include: • Design dimensions and cubes – AWM • Enable cube MVs – AWM • Build and maintain dimensions and cubes – AWM • Prepare relational schema for query rewrite – SQL |
|||||||
| nmrezzini | Advice if memory target parameter is set more than 3 Gb size | 0 | Nov 28 2008, 10:51 AM EST by nmrezzini | ||||
|
Thread started: Nov 28 2008, 10:51 AM EST
Watch
A defect is introduced in 11.1.0.7 on Linux x86-64 platform if the memory target parameter is set more than 3 Gb size.
This could make some problems while you are creating Dimensions in AWM 11.1.0.7A. In detail, while creating a new dimension in AWM with the Mantain Dimension option, then the following error occurs: oracle.express.idl.util.OlapiException: java.sql.SQLException: No more data to read from socket at oracle.express.idl.ExpressOlapiDataSourceModule.... at oracle.olapi.data.source.DataProvider.callGeneric.... at oracle.olapi.data.source.DataProvider.callGeneric.... at oracle.olapi.data.source.DataProvider.executeBuild.... at oracle.olap.awm.wizard.awbuild.... at oracle.olap.awm.ui.SwingWorker$2.run(Unknown Source) at java.lang.Thread.run(Unknown Source) The following error is logged in the alert.log file: ORA-27103: internal error Linux-x86_64 Error: 11: Resource temporarily unavailable Additional information: -1 Additional information: 1 Solution Follow the note 751511.1 available on Metalink. |
|||||||
| nmrezzini | Cannot View Dimension If Description Is More Than 60 Characters | 0 | Nov 27 2008, 10:21 AM EST by nmrezzini | ||||
|
Thread started: Nov 27 2008, 10:21 AM EST
Watch
If an attribute, such as a long description has more than 60 characters, than the dimension cannot be viewed in either data viewer or an ET view.
In AWM Data Viewer, it cannot drill down in the attribute that has more than 60 characters. In AWM ET view, selecting the DATA tab, invoke this error: java.sql.SQLException: ORA-33674: Data block size 139 exceeds the maximum size of 60 bytes. at oracle.olap.awm.util.jdbc.SQLWrapper.execute(Unknown Source) at oracle.olap.awm.querydialog.PagedQueryDialog$1.construct(Unknown Source) at oracle.olap.awm.ui.SwingWorker$2.run(Unknown Source) In SQLPLUS, selecting the dimension table with attribute that has more than 60 characters: SQL> select * from PRODUCT_VIEW; the following error occurs: ORA-33674: DATA BLOCK EXCEEDS THE MAXIMUM SIZE OF 60 BYTES. Cause There is the bug 7579305 on that, this is not visible on Metalink. A similar issue occured on RDBMS 11.1.0.6, and it was reproduceable on AWM 11.1.0.7A as well, even if, here the problem occured if an attribute had more than 100 characters, and the error was: ORA-33674: DATA BLOCK EXCEEDS THE MAXIMUM SIZE OF 100 BYTES. Solution Change the attribute size to 200. The attribute size can be set in AWM under the Implementation Details tab for the attribute. This works around the problem until it will be fixed for next releases. References Note 751511.1 available on Metalink. |
|||||||
| nmrezzini | Performance Issue While IMPORT An EIF File with UPDATE | 0 | Nov 21 2008, 10:56 AM EST by nmrezzini | ||||
|
Thread started: Nov 21 2008, 10:56 AM EST
Watch
Performing an EIF file IMPORT with UPDATE option, for example:
-> import all from eif file 'Temp_Dir/database.eif' update then it could be long, even if, the EXPORT finished quickly. This is rather visible when you try to IMPORT a big eif file. There is a memory leak bug 7395130 when using IMPORT from EIF with the UPDATE option. The UPDATE option indicates that IMPORT should execute an UPDATE command after importing each object. The UPDATE command moves analytic workspace changes from a temporary area to the database table in which the workspace is stored. There is a memory leak bug 7395130 when using IMPORT from EIF with the UPDATE option. This bug is not visible on Metalink. Solution Use the EIF file IMPORT command without the UPDATE option, for example: -> import all from eif file 'Temp_Dir/database.eif' In this way, the import performances are quite better. This bug problem will be fixed for next rdbms 11.2 release. Reference Note 751460.1 on Metalink (https://metalink.oracle.com/). |
|||||||
| nmrezzini | OLAP A PATCH FOR 11.1.0.7 is available on Metalink | 0 | Nov 11 2008, 9:58 AM EST by nmrezzini | ||||
|
Thread started: Nov 11 2008, 9:58 AM EST
Watch
I am pleased to let you know that "OLAP A PATCH FOR 11.1.0.7" is available on Metalink.
It is downloadable with the patch 7486407 number for the following platforms: -) Linux x86 -) Linux x86-64 -) IBM AIX Based System (64-bit) In the next weeks, it will be available for the others platforms as well. See the note 739082.1: "OLAP, Releases and Patches" for more details. |
|||||||
| nmrezzini | How to Recreate an AW Through Export and Import Commands - 1st Part | 0 | Oct 10 2008, 5:31 AM EDT by nmrezzini | ||||
|
Thread started: Oct 10 2008, 5:31 AM EDT
Watch
I would like to suggest an useful practice if you need to recreate an AW, for example, when an AW is broken, corrupted or it is necessary to remove the density of the data (density of the data means that the data are kept space not properly due they are keeping cells sporadically).
|
|||||||
| nmrezzini | How to Recreate an AW Through Export and Import Commands - 2nd Part | 0 | Oct 10 2008, 5:30 AM EDT by nmrezzini | ||||
|
Thread started: Oct 10 2008, 5:30 AM EDT
Watch
Here are some steps, using export and import commands.
Considering "AWNAME" your AW and "myuser" your user. 1) Create a directory object, and grant the privileges with your user that you are working (i.e.: myuser) SQL> connect as sysdba SQL> create directory my_dir as 'D:\temp_aw'; SQL> grant read, write on directory my_dir to myuser; 2) Export AW object: AWNAME login as myuser in sqlplus set serveroutput on exec dbms_aw.execute('aw attach AWNAME ro'); exec dbms_aw.execute('limit name to all'); exec dbms_aw.execute('allstat'); exec dbms_aw.execute('export all to eif file ''my_dir/export_file_name.eif'' '); exec dbms_aw.execute('aw detach AWNAME'); 3) Drop AW object: AWNAME exec dbms_aw.execute('aw delete AWNAME'); 4) Create empty AW object exec dbms_aw.execute('aw create AWNAME'); 5) Import data exec dbms_aw.execute('aw attach AWNAME'); exec dbms_aw.execute('import all from eif file ''my_dir/export_file_name.eif'' '); exec dbms_aw.execute('update'); commit; exec dbms_aw.execute('aw detach AWNAME'); Reference Note 742375.1, it is available on Metalink. |
|||||||
| nmrezzini | OLAP, Releases and Patches | 0 | Sep 26 2008, 9:38 AM EDT by nmrezzini | ||||
|
Thread started: Sep 26 2008, 9:38 AM EDT
Watch
It is available on Metalink (https://metalink.oracle.com/) an useful note that provides the latest information on OLAP patch availability:
Note 739082.1: "OLAP, Releases and Patches". This article is intended for OLAP users who wish to keep up to date on the latest OLAP patch releases. The article will only list the patches for OLAP versions: 9.2, 10.1, 10.2 and 11.1. |
|||||||
| nmrezzini | What's New in Oracle Database 11g Release 11.1 Oracle OLAP (Part 2) | 0 | Sep 18 2008, 6:42 AM EDT by nmrezzini | ||||
|
Thread started: Sep 18 2008, 6:42 AM EDT
Watch
Cost-Based Aggregation
Fast updates and uniform querying performance are two hallmarks of the OLAP option. Cost-based aggregation enhances performance in both areas by executing a fine-grained pre-aggregation strategy and storing sparse data sets very efficiently. Calculation Expression Syntax OLAP calculation expressions extend the syntax of the SQL analytic functions. This syntax is already familiar to SQL developers and DBAs, so that it is easier for them to adopt than proprietary OLAP languages and APIs. This syntax is used to define calculations that are embedded in the cube, such as dynamically calculated facts or measures. Cube Materialized Views Cube materialized views are cubes that have been enhanced to use the automatic refresh and query rewrite features of Oracle Database. Cube materialized views bring the fast update and fast query capabilities of the OLAP option to applications that query detail relational tables. Summary data is generated and stored in a cube, and query rewrite automatically redirects queries to the cube materialized views. Applications experience excellent query performance. Object and Data Security Oracle Database 11g introduces both object security and data security to OLAP cubes and dimensions. Both types of security are granted to database users and roles. Object security controls access to analytic workspaces, cubes, and dimensions using standard SQL GRANT and REVOKE syntax. Data security controls access to the data in a cube or a dimension. You can grant SELECT, INSERT, UPDATE, and DELETE privileges to dimension members (keys) either globally or in the context of a particular cube to control access to the data in a cube. See "What's New in Oracle Database 11g Release 11.1 Oracle OLAP (Part 1)". |
|||||||
| nmrezzini | What's New in Oracle Database 11g Release 11.1 Oracle OLAP (Part 1) | 0 | Sep 18 2008, 6:38 AM EDT by nmrezzini | ||||
|
Thread started: Sep 18 2008, 6:38 AM EDT
Watch
What's New in Oracle Database 11g Release 11.1 Oracle OLAP? (Part 1)
This preface identifies the major enhancements to the OLAP option of Oracle Database. Oracle Database 11g Release 11.1 Oracle OLAP The OLAP Option to Oracle Database 11g continues the development trends of Oracle9i and Oracle Database 10g, especially in deepening integration with the database and enhancing SQL access to cubes, security, and metadata. The power of OLAP is easily accessible to SQL applications. Oracle Database 11g also introduces the cube as a summary management solution for relational OLAP (ROLAP) implementations. OLAP Metadata Integration All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL. Use of the data dictionary to store the metadata officially codifies the dimensional model in the database, provides significant improvements for metadata queries, and supports other new features such as SQL object security for cubes and dimensions. Automatic Maintenance of Cube and Dimension Views Oracle Database 11g automatically creates and maintains relational views for every cube, dimension, and hierarchy in the database. If you modify a dimensional object, such as adding a calculated measure to a cube, the view is immediately re-created to reflect the change. Oracle Database defines these views using the new CUBE_TABLE function, which enables the SQL Optimizer enhancements. Cube Scripts A cube script is an ordered list of commands that prepare a cube for querying, such as Clear Data, Load Data, Aggregate, Execute PL/SQL, and Execute OLAP DML. For many applications, cube scripts will eliminate the need to use procedural programs for processing cubes. See "What's New in Oracle Database 11g Release 11.1 Oracle OLAP (Part 2)". |
|||||||
| nmrezzini | Analytic Workspace SYS.CWMTOECM Cannot Be Opened | 1 | Sep 9 2008, 4:09 AM EDT by nmrezzini | ||||
|
Thread started: Sep 8 2008, 7:19 AM EDT
Watch
Once upgraded from a rdbms 9.2.0.x to 10.1.0.x or later (10.2.0.x, 11.1.0.x), then the CWMTOECM Analytic Workspace could become as corrupted. If so, you cannot be able to perform a full export.
Enter in Metalink (https://metalink.oracle.com/) and search the note 735838.1: "Analytic Workspace SYS.CWMTOECM Cannot Be Opened" to see a possible solution.
Show Last Reply
|
|||||||
| nmrezzini | New Applications FNDCPASS Utility Feature Breaks OFA and OSA SSO | 0 | Sep 5 2008, 11:34 AM EDT by nmrezzini | ||||
|
Thread started: Sep 5 2008, 11:34 AM EDT
Watch
This alert concerns OFA Single Sign-On and the new FNDCPASS Utility New Feature. Please see the published note 457166.1: "FNDCPASS Utility New Feature: Enhance Security With Non- Reversible Hash Password" on Metalink for all details.
If hash passwords are implemented on a system which utilizes the Single Sign On (SSO) mechanism for Oracle Financial Analyzer (OFA), or Oracle Sales Analyzer (OSA), the SSO mechanism will stop working. There is no fix for this since the underlying Express Server code is desupported. For Oracle Demand Planning (ODP), if the customer is on 11.5.10 of ODP, the SSO mechanism is no longer utilized, and so the customer should not have any concerns. This issue will occur in OFA or OSA Single Sign-On if the 'Hash Passwords' feature is implemented from Applications 11.5.10 RUP patch 6 and or 12.0.4. This error will occur: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, admin@companyname.com and inform them of the time the error occurred, and anything you might have done that may have caused the error. There is no workaround. The feature should not be implemented if Oracle Financial Analyzer or Oracle Sales Analyzer Single SignOn is being used. Metalink resources (https://metalink.oracle.com/): * Note 735814.1: "New Applications FNDCPASS Utility Feature Breaks OFA and OSA Single Sign-On". * Note 457166.1: "FNDCPASS Utility New Feature: Enhance Security With Non- Reversible Hash Password". * Note 204692.1: "How To Setup Single Sign-On For Oracle Financial Analyzer". * Note 213020.1: "Troubleshooting OFA Single Sign-on Issues". * Bug 7193909: "OFA SSO NOT WORKING AFTER APPLYING APPS PATCHES". |
|||||||
| nmrezzini | Hyperion Pre-System 9 Products: One Year of Extended Support - Free | 1 | Sep 4 2008, 9:59 AM EDT by nmrezzini | ||||
|
Thread started: Sep 4 2008, 9:49 AM EDT
Watch
We are announcing one year of Extended Support for the versions of Oracle’s Hyperion products listed below for the period October 1, 2008 through September 30, 2009.
The Extended Support fee for this period has been waived for those program licenses for which customers have paid the System 9 Enablement Fee and for which technical support is continuously maintained. Please enter here to read the FAQ on that.
Show Last Reply
|
|||||||
