Is SAP BusinessObjects required for the Universe relational database?

Question

Objective: . I want users to be able to connect directly to an RDBMS (for example, MS SQL Server) and fulfill some queries with possible cross-references.

Tool: SAP BusinessObjects XI Enterprise

Description:

The main reason is that the creation of the universe is quite technical. Imagine that the SQL DB structure changes frequently, maybe even daily. Identify synchronization issues.

Is the BO able to cross-reference using a GUI request that the BO , which can be used non-technical, generates a request, for example:

SELECT
    Classroom.Location
FROM
    Student,
    Classroom
WHERE
    Student.Name = 'Foo' AND
    Student.ClassroomName = Classroom.Name

... ODBC ( )?

, ?

, () BO Universe ? XML?

Answer 1

.

"" , 500 , BO. "" , , 5NF ( 5NF) Rdb, ", " ". , . BO 10 . ( 5NF Rdb; 5 , , -) .

, , , , dbs, . , , , , db. , BO Universe () Rdb.

, Rdb 120% Rdb, BO Crystal Reports . , , " " . , , , "" Rdb, .

, BO, , XI ( ). , , .

, BO Query GUI ( pre-XI) Rdb , , , . . " " . . , . (, Supertype-Subtype) .

, .

• , , . , " ", .

  • Rdb , SQL ISO/IEC/ANSI.
  • " " , , , , .
  • , , ; , .
    ,

• , "db". , .

  • , .
  • , ( , ), , () ()
  • BO Universe ( ) Rdb; .

  • , , , , ; - , , , .

  • . prima facie : Student.ClassroomName - . , , .

  • , , , : ; ; " " "" ( ); ( ); , , , . ,

• - "", , "" , . Prototype ; .

• BO , . . . UAT , .

  • , SQL, BO
  • , - "" , - , "", BO - , " ". , "", , , .
  • , , BO "". ,
  • "", , , , .

-, Crystal , ISO/IEC/ANSI. , , . ( ), , ; , , .

, , ; , , .. ..; ( ) () () , . , "", , . , .

, , , " " , , , .

, , , () , () , . , , , , . ( , , ) , ; Rdb, .

, , IDEF1X Notation.

, . .

1) a 2010 , 25- [ 35 -use relataional technology], , (wiki - ):

• ( , 5NF )

• ( )

• SQL/IEC/ANSI Standard SQL ( ala Foreign Key, , , )

• - ( )

• ; ; ( , ..).

, , .

2) , , . "Relational Database Engine" .

, ( , 100% ), , BO Universe ( ).

DRI ( FK), " " ( ) , ( ) -.

FK.

, , ( ), - . BO - ; Crystal Reports . - .

. , , , , , , , 3 , , .

" "

, "" " ", , . ( " RDBMS, , BO, , , , , ".) , , , - SO, , .

BO ODBC JOIN ( ) , FK, ?

(ODBC , .)

, re FKs , . - , .

BO BO, " ". FK , ; , .