Tag: BICS

Fiorified BI Launchpad

Quick picks

Url to accesshttp://server:port/BOE/BILaunchpad

Security Changes – Yes, new right needs to be granted

Old Version – No confusions please, Classic BI launchpad still available and can be used for many advanced functions. In my opinion , new launchpad is strictly a consumer interface.

First Look


Changing preferences

Go to User profile > Click on settings



The setting are very similar to classic BI Launchpad.

    Users can set preferred Landing tab

    Pixels for web-based look

    Hide/show totals for Analysis OLAP

By default the landing page navigates to Home Tab (with Show all selected). Users can change the documents to view as below


Context Menu

Context menu of Tile/document can be launched by clicking the 3 dots at bottom on each tile, which lists all the properties of the document

Context menu is similar to right-click on report in classic BI. Below options available under the context menu


Working with Categories

Document tiles in new BI Launchpad can be grouped by categories.( Standard BOBJ categories). Security can be configured at CMC level. Documents can be tagged to categoris from context menu.


Once the document is assigned to a category . changing the landing page view to categories will display all categories .


Viewing standard BI folders

Once you login to BILaunchpad, select Folders Tab which displays all the folders for which the account has access to.


 

Bharat Sunkari

Managing Partner – Tek Analytics

 

 

Converting netweaver Analysis workbook to use BOBJ platform

Requirement – Converting Analysis for office workbook based of netweaver platform to use BOBJ platform.

By default, converting Bex workbook into analysis office uses netweaver connection, which means the workbook needs to be saved to ABAP server, limited broadcasting functionality and also it will be specific to one BW server ( For instance, if you want to have workbook with combined data from BW and hana in multiple tabs it is not possible)

This post explains the step by step procedure on how to change the bex workbook to use BOBJ BICS connection

First, converting the Bex workbook

Launch Analysis office. (TCODE RSAAOE) , Click File>Analysis>Convert Bex workbook

 

Select the workbook to be converted.

Step 2- AAO conversion

 

Click Ok, it automatically converts the workbook into AAO workbook

Step 3- AAO conversion

 

Save the work book ( save to BOBJ platform)

Step 4- AAO conversion

 

Second,  Accessing the workbook

Open the workbook from BOBJ Platform

try to refresh the work book

The workbook will prompt for BW credentials, even though single sign on is activated in BOBJ.  ( please sign in manually)

 

Third, Converting the workbook

Open the work book

Refresh by manually entering the BW password

Click on components in design panel and click edit data source name

Untitled

 

The olap connection box will pop-up ( as you already authenticated to BOBJ platform in Part 2 , step 1)

Select the Desired OLAP BICS connection

Select the the same bex query the workbook is using.

Now the workbook is successfully changed, you can now refresh the workbook via BOCS connection and also schedule the workbook through BOBJ Scheduler ( 4.1 sp4 and higher, need AAO add-on to be installed on server)

– Karthik Addula