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...

Thanks.. it was a db connection problem .

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...

As there is no reply I am presenting the same in different format, I tried doing this in Cursor but ended in different result, cud anyone help me in this. I have a table with fields table1 col1 col2 -------------------- A Object1 B Object2 C Object3 D Object4 E Object5 F Object6 I have...

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...

Thanks for your reply Steve. The output of the print from Supervisor is what I am looking for; I wanted to know whether it’s possible to get the same result thru querying Repository. I understand from you reply that it is possible. Let me give a try. Please correct if my understanding is...

Hi Ties I went thru MangerO.unv, I could find details regarding universe and its objects in it and not able to find any user related information which is my requirement. Could you please comment on this. -TIA

My requirement is to get the details of each user access to the document, universe, repository and to the applications, similarly need to know the universe they have access. Can these details be queried from the repository tables? I am using V 5.1 This is what I am looking as the output...

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.

Thx for your reply... I am using a tool where I cannot change the from clause(i.e. I cannot append conditions to the outer join). Is there any other way to sort my problem using where clause itself. I have a alternative using Union which I dont want to use it as it affects the performance...

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# =...

Hey I have a question, Is it possible to find the second maxium record.... Thanks

...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 make this SP work. CREATE PROCEDURE proc_1() LANGUAGE SQL BEGIN Select * from employees; END Thanks in...

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.