Recent content by anuragvijay

I have a question regarding the cache files created by lookup transformation. The informatica documentation indicates that the powercenter server creates two files with extensions .dat and .idx. however i noticed that there is another file created with extension .lck. We are using persistant...

On running a session i'm getting the following error in the session log file : "ORA-01007: variable not in select list" The source is Oracle 9i. If the source query indicated in the session log is executed in sql plus, it executes successfully. However during session run the above error is...

i recently installed windows XP pro on my laptop. the problem is that after this installation i'm having problem typing with my keyboard. i'm having missed keys. if i type a word say 'there' it might be typed as 'thre', the character 'e' not being typed even though i pressed the key. i stumbled...

I'm a fairly new to Informatica. Have a baisc question: Can partitioning be done only in PowerCenter and not in PowerMart? What's the difference between the two as far as partitioning is concerned? Reason for this question are the following texts from the Workflow Administration Guide: 1. "A...

I'm using Webi 2.7.2. Is it possible to create a subquery in the query panel (as we can do in full-client)? I do not see any option to do that. Is there any indirect method? I want the query generated to look like: select customer from table1 where customer not in (select cus from table2) Here...

I have an excel document saved in my Personal Documents in Infoview (webi 2.1.6). Is it possible to send it to other users? I tried doing it but got an error: Problem occurred during attempt to send the document. (WI0303). There is no problem in sharing webi documents.

i've been facing a strange problem lately which did not exsist earlier. In Infoview when i send a personal webi document to other users i receive the message "Document sent successfully" but the document never reaches their Inbox. This has started recently. Earlier it worked fine. I...

thanks for your help. i have one more question ... why bother to build a webi document and then use webi sdk to customize it? why not just create the report as an asp page and publish the asp page in Infoview? what are the advantages of the former?

I'm using webi 2.6.1 to create a report. It's a tabular report. But above the tabular data i would like to show the user input (values entered in prompts) as labels and values. Is it possible to do this without using webi sdk? where can i find some sample code? thanks

i have two prompts in my Business Objects full client documment (version 5.1.6). The prompts are 'from date' and 'to date'. I want to display the (current date - 2) as the deafult value for 'from date' and current date as the default value for 'to date'. how can i achieve this? Is it possible to...

Hi pabloj, This is what i want: if column A has 3 values: 1,2,3 then the calculated member column (the one having the running sum) should have the following values: 1, 3, 6 that is: 1, 1+2=3, 3+3=6 thanks

is it possible to write a MDX expression to create a calculated member to calculate a running total on a measure but after sorting it in ascending order?

Hi Vumansky This does not seem to work for me. I'm using BO 5.1.6. When i save as xls and later try to open it in Excel i get an error "file format is not valid". Any clue?!

Can BO full-client reports be saved as spreadsheets just like Webi reports? I don't see this feature in the ‘Save As’ dialog box, so I assume it cannot be done. Just need a confirmation on this and whether any indirect method exists to achieve this. Thanks

Hi Sri No problem with the connection. Everthing works fine until the Webi services are restarted as i stated in my original posting. any other ideas?