Recent content by kv444

No Luck with this...for some reason i am not able to group the dimension column in webi 4.1...

Is there a way i could do it directly at the report level

I want to see phone phone phone Thanks!!!

Hi All, I am trying to develop a report in webi where i would like to show only duplicate records in the report and would like to drop the records that are unique from the report. For Example i have a column in the report: Item: Laptop Phone Phone Phone watch pen Here i want to see the...

Could you please explain it a little bit in detail...i am trying to show only the duplicate dimensions in the report...will i be able to use running total here..

Hi All, I am trying to develop a report in webi where i would like to see only duplicate records in the report and would like to drop the records that are unique from the report. For Example i have a column in the report: Item: Laptop Phone Phone Phone watch pen Here i want to see the...

Hi All, I am facing issues while adding two numbers in crystal reports formula since one of the numbers is a null value,crystal reports is adding the null value and not null value and giving the output as a null value. Here is an example: I have 2 variables : Amounts and tax. Here are the 2...

Hi, I am trying to format the numbers in a graph in webi.for example i want to know the numbers 20,000..40,000 as 20k and 40k respectively on x-axis. Can some one please let me know if there is a way i could do this in BO webi. I appreciate your help in advance. Thanks a lot !

Hi, I need to modify a function,currently the coulmn here is set to return varchar 2 but i need to change it to CLOB so that i can store 10000 characters in this column. I tried changing the varchr2 to clob,i was able to compile it but the report is not retreiving the data like it used to...

Hi, I need to write a formual to format the address in crystal reports for example if the adress is john adams 123 ohio st apt 24 cincinati ohio i should be able to print the whole address in the reoprt and for the same report for a different recepient if tha address is quicny 123 ohio...

Hi, Could some one please tell me how i can convert VARCH2 to clob datatype in plsql. Thanks

Hello, I am writing a after trigger for one of my tables on every insert update and delete for my dataware house staging area. The process here is when ever there is a change in the production database we need to capture this change in our changing area through triggers. I am able to create...

Thanks for the reply. I am trying to lock the whole table,not allow any transcation to the table what so ever. Will SET TRANSACTION work? Thanks

Hi, How do i lock table in oracle, i tried LOCK TABLE Table_name IN EXCLUSIVE MODE and 3 other modes but still i was able to insert data in to the table. I want to lock the table so that the table would reject any data that is being inserted or updated in to this table. Thanks

Hi, Could some one please tell me how to create a script in oracle to create multiple tables (more than 100 tables). I want to write a script because i will be re-using the script very often. Thanks for your help in advance.