Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?

Answer Posted / pbs

yes.We can't create views in Universe.views are stored as SQL.Derived tables are stored as tables.Exection is faster in case of derived tables as it operates on the new table directly ,but views are SQL and executes and operates on the source table and then fetches te records.Advantage of view is any changes in source table will also get reflected in view,but in derived table it is not possible.

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1142


What is report template in b.o?

1075


Explain which versions are used in the bo dashboard work?

1126


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

1893


Explain about a task that really tested your analytical abilities?

1299


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?

1071


what is universe null

2464


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4450


Explain about a tricky situation for which you found a very simple solution?

1061


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1090


Explain what is the difference between business requirement document and use case document.

1074


Explain about alerts in bos, under what situation we need to use alerts?

1102


Explain the difference between detect alias and detect context?

1141


Difference between b.o 5.1 and 6.1b?

1335


Explain is there any default username & pwd for bo designer & supervisor?

1062