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.

 out of  found this valuable. Do you find this valuable?    

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

 out of  found this valuable. Do you find this valuable?