I have this Mysql Schema ( here a short sample )
Detail1->ID is primary key and foreign Key to ID on Main Table and contain some ID record from MainTable
Detail2->ID is primary key and foreign Key to ID on Main Table and contain some ID record from MainTable
I create the hibernate datamart using the guide.
In Spago BI QBE document, I see this correct Tree navigation:
My problem is:
I would like to see all the records from MainTable also when I want to see some additional "info" ( position, status, description...all information that is in other tables).
In fact when I added some "detail" column ( for example position form Detail1 table ), I see only the record that match foreign key ( in this case is only visibile the records from MainTable that "join" records from Detail1 table )
This is the query that I see on ..QBEAudit.Log
HQL Query : SELECT t_0.ID, t_0.Code, t_0.Note, t_0.Detail1.ID, t_0.Detail1.Status FROM it.foodmart.MainTable t_0
and that query that I "need"
select t_0.ID, t_0.Code, t_0.Note, t_1.ID, t_1.Status from it.foodmart.MainTable t_0 LEFT OUTER JOIN it.foodmart.Detail1 t_1 ON t_0.ID = t_1.ID
In the SpagoBI demo I See that in QBE document is possible ( SalesFact1998 records with some additional info in other tables (Store, Product, ecc...))
but I can't replicate this functionality in my installation !!
Thanks in advance for any Help
This message was edited 1 time. Last update was at 11/08/2011 16:17:29