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; } } }

Dataset script not working in a DataCube

leonidaswilliams · 2015-03-11T13:58:28+00:00

Hi, I have a Dataset with Computed columns and in the beforeOpen and in onFectch events I calculate these two columns for every column. If I open the dataset and I go to Preview Results I see the correct values, but if I use this Dataset in a DataCube it is not working. It…

leonidaswilliams

Hi,
 
I have a Dataset with Computed columns and in the beforeOpen and in onFectch events I calculate these two columns for every column.
 
If I open the dataset and I go to Preview Results I see the correct values, but if I use this Dataset in a DataCube it is not working.
 
It seems like the script in Dataset is not working when is called in a Datacube.
 
Please, can anyone help me?
 
Thanks in advance.
 
Regards

Find more posts tagged with

Comments

JFreeman

Which version of BIRT are you using?
Can you provide a sample report based on classic models or a flat file data source that we can run to replicate this issue?

leonidaswilliams

Hi,
 
Sorry for the delay. Here are the files.
 
<a data-ipb='nomediaparse' href='https://www.dropbox.com/s/8230yljgkukxjhl/informeleonidas.zip?dl=0'>https://www.dropbox.com/s/8230yljgkukxjhl/informeleonidas.zip?dl=0</a>
 
Thx in advance

leonidaswilliams

Sorry, I forgot the explanation.
 
If you see in the dataset you will see Computed Columns where I generate the AccPlan value.
 
I enclose this Dataset in the datacube and I placed it in the Crosstab. But when I run the report I don't see the correct value of the column.
 
Can someone help me?
 
Thanks in advance.

JFreeman

The reason the calculated values are not displaying in the report output is because row values cannot be modified from within the onFetch of the data set. They can only be set in Fetch which is part of a Scripted Data Set versus a flat file data set like you have configured.
 
You can see it is related to the data set versus the cube by adding a table based on the data set and not the cube. This table will also not display your calculated values.
 
Instead, I have moved your code from onFetch into a new computed column and it is now working properly.
 
Take a look at the attached modified version of your report design for reference.

leonidaswilliams

It works perfect!
 
Thank you very much

JFreeman

You're welcome.
 
Let us know if you have any additional questions.