ODAC and IBX Datadictionary

rbuser

Hi!
I use the ReportExplorer with Datadictionary in some strange way.
My Reports and the DataDictionary are stored in an IBX Database,
the DataConnection may be chosen from three different Ways (IBX, ADO or
ODAC). Until there everything works fine for me because I use the
ReportParameters to set the Database Setting everytime the Report -
Template loads. But now I've got some strange Things happen.
My ODAC Session is connected to a huge Database with a lot of Tables
across a RAS-Connection, thats one of the reasons why I decided to stor
the Templates and the Dictionary locally, so the Report should only
fetch the Tables and fields it really needs.
When I open my Report in Designer, check the Datasettings in the DataTab
everything works fine as excepted, the following Report Preview loads in
a few seconds. If I restart my App and go directly to the Preview the
same Report needs (maybe depending a littlebit on the bandwith of my
dialup-Connection) more then 5 Minutes to load, it's the same amount of
time it takes to load without using a Dictionary (I guess it sucks the
whole Table-Structure across the line...).
So I tried nearly everything to get the ReportPreview to work with the
DataDictionary but nothing works right now. Does anyone got a clue whats
going wrong here ?
What different Things does the DataSettingDlg that work better then my

Designer.DataSettings.Datadictionary := ppDataDictionary1;
Designer.DataSettings.UseDatadictionary := true;

I've already tried things like Reset the Datadictionary,
Flush the MetaDataCache and more but nothing helps, I'd always to open
the designer first to save my time

Thanks in advance
Prof. Blasberg
(D6+RB7)

nardmoseley

Try setting DataDictionary.ValidateTableNames and ValidateFieldNames to
False.

From the RBuilder.hlp for the DataDictionary.ValidateTableNames
property.....


Defaults to True. This property indicates whether or not the table names
supplied by the data dictionary should be validated against the table names
supplied by the currently connected database. In order to optimize the
performance of the data dictionary, you can set this property to False.



--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Sorry, but this was one of the first things I've done, you're right
without that it also takes a loooong time until the report shows up.
And as I already said, if I open up the DataSettings first anything
works fine (theres no Option to set the Table/Field validation in the
EndUser Enviroment).
Anything else to do (please...) ?

Prof. Blasberg


Nard Moseley (Digital Metaphors) schrieb:

nardmoseley

Modify your Delphi library path from RBuilder\Lib to RBuilder\Source. Then
run the application and trace the source code and try to locate the bottle
neck. Try opening daMetaDataManager.pas and placing breakpoints in all of
methods of the MetaDataManager (there are only about 5 or 6).




--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com