Universe Refresh Structure using BI 4.1 SDK?

[Former Member]

Hi Team,

In BI 4.1 we have .unv universes. In Universe Designer, there is an option View -> Refresh Structure.

Manually refreshing structure will take a lot of time. Is there any SDK available to achieve the same workflow.

I just want to open the universe, refresh its structure and close it using SDK. (Java preferable)

Please let me know how to start with that.

Regards,

Mitesh Joshi              

[Former Member · Accepted solution]

Hi Mitesh,

As far as I am aware of this is not possible using the java sdks.

Only universe designer(COM) sdks are available for .unv based universes.

I do not have much of an expertise on COM, however below is a snippet code I found while searching which might help you.

===============================

Private Sub
   Document_AfterRefresh()
   Dim DesignerApp As Designer.Application
   Dim Univ As Designer.Universe
   Set DesignerApp = New Designer.Application
   DesignerApp.Visible = False
   DesignerApp.Logon "Administrator", "Password", "CMSName","SecEnterprise"
   Set Univ = DesignerApp.Universes.Open("eFashion.unv")
   Univ.RefreshStructure
   Univ.Save
   DesignerApp.Quit
   Set DesignerApp = Nothing
End Sub

=================================

Refer to the link for guides.

http://scn.sap.com/docs/DOC-38810

Thanks,

Prithvi

[Former Member · Accepted solution]

HI Prithvi,

Thanks for your help.

I am quite new to this VB/.net Code. Can you please let me know how to login in to business objects or any sample, which will login in to business objects and will retrieve the universe.

Regards,

Mitesh Joshi

[Former Member · Accepted solution]

Hi Mitesh,

The above snippet has the code to login to designer and retrieve a universe.

I would suggest to post your queries to .net sdk forum, being the correct space to your query you would get better response there. Here is the link

http://scn.sap.com/community/bi-platform/microsoft-net-sdk

Thanks,

Prithvi

[Former Member · Accepted solution]

Hi Prithvi,

Apologies, somehow I forgot to check the top 4 lines of code.

Thanks for your help. I will check with .net team for this.

Regards,

Mitesh Joshi