2011-01-27 03:05 PM
I need to reference 2 views in Crystal Reports 2008.
I have established connectivity to my OM server and I am able to browse the views.
Could someone provide me with a screenshot or document on how to reference 2 views? (example lunView and ObjectView)
Solved! SEE THE SOLUTION
2011-01-27 08:29 PM
For your particular example you will have to join on objectView.objId and lunView.lunId. I haven't used Crystal Reports so I can't say how exactly this is to be accomplished in that tool.
2011-01-27 08:51 PM
The relationship between views and the list of all view and its schema are documented in the man pages, which can be accessed as follows.
Control Center-> Help->General Help->Database Schema,
Under which you will find the following which should help you in combining two views
Database schema for DataFabric Manager nonhistoric data
Database schema for DataFabric Manager historic data
Relationship among fields of various database views