Shall we connect to the oltp systems directly .,

Answer Posted / vijay

A business objects report can directly report on ORACLE or
SQL Server Database but using a Universe as a Semantic
Layer.

We can use even Free-Hand SQL to run on OLTP Systems. In
earlier version WEBI didnot had that facility but from XI
3.1 it is possible.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between absolute and relative div positioning?

588


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4196


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

602


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3002


Explain in detail about type 2(scd),

601






How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

698


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

553


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?

3136


Can we create universe with no cache??

1963


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

516


Explain the difference between detect alias and detect context?

631


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

820


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1625


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

628


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

1435