Hi
I'm using data federator.I would like to know if it allows
select statment in where clause.For example:
SELECT Employee, company, orgunit
FROM TAB_BIG
WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL
WHERE flag = X )
bye
No Answer is Posted For this Question
Be the First to Post Answer
How to execute the MACRO through Infoview?
I HAVE USED A PROMPT TO SELECT A COUNTRY IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN DEFAULT AND HAVE TO GIVE THE RESULT? HOW TO ACHIEVE THIS?
if the project is assigned for you and the client said yo wait for a month,What will you do in that time?
how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in
HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?
What do you mean by Object qualification?
What is the definition of derived table ?
when we go for snow flake schema rather than star schema ?
1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?
what is universe null
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?