BOBJ For BW: Create a Bisc Olap Connection

Yazdır PDF

Olap

Create a BICS OLAP Connection using the BusinessObjects Central Management Console (CMC)

 

 

 

 

 

At evtechnologies.com, we are starting a new blog series on getting your SAP BusinessObjects and BW environments in sync and configured for optimal reporting and query design.  Previously, with BusinessObjects XI 3.1, there were limited options to deliver BW data to BusinessObjects. With the release of the BI4 platform, the opportunities have increased as well as the tools to visualize the data.
One of the best ways to get started viewing your BW data inside of BusinessObjects is with a BICS connection. BICS stands for “Business Intelligence Consumer Services” and is enhanced from the previous method of connectivity in that it directly connects the BOBJ reporting tool to a Bex Query.  While you can still create a traditional OLAP Universe against a Bex query in 4.0, it is no longer the preferred method as it contains an additional MDX layer that makes query maintenance and updates time consuming and tedious.
We start the series with a quick tutorial on creating a BICS connection inside of the Business Objects Central Management Console.  One of the advantages to creating  a connection inside of the CMC is that you don’t need client tools, just a browser. In a future blog, we will address creating an OLAP connection inside of the Information Design Tool and some of the advantages with that method.
Step #1
Log into your Central Management Console with your appropriate admin credentials.
01
Step #2
After logging in, use the menu bar to access your existing OLAP Connections by clicking on the “OLAP Connection” icon
02
Step #3
Click on the green icon to create a ‘new OLAP connection’
03
Step #4
Enter your BW system credentials, name the connection, and click ‘Connect’ to choose a cube
04
Step #5
You have the ability to connect to a single bex query, or to a cube.  One benefit to connecting to a cube is the ability to add more queries down the line to the connection without creating additional connections.  Once you’ve connected to a query, you can select the authentication that best suits your users and business.
07
Step #6
Save your connection and it should now appear alongside your other OLAP connections and folders
09
Step #7
Test your OLAP connection against a new Web Intelligence report with Bex as a data source
10
Step #8
Your work is now complete from a data accessibility standpoint.  Once you’ve clicked on the connection you will now be able to access a Bex query through Web Intelligence directly without having to go through a Universe.
11

Twitter

Sosyal Ağlar

Paylaşın:

mod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_counter
mod_vvisit_counterBugün6
mod_vvisit_counterDün162
mod_vvisit_counterBu Hafta1040
mod_vvisit_counterGeçen Hafta1161
mod_vvisit_counterBu Ay2653
mod_vvisit_counterGeçen Ay4457
mod_vvisit_counterToplam335076
PATHWAY_MSG   Anasayfa
| + - | RTL - LTR