Hi,

This document provides details on how to perform Refresh Structure in SAP BO BI Platform 4.0 IDT(Information Design Tool) tool.

Versions of Software Used


SAP Business Objects BI Platform 4 (Version- 14.0.6.1036)

Prerequisites –

  • Access to IDT tool

Steps-


Login to IDT and retrieve the Universe which you want to refresh.


Go to the Data Foundation Layer(.dfx) .


/wp-content/uploads/2014/01/1_366212.png


Click Detect and select “Refresh Structure” from the drop down.


/wp-content/uploads/2014/01/1_366212.png


A series of window will come:


1. Display the Missing tables from the universe.


/wp-content/uploads/2014/01/1_366212.png


2.Display the Missing Columns from universe.


/wp-content/uploads/2014/01/1_366212.png


3.Added Columns in universe if any in the backend Database.


Below you can see 4 new columns has been added to the Database which will we can add using the refresh structure.


You can select the columns which you want to add by selecting the check box against the columns.



/wp-content/uploads/2014/01/1_366212.png


4. Modified columns

/wp-content/uploads/2014/01/1_366212.png


5.At last Summary of the changes as per the backend database.


You can see we have checked only two columns in Added Columns, so only that two columns will be get added to Universe.


Press Finish.


/wp-content/uploads/2014/01/1_366212.png


Now, Go to Business Layer(.blx)

/wp-content/uploads/2014/01/1_366212.png


Right Click on the Universe and select “Insert Candidate Objects“.

/wp-content/uploads/2014/01/1_366212.png


A new window will come displaying all the new objects to be added with a checkbox checked.


You can select the objects from the list that needs to be added as per your requirements.


/wp-content/uploads/2014/01/1_366212.png


You can see that Batch object is added so its coming with a checked box.


Click Finish.


/wp-content/uploads/2014/01/1_366212.png


After clicking Finish Save the Business Layer and Publish it to the repository to be used by users with updated list of objects.


Regards,

Javed

To report this post you need to login first.

2 Comments

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

  1. RAJAN Patel

    Hi Javed,

    Nice document.

    I am using HANA as backend and after refreshing Data Foundation, I am not able to refresh Business Layer (no options to insert candidate objects).

    Does it work differently for HANA as backend?

    Thanks,

    Rajan

    (0) 
    1. vaishali wadhwa

      Hello Rajan,

      Insert Candidate object option is only for BW net-weaver connection. You can not refresh business layer directly in rest cases. Please create a dimension or measure in BL and use find and replace option for manual BL refresh.

      Vaishali.

      (0) 

Leave a Reply