Search results for query: *

I am trying to make some conditional selects using CASE where my output also have to be changing accordingly Thanks for replying

Hi Can any one suggest me a alternative to CASE, as I relaised that I cant use CASE in a Cursor.. Any immediate help will be highly appreciated. Thanks in advance

HI EKO3, Thanks for the reply.. I have already tried RULE but that doesnt seem to be helping as it is still going for a Hash Join.

Hi , As the Fiscal Quarter ending for my company is approaching fast I am facing strange problems out of my Oracle Database. I have few fact tables which are of around 100M - 200M.And in one of my BO reports I am joing 3 such fact tables with 4 other dimension tables and giving a report.All...

Hi , Can any one tell me what are all the Oracle Hints that can be used in BO, and how to enforce these hints. Thanks in advance Suresh

Hi all, Can anyone of you suggest a way where in I can select a particular range of records with a particular status.Mean to say my fact table with around 330 Million records have statuses like T1,T2,T3...T10.Now the issue is users will be interested to see only one out of this 10 statuses for...

Hi All, Just to share the solution I got for the issue:It is the Context(as few of u have already suggested)that was casuing problems.After I edited my context to include 1 more column to the join clause, my problem got solved. Many thanks once again to one and all.

Hi Pabloj, Yes, I join the new table to the other entities which is a normal join. Thanks

Hello Blom, I dont know if there is a mechanism to divide the total load in As400, if it was in Oracle we divide the load based on the Rowid and insert data..if not I can never dream of completing my incremental load of our world wide data which will be around 5.5million per day. Thanks Sreenathkm

Being new to the BO environment,would seek solution/suggestions to my below problem: I have a existing report running well in production, now wanted to add few more columns from a new table(class)to the existing report..so have added the corresponding classes from the universe and dragged the...

Hi Nimmy, You are right, the SQL is grayed out...Can u please give me some more info on this and how to over this . Thanks in advance

Being new to the BO environment,would seek solution/suggestions to my below problem: I have a existing report running well in production, now wanted to add few more columns from a new table(class)to the existing report..so have added the corresponding classes from the universe and dragged the...