Skip to Content

BEx Query Designer Level

An important task is we need to check whether “Allow External Access to the query” is checked or not in Advanced tab in BEx query Designer, if not, then we have make check it as without this we can’t see this query during connection creation in universe designer.

/wp-content/uploads/2013/04/1_205055.jpg

Universe Designer


Open the Universe Designer client tool and logon using your SAP logon id and password. Cancel the universe creation wizard and create the universe manually. Click on file-> new universe to see the below screen

  •   Click on New Universe, Give Universe name and description

/wp-content/uploads/2013/04/2_205056.jpg

If you want to have a look at already existing connections click on folder icon in connection area to do so.To create a new connection click on new button.

/wp-content/uploads/2013/04/3_205057.jpg

You can see the new button in below screenshot

/wp-content/uploads/2013/04/3_205057.jpg

Then you land on a screen where you have to fill the connection type which is most of the cases is a secured connection, also give a name and description.

/wp-content/uploads/2013/04/5_205058.jpg

And then press next

Then you will get the backend database selection screen, Select SAP under SAP Business warehouse section as shown below and click on next.

/wp-content/uploads/2013/04/6_205059.jpg

Press next then you will get the login parameter screen, fill the credentials as we have to connect the BEx query lying in the SAP BI system.

After filling Press Next

/wp-content/uploads/2013/04/7_205060.jpg

This will list out all the OLAP cubes currently present in the XBI system.  You can see a search bar below.

Enter the query name in the search tab and click on search

/wp-content/uploads/2013/04/8_205061.jpg

Then it will search for your query and find it. Select it and say next

/wp-content/uploads/2013/04/9_205062.jpg

And then press Finish. Increase value of above parameters if necessary.

Then you are done with your connection creation. Test your connection and press ok.


/wp-content/uploads/2013/04/10_205063.jpg

Then next screen will show all the key figures and characteristics in the universe. The universe is created.


/wp-content/uploads/2013/04/11_205064.jpg

Now we have to make this available at a Central repository for reporting purpose. Go to file and select Export, this action put this universe in CMS and will be visible in WEBI. While exporting you can also control the visibility of this universe at group level.

/wp-content/uploads/2013/04/12_205065.jpg

Web Intelligence Rich client tool


Open WebI Rich client. You land up on the below screen Web Intelligent Client – Standalone screen (not connected to XBI).

/wp-content/uploads/2013/04/13_205067.jpg

Click on Universe and Give your SAP authentication Credentials to connect to Central repository and view list of universes stored

/wp-content/uploads/2013/04/14_205068.jpg

Then Select your universe which you have exported, and press select

/wp-content/uploads/2013/04/15_205069.jpg

Now in this screen you can create your own WebI report by using simple drag and drop or it depends on the requirements and Run the query

/wp-content/uploads/2013/04/16_205070.jpg

/wp-content/uploads/2013/04/17_205071.jpg

Save the report first locally and then publish it to a folder under Info view

/wp-content/uploads/2013/04/18_205072.jpg

/wp-content/uploads/2013/04/19_205073.jpg

Then publish it to Info view under save you will find the publish to.. option and after selecting select the folder where you want to publish

/wp-content/uploads/2013/04/20_205074.jpg

Live office


Open excel sheet and select live office option, before that you have ti install Live office in your system.

/wp-content/uploads/2013/04/21_205075.jpg

Select Application Option and go to Enterprise and check mark “use specified logon criteria” give password and select ok

/wp-content/uploads/2013/04/22_205076.jpg

Then Select the interactive Analysis

Then Select the folder and open your published report and select next

/wp-content/uploads/2013/04/23_205077.jpg

Select your report and press next and then Finish.

/wp-content/uploads/2013/04/24_205079.jpg

Then you can see the report in the Excel sheet

/wp-content/uploads/2013/04/25_205080.jpg

Save this report in your system

Dashboard Design (Xcelsius)


Click on Dashboard icon and select the “Model with spreadsheet data” or select “Blank model” later you can import the spreadsheet and browse for the excel

/wp-content/uploads/2013/04/26_205081.jpg

/wp-content/uploads/2013/04/27_205082.jpg

You can work with the data imported. Then go to connections under Data tab to inform xcelsius that so and so connections existed which have to be managed. Several options like refreshing while document is opening or refreshing before document is opened are available here.

/wp-content/uploads/2013/04/28_205083.jpg

Then expand Add and select Live office Connections

/wp-content/uploads/2013/04/29_205084.jpg

Then fill the server web address instead of <webserver> place under session URL. And finally the connection is done; now whenever any changes takes place in the WebI report it automatically makes changes in Xcelsius.

/wp-content/uploads/2013/04/30_205085.jpg

Once dashboard is ready we can select file – >export it to enterprise option and export it to Launch pad

Version Used: SAP Business Objects Dashboard 4.0

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Henry Banks

    Hi,

    there are a number of problems with this document…

    1. your title is misleading

    2. you have no introduction

    3. this connectivity is outdated.

    4. tagging the doc as Analysis OLAP is plain wrong.

    this is specifically: MDX .UNV universe, WebIntelligence, Live Office, and Xcelsius  – which is all the old legacy XI3.1 concepts.

    In BI4.0, we’d really rather see you promoting: direct BICS OLAP connection to BEx query, Dashboard Designer query panel, and direct data-binding to model (thus by-passing the Excel)

    please action the above points! 

    Regards,

    H

    (0) 

Leave a Reply