Search results for query: *

Hi all, 'Last Triggered' date is not updated even when a metric is refresed in Performance Manager - Application Foundation. I am stuck for about a week now. Do anyone have any idea of what could be the reason? Thanks, Aparna

Hi all, This question is regarding creating sliced metrics using AF. I need to create around 10 sliced metrics on a dimension. My metrics are spread across different classes. 1. Do I need to add the dimension in all of the 10 classes? 2. Do I need to create the slice 10 times on the...

Yes Steve, I have the file in both places. I restarted the WebI server as well as the Win 2000 server. But still I am not getting the universes. Also, full client BO reports when opened in WebI give an 'Internal Error'. There is no error number displayed. The thin client is not able to talk...

Hi, I have installed Web Intelligence 6.5 and Application Foundation in the same machine. But when I search for universes in WebI, I do not find them. The message given is 'No universe found'. Can anyone let me know what could be the reason? I have placed the Bomain.key file in the Locdata...

Dear all, 1) I need to get the top 5 customers in a WebI report. I have Customer ID, Sales amount. I created an object as top 5 sales amount (Edit - Descending sort). When the Display is clicked for the object, it shows the top 5 sales amounts. The problem in WebI is, it is not recognizing...

Hi Blom, I cannot do any manipulation in a WebI report. Thanks, Aparna

I need the dates and dates. I am using this in Business Objects WebI report. In WebI report I cannot create a calculation like this. In the universe I do not want to create an other object of character data type unless there is no other solution to represent the null dates as blanks...

Coalesce(,) function works fine for character and number data types if we return ' ' or 0 for null values. But what should be the value for date data type. Thanks, Aparna

Dear all, Is there any way to represent null dates as blanks in a WebI report. My problem is when download option is used in WebI, the null dates are returned as #EMPTY. Can the date object in the universe be manipulated to represent '' when null? If I do so, I get a data type mismatch...

Hi all, I have created a Business Objects report in WebI. I need to display the number of pages as Page X of Y. Is it possible to get it in that format. <Page> gives the current page number. But how do we get the number of pages along with the page number in the report? Can the prompt...

Hi Blom, Yes. I am using Business objects and created a report variable and it works. We just wanted a confirmation if it is problem with DB2 so that directly we cannot use the object created, in the report. We wanted to inform the user what objects can be directly used and what have to be...

Hi Marc, Thanks for your reply. I tried to group as you have said, and it work fine. But my problem is - I am using a tool and I do not want to modify the SQL the tool has generated. When I pick up the calculated field and sum() field, the tool automatically groups by all the fields other...

Hi all, I am using DB2 7.1.1 on OS/390. When I issue the following query: select emplid, p1_alot_hours*5, sum(p1_alot_hours) from ps_p1_abs_accrual where emplid = '100334' group by emplid, p1_alot_hours*5 ------------------------------------------------------------ I get the following error...