Difference between Decode and Case?

Answer Posted / neeraj

Can anyone explain me Null value handle by Case & Decode with Example.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can anybody tell me about complicated object you have created

2747


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

992


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

545


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1565


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3125






If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1768


What is the difference between condition & filter?

600


How can you first report in Business Objects by using broadcast agent?

2593


What is object stores?

576


Explain when we use aggregate awareness function in designer?

578


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3840


Explain how to execute the plsql procedure from the report by clicking with mouse?

592


How to open a universe with out using the Designer ??

6593


What is difference between custom hierarchy and report based hierarchy?

544


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4435