Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] OBI EE to WebFOCUS.
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] OBI EE to WebFOCUS.
 Login/Join
 
Member
posted
Hi,

While I have seen a recent question 'Convert Tableau to WebFOCUS' and I understand the first reply to it, can I still please ask here whether or not anyone has done or is aware of the methods and challenges while moving from OBI EE to WebFOCUS? Is there any migration tool developed by Information Builders?

The current OBI EE BI application is based on a simple and basic star schema. As far as the reports/dashboards are concerned they too are basic, straigh forward and simple.

Based on my first question here, it looks like there is something similar to the RPD and there is some similar tool (AppStudio?) to build the RPD.

As far as the reporting aspect is concerned do we have to create the reports and the dashboards from scratch manually using WebFOCUS? It looks like yes as I have noticed that on OBI EE forum people have asked questions like 'How do I migrate my BusinessOBjects reports to OBI EE' and the OBI EE gurus have indicated that the two technologies are different and there's no migration tool available.

Awaiting for your replies. We are still on OBI EE but we shall be using WebFOCUS in future.

Kind regards,

Manoj.

This message has been edited. Last edited by: FP Mod Chuck,


Newbie. No access to Product Suite yet.
 
Posts: 7 | Location: Bournemouth - UK.  | Registered: August 30, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Manoj

I admit I know nothing about OBI EE but if the underlying code is SQL then you can just capture that and use WebFOCUS SQL Passthru to generate the same report.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1427 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
Or use the SQL for your masterfile, so you can also use it with Infoassist etc.

Could you post an example of a RPD file?


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 371 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I haven't done a conversion of OBIEE either, but I've done conversion projects for other applications and here are my suggestions:

1. This is your opportunity to re-architect an old system to a new platform. Presumably, they're replacing OBIEE because it wasn't meeting a need. Why replicate it in WebFOCUS.
2. Find what's important and purge what's redundant, dated and useless.
3. Use existing code as examples/specifications and talk to Biz users to find out how they'd like you to improve on them.
4. If there's a piece of content that's essential to the business and cannot be changed or removed, use Chuck and Fans' advice by reusing the SQL generated by OBIEE to create metadata and deploy the WebFOCUS content to provide that functionality, and additionally, look for ways to improve on it by using WebFOCUS features like Active et cetera.


WebFOCUS 8204, Unix, Windows
 
Posts: 1527 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Member
posted Hide Post
Thought it's better to be late than never.

Thank you all. Nice insights.

@Frans, I can post an example of an RPD file, but to open it, we need relevant tool. However, the following URL refers to sevaral images of an RPD file.

Example Images of an RPD file

The rightmost layer lets OBIEE server know about the actual physical sources of data, the middle layer defines business logic (formula, when to use aggregated tables, snowflake or OTLP schema mapped as a star schema, join types, etc.). The leftmost column is a presentation of the midlle layer in terms of folders and column which IT or poweful end users can use to build reports.

In summary, the RPD (among other things such as defining data security) lets the business interact with the underlying sources of the data without using technical terms.


Newbie. No access to Product Suite yet.
 
Posts: 7 | Location: Bournemouth - UK.  | Registered: August 30, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] OBI EE to WebFOCUS.

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.