nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dropping orphan datasets in BIRT report

BIRT User

Hi,
I am using Actuate iHub BRDPro and i have to drop the unused datasets before report generation.
 
I want to drop the datasets which are not binded with any of the report elements. I have to drop it in onPrepare() or beforeFactory() methods.
 
Is there a way to find whether dataset is being binded with any report elements or not?.
 
 
 
Thanks,
Ragu

Find more posts tagged with

Comments

micajblock

Data sets that are not being used do not executed. Why do you want to drop the data sets?

BIRT User

We are generating report using multiple libraries and we are saving that generated report using SaveAs option in BRDPro.

In the SaveAs report, each elements from different library is having its own dataset and its own datasource. 

Based on input parameter,if we want to add a new report, its adding a new element, new dataset and new datasource in the SaveAs report.
But if we don't need any element we are dropping that element. Currently its droppinng that element only and not its associated datasets/datasources.

In the final report, many datasets and datasources are there which are not used in the report.
 
It would be great if you could help me to find the unused datasets in the report.
 
Thanks,
Ragu

micajblock

Sorry, I do not know. Maybe some other experts do.

RichT

Hello,
 
In a report I developed in BIRT 2.6.2 I was dropping a dataset in the BeforeFactory() like this:
<pre class="_prettyXprint _lang-js">
reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("MyDataset").drop();
</pre>
I'm not familiar with the differences between BIRT 2.6.2 and Actuate iHub BRDPro so this may not be too much help. Further, I'm not sure how to verify that a dataset has no associated elements.
 
Hopefully this helps you with part of your problem,
Rich

Matthew L.

It is more complex to clean up than it is to add in dynamically.
Perhaps you could create an example of what you are wanting to accomplish and we could find a better alternative.
 
However if you are wanting to do some clean up, as long as you know the elements you are wanting to clean up, this will make it slightly easier.
For example, to clean up a table from a report design called "MyTable" you could do the following, this is assuming that other elements are not dependent on the Table as well:
<pre class="_prettyXprint _lang-js">
tableName = "MyTable";
reportDesignHandle = reportContext.getReportRunnable().designHandle.getDesignHandle(); //Get ReportDesignHandle
tableHandle = reportDesignHandle.findElement(tableName); //Get TableHandle
tableDataSetName = tableHandle.getProperty("dataSet"); //Get Data Set name
tableHandle.drop(); //Drop Table

odaDataSetHandle = reportDesignHandle.findDataSet(tableDataSetName); //Get OdaDataSetHandle
dataSourceName = odaDataSetHandle.getProperty("dataSource"); //Get Data Source name

iterator = odaDataSetHandle.clientsIterator(); //Check to see if any other elements are using the same Data Set
while (iterator.hasNext()) //Loop
var value = iterator.next(); //Get next value
if(!value)
odaDataSetHandle.drop(); //Drop Data Set

odaDataSourceHandle = reportDesignHandle.findDataSource(dataSourceName); //Get OdaDataSourceHandle
iterator = odaDataSourceHandle.clientsIterator(); //Check to see if any other Data Sets are using the same Data Source
while (iterator.hasNext()) //Loop
var value = iterator.next(); //Get next value
if(!value)
odaDataSourceHandle.drop(); //Drop Data Source
</pre>

BIRT User

Thanks Matthew!!
 
clientsIterator() is the method which i am looking for. If this method gives the associated elements of the dataset, i can do something like this.
 
dataSetHandle = reportContext.getDesignHandle().getDataSets(); //get the datasets handle
dataSetsIterator = dataSetHandle.iterator(); //get the datasets slot iterator
//Iterate through the datasets
while (dataSetsIterator.hasNext())
{
odaDataSetHandle= dataSetsIterator.next();
iterator = odaDataSetHandle.clientsIterator(); //Check to see if any other elements are using the same Data Set while (iterator.hasNext()) //Loop var value = iterator.next(); //Get next value if(!value) odaDataSetHandle.drop(); //Drop Data Set 
}
 
I hope this will resolve my issue. I will implement this and come back if i encounter any issues.
 
 
Thanks,
Ragu