system
October 21, 2010, 1:03pm
#1
In order to document a BO XI 3.1 Universe, I have to use Java SDK.
I am using the DataSourceObject class to retrieve information such as the object name, the aggregation function for measures, the qualification.
I am trying to retrieve the SQL definition of each object (SELECT statement, source table, but I can’t manage to find these infos.
I am using the right methods/classes ? I yes, how can I retrieve all the infos I need. If not, what would be the method ?
Thanks by advance
–
Matthieu Boisson
Matthieu Boisson (BOB member since 2010-10-21)
system
October 22, 2010, 5:40am
#2
Hi.
I’m not sure what you mean when you say you’re using the Java SDK to document the Universe as there is no Java SDK for the Universe. It’s a COM based object model. Maybe you mean you’re documenting the query within a WebI document possibly? Anyway, using this Universe SDK, you can get this sort of info - look at this post:
Author: André Lützkendorf
Platform: Windows
Version: GetSetUniverse 3.5.25
Code: VBA code within the uploaded xls file
Author notes:
1. What can you do with the tool?
Presentation of all universe objects and properties
This includes
general universe information (defined in parameters)
all object properties
object dependencies (lineage/ impact analysis)
(which table will be used by which object,
which objects will be used by which objects with @functions)
contexts
hierarchies
joins
inc…
chesl73 (BOB member since 2008-05-15)
system
October 22, 2010, 9:48am
#3
Thank you for your answer.
I finally changed my mind, according to all the answers I got. I am now using the COM component with VB, and it works perfectly.
Matthieu Boisson (BOB member since 2010-10-21)