Mar 30, 2004 #1 alex20850 Programmer Mar 28, 2003 83 US I have created a BO universe. I want to create a report that will list sample data. As part of this report, I want to create a variable that will tell which table a field comes from.
I have created a BO universe. I want to create a report that will list sample data. As part of this report, I want to create a variable that will tell which table a field comes from.
Mar 31, 2004 #2 blom0344 Technical User Mar 20, 2002 3,441 NL There is basically no problem with working in the tablename into your object-names, thus doing away with an additional meta-data variable. So, instead of 'Sales Quantity' define: 'SIL.Sales Quantity' There are some custommade add-in's that produce a data-dictionary, but creating a variable that stores tablenames of all fields is AFAIK not possible. Perhaps you can work out something by bringing in the SQL through the DataProviderSQL function..... T. Blom Information analyst tbl@shimano-eu.com Upvote 0 Downvote
There is basically no problem with working in the tablename into your object-names, thus doing away with an additional meta-data variable. So, instead of 'Sales Quantity' define: 'SIL.Sales Quantity' There are some custommade add-in's that produce a data-dictionary, but creating a variable that stores tablenames of all fields is AFAIK not possible. Perhaps you can work out something by bringing in the SQL through the DataProviderSQL function..... T. Blom Information analyst tbl@shimano-eu.com