Search results for query: *

My requirement is to restrict a object 'Emp Name' for a group but they should view the objects only through Corporate documents. Basically, I dont want the users to create their own reports with this object 'Emp Name' but they can view it only via corporate document I restricted a object 'Name'...

Hi I have a report with 3 prompts, 2 date prompt and 1 empid(only this has LOV), when I try to run in webi I click on show values to select the list of empid a error is triggered to enter all the prompt values(actually I have entered all the prompt values). If I try executing the same report in...

Hi When I try to open a report this error message pop up Connection or SQL sentence error (DA0005) Detail: [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "15" ("PROCESSING FAILURE"). SQLSTATE=08001 :-30082 Can anyone let me know what the problem...

Hi In my report I need to display a timestamp field. I have to show it with nanoseconds i.e dd/mm/yy HH.mm.ss.nnnn(01/01/2005 11:09:23.1234). Currently I am getting dd/mm/yy HH.mm.ss and not able to get the nanoseconds. Have anyone help me to solve this problem. -TIA

Hi Is it possible to create a WEBI report with UNION clause? If yes how to go about (any document link will be of great help) I am working on BO 5.1.7 and WEBI 2.73. TIA

Hi I have two tables cd table --------------- cd ID Desc Area table ----------- Parent Child 2. To make work easier I am creating a Temp table created with fields lets say temp cd id descr 3. Then loading the data to cd,id,descr from cd table into the...

Hi All Is this possible to write a store procedure in SQL server or should I use a front end tool like VB to do this. My requirement is this I have two tables cd table --------------- cd ID Desc Area table ----------- Parent Child 2. To make work easier I am creating a Temp table created...

Hi I need to fetch the details of Users access to Application, Documents, Repository. I learnt it is possible to get it by using print command in Supervisor, can anyone provide me the SQL to get these details from the repository tables. (Any document reference will also help me) Thanks.

Hi I have pasted my query below and my query follows it Select a.* b.* from table a LEFT OUTER JOIN table2 b ON a.EMPLID = b.EMPLID AND YEAR(a.EFFDT) = YEAR(b.P1_ACCR_EFFDT) Where ( b.EFFDT IN (SELECT (c.EFFDT) FROM table2 c WHERE c.EMPLID = b.EMPLID AND c.EMPL_RCD# =...

Hi All I am new to DB2. Can anyone help me in writing a Stored Procedure(SP) in DB2 OS390, I tried creating one using Command Center(Please find it pasted below). I am not able to execute it by using the command EXEC NEW_1. Also could anyone tell me whether anything else I had missed out to...

Hi Have anyone tried to install Informatica PM 4.6 in UDB V8.1 Thanks

Hi I have a BO environment , I wanted to create a test environment. What would be the process I need to follow? 1. I have created a new database 2. Installed the same version of BO in the test server and created the repository. Now what should I do... Do I need to take a copy of the...

I need to understand the fields in the log files user.log and userdet.log. Which document should I look at Thanks for your help.

Hi Guys We are using an application that contains the list of users and their profiles. They have to login into BO thru this application. I feel this is a round about way as its difficult to modify the user profile frequently. Can row level security be implemented in business objects, if yes...

Hi All Can we install Informatica two version in Unix. Thanks