What is the equivalent oracle operators for following BO
Operators where we use in prompt:
a. Different from pattern b.Match pattern
c. Both and d.Except
- 2 Answers
- 7048 Views
- Nucleus Software, I also Faced
- E-Mail Answers
Answer Posted / mohanraj
Match Pattern: LIKE
Diff Pattern: NOT LIKE
Except : NOT EQUAL TO (OR) NOT IN
Both : UNION
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How we drill up week to month?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
how get the grand total in master-detail report?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What three things do you consider to be the most important factors for a manager?
how many reports have u created ? explain a few.
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
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
Can more than 1 metric be applied on an analytic in business objects?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
what is the difference b/w the refresh and buffered data?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
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?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
