|
Re: How to display table based on dynamic table name [message #893791 is a reply to message #893378] |
Thu, 05 July 2012 13:43 |
|
Tomas
Are you saying that the parameter FullTableName, is the name of a table
that contains a field with names of other tables you want to show?
Jason
On 7/3/2012 2:47 PM, Tomas Greif wrote:
> Hi,
>
> I have created data warehouse documentation and I'm using BIRT (2.6) as
> a presentation layer. I would like to give the user the opportunity to
> preview some rows from each table. However, I need to make this
> dynamically, because there is a lot of tables. I do have name of the
> table stored in database (FullTableName).
> Is there a way how to use this a parameter and show table content to the
> user?
>
> Thank you for any ideas.
>
> Tomas
|
|
|
Re: How to display table based on dynamic table name [message #894445 is a reply to message #893791] |
Mon, 09 July 2012 09:26 |
Tomas Greif Messages: 53 Registered: September 2010 |
Member |
|
|
Jason,
I do have name of the table stored in table (dw_description_table) in the column named physical_table_name. I also do have list of columns in table dw_description_column. Im attaching:
- sample data (Note that there is foreign key in dw_description_column (table_description_key) that links to table in dw_description_table)
- screenshot of current report - it might help you to understand my problem better.
Regards,
Tomas
[Updated on: Mon, 09 July 2012 09:27] Report message to a moderator
|
|
|
Re: How to display table based on dynamic table name [message #895108 is a reply to message #894445] |
Wed, 11 July 2012 17:16 |
|
In the tables that you are looking up do they all have the same column
metadata?
Jason
On 7/9/12 5:26 AM, Tomas Greif wrote:
> Jason,
>
> I do have name of the table stored in table (dw_description_table) in the column named physical_column_name. I also do have list of columns in table dw_description_column. Im attaching:
> - sample data (Note that there is foreign key in dw_description_column (table_description_key) that links to table in dw_description_table)
> - screenshot of current report - it might help you to understand my problem better.
>
> Regards,
>
> Tomas
>
|
|
|
|
Re: How to display table based on dynamic table name [message #895390 is a reply to message #895211] |
Thu, 12 July 2012 16:44 |
|
I assume you want to create the inner table in the report dynamically.
The only way I know how to do this is to call the data engine api in the
beforeFactory to make design changes. The beforeFactory or onPrepares
are the only location where the design can be altered in that fashion.
Take a look at this thread.
http://www.eclipse.org/forums/index.php/m/892804/
Jason
On 7/12/12 2:44 AM, Tomas Greif wrote:
> Not sure I understand your question - all the metadata are stored in two
> tables, the metadata columns are the same for every table. Of course,
> values are different for every table as tables have different number of
> columns, different names of columns and different data types too.
|
|
|
Powered by
FUDForum. Page generated in 0.04183 seconds