Search results for query: *

hi; I am getting this message after trying to refresh a report (only few records to be display) after some time I get the DMA0007- following data providers were not refreshed message( we are using Oracle btw) and the user have not stop the refresh. Any ideas why this can be happening. Maybe...

Hi: Ive heard there is a tool to convert full client reports into Webi reports. Has anybody heard of this or have info?

In case any of you find this problems. Here is the infor I have. After upgarding to BO 6.5 we were having performance problems and some of the things we found in our investigation: 1) There is know bug for BO 6.5 were the client is sending a lot of uneccesary messages to the server; this was...

Hello: WE just upgraded to BO 6.5 and the reports performance have been very poor compare to the previous 6.1 performance, We have checked the DB side an everything seems to be runnig fine there. ANy ideas on what to check on the BO side. Thanks

Hi: Is there a way in BO to know in advance the number of records to be retrieve by the report? Thanks

Oh thanks for the answer :)

If there a way to set default values to the prompt besides saving a report with values in the prompts?

What I am seeing is this, I run my report after 1 minute the rows status bar start counting, at the same moment in the DB the query has finished running; then it take about 10 minutes (the rows stratus bar still counting) to the data to appear (the formatting is done quickly since we dont have a...

I know at the universe level I can crete the different LOV for the different users. So for example if I have 3 different users, I have 3 different LOV for a certain data then I will need 3 different reports (using each one of the LOV). The problem is I have a lot of different user types so I...

If I was to have different LOV for different users (different user have to see specific data) can this be accomplish in a different way that having a report for each user? Merci

Hola: We are having performance issue with a report, we have worked in the query perfomance and we have been getting good results but when we run this in BO,well it is not good. We can see in the DB logs that the query is performing really good so it is the time BO is taking to fetch and...

Hello: I have this data: data_id, data_description I have a prompt with values data_description, now I want to have the prompt showing the data_description to the user but using the data_id to make the query. I am thinking this can be done with a decode...but I am not sure how. Any ideas

ok I know...for those of you who dont know select field from table UNION select 'ALL' form Dual (oracle)

Hello..this is just what Im looking for. Iknow how to allow the ALL function but Idon't know how to create the union with the ALL. Any help will be great. thanks

Hello: I have requirement for a report with input values (using LOV) but the user want to have some of the inputs optional. I was thinking on allowing the user enter the ALL wildcard but then the user will be allow to types other things as well and since the input parameters is a descritption...

I have a .key file to connect to a server but I'm trying to run a report locally. I tried removing the key file but the I am not able to see the local dsn to change it in the universe. Does anybody know how can I run the report locally with my local dsn Thanks

HI: I am getting the following error: 303) Error with no ErrorHandler with BreakOnVBAError = FALSE but the macro does finish running with the expected results. Any ideas on what the problem may be? Thanks J

Hi: The drillthrough in my cube is working fine except for the cases where for the dimension member is null. For example I have the dimension PRODUCT (dim) - PROD_TYPE_CD (name = PROD_TYPE_CD || '-' || PROD_TYPE_NM) - PROD_CD -PROD_NM So for if the data is like the following where the...

Hi: If I have a measure for example "count" that is decimal number and I performed a 'sum' aggregation function in the cube. When I go to the all levels in all dimension the total count is smaller than if I go to the db and query the sum(count) from table1. count in olap (sum of count at all...

From what I read you can create the named set but then the reporting tool to display the cube data must have the capabilty of displaying the named set. But still there can be a way.