|
|
Re: Dataset joins uses long names as alias [message #722682 is a reply to message #721882] |
Tue, 06 September 2011 14:10 |
|
If you open the joint data set in the data set editor you should be able
to choose output columns and change the alias to whatever you want it to be.
Jason
On 9/3/2011 6:47 AM, Darius wrote:
> Hello all,
>
> I'm new to this forum. Hope to have some help here :)
> Before I was using BIRT 2.6 version, now I have moved to the 3.7 version
> and noticed one strange thing.
> Lets say I'm using 9 data sets and later I want to make left outer join
> on all those datasets. My goal is to align all 9 data sets by date time
> field and make one big joint data set. So after I joined all sets I can
> access columns by using those blody names like
> "dataSetRow["Debitas_7::Debitas_6::Debitas_5::Debitas_4::Debitas_3::Debitas_2::Debitas_1::FT_10101_FLOW::FT_10101_FLOW_DIFF"]"
>
>
> In version 2.6 all joint data sets were created with simple aliases and
> the final joint data set had simple names to access colums like
> "dataSetRow["FT_10101_FLOW_DIFF"]".
>
> In version 3.7 if I create joints then aliases uses long names. Don't
> know why.
|
|
|
Re: Dataset joins uses long names as alias [message #722685 is a reply to message #721882] |
Tue, 06 September 2011 14:10 |
|
If you open the joint data set in the data set editor you should be able
to choose output columns and change the alias to whatever you want it to be.
Jason
On 9/3/2011 6:47 AM, Darius wrote:
> Hello all,
>
> I'm new to this forum. Hope to have some help here :)
> Before I was using BIRT 2.6 version, now I have moved to the 3.7 version
> and noticed one strange thing.
> Lets say I'm using 9 data sets and later I want to make left outer join
> on all those datasets. My goal is to align all 9 data sets by date time
> field and make one big joint data set. So after I joined all sets I can
> access columns by using those blody names like
> "dataSetRow["Debitas_7::Debitas_6::Debitas_5::Debitas_4::Debitas_3::Debitas_2::Debitas_1::FT_10101_FLOW::FT_10101_FLOW_DIFF"]"
>
>
> In version 2.6 all joint data sets were created with simple aliases and
> the final joint data set had simple names to access colums like
> "dataSetRow["FT_10101_FLOW_DIFF"]".
>
> In version 3.7 if I create joints then aliases uses long names. Don't
> know why.
|
|
|
|
Re: Dataset joins uses long names as alias [message #722798 is a reply to message #722792] |
Tue, 06 September 2011 18:09 |
|
I am not certain why this was changed, but you should be able to
reference the alias like row["Myalias"] although it does not show up in
the expression builder. Also log an enhancement/bugzilla to get more
details on why it was changed.
Jason
On 9/6/2011 1:53 PM, Darius wrote:
> Hello,
>
> Thanks for a reply. What you are saying is completely true, but in
> version 3.7 there is some strange things:
> 1. Simple named alias is not created automatically as in version 2.6
> 2. Even if I make nice simple aliases I can't use them in later
> designing process. I mean if I form column and try to select some
> datarow from data set then I don't see any aliases. Only those long
> names. Nothing more. Don't know why.
|
|
|
|
Re: Dataset joins uses long names as alias [message #723529 is a reply to message #722893] |
Thu, 08 September 2011 18:28 |
|
I do not think it is a bug, but maybe should be classified as an
enhancement.
Jason
On 9/7/2011 1:45 AM, Darius wrote:
> Hello,
>
> Yes, if I reference it like row["Myalias"] the its ok, but the problem
> is that I don't see those aliases, I need to know them by heart. Its
> difficult.
> About bug. I'm not sure if its a bug :( Maybe it was just changed
> interface or I do something wrong, because if I open report on 3.7 which
> was made with 2.6 then its ok. I can use aliases in find. I've tried to
> look at XML file of the report, but it was too big to understand the
> differences :(
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.89797 seconds