Hyperion Query and Reporting | Forum profile

We experience a sporadic "error when uncompressing data retrieved: *Data Error*!" while processing a query with IR webclient 931. The problem occurs on several webclients but on other desktops it does not. The IHTML processes fine. Any one an idea? reinstalling interactive webclient on the same pc does not help. Completely reinstall the pc (os and other client software including interactive webclient) does help.

Have you tried emptying the browser cache and/or cookies? I've seen this on another app (not Hyperion) a long time ago and that fixed it.

Hi Detlev, Thanks for your response You are right database connections are used to create the reports but later those connections are stored in reports. By testing couple of reports i have came to know that issue. But the only way is to migrate the reports from web analysis 9.x to 11.x is manual procedure. As they have mentioned in the documentation saying that we should create a new database connection with the new server (11.x version) and...

Hi. I've found and interesting answer here: http://oraclebizint.wordpress.com/2007/11/12/oracle-bi-ee-101332-working-with-clob-fields/ The error is and OCI error ! I learned that the problem is related to the "distinct clause" which is not supported for CLOB fields ... Also GROUP BYs are not supported for CLOBs I solved my problem using VarChar(4000) insted of Clob. Bye, Andrea

What is the difference between drill through and drill down in Hyperion reporting?

Hi all, Can any one tell me how to write report script for reports and how to reffer it in report.I am using reporting studio for creating reports and I am using planning while creating the database connection for reports. Thanks

Using the web analysis studio you can add the pictures, text boxes, grids, etc. to a web analysis "report" and use SAVE AS to replicate. We do this and Save it into a non-public template folder, then open the template in the studio and change the data source on the grid or chart, SAVE AS to whatever new report and we have the common look and feel for a series of reports. (Unless I misunderstood your question)

Thank you. I'm also trying to create a dozen reports that have the same layout (header, pictures etc..) does anyone know if there is an easy way to set up a template that I can just refer to when building these reports Thanks, Edited by: user10436900 on Nov 23, 2009 8:47 AM

Well you got me... Without personally seeing the problem I am all out of ideas. I would log a Service Request with Oracle and have them work with you to remedy. wish i could be more help. wayne

Hi all, I have designed some reports with HFR for an application of HFM. As I have another application in HFM, I would like to know if it's possible to change de database of this reports to the other application ( this second application is a copy of the original one, but we have created that one for users make tests on it and not in the original one). Thanks for your help.