Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
INSERTING conditional filter on datCube
Migrateduser
<p>Hello everyone,
I am actually using BIRT 3.7.0 and i am having a problem making a conditional filter on a datacube using expression builder:
I have uploaded a print screen attachment(expressionBulider001.png).
You can see from tha attachement that i am doing a filter on the field dataSetRow["MOIS"] . I also have an another field using dataSetRow["ANNEE"].</p><p>what i want to do using the expression builder is :
if( dataSetRow["ANNEE"]== 2013){</p><p> </p><p> //filter the datacube using dataSetRow["MOIS"] = feb, march.april</p><p> </p><p>}
else if( dataSetRow["ANNEE"]== 2014){</p><p> //filter the datacube using dataSetRow["MOIS"] = May, June,July</p><p>}</p><p> </p><p> </p><p>Depending on the value of dataSetRow["ANNEE"], i want to filter the datacube using the field dataSetRow["MOIS"] by the above mentioned values.
if anyone can post a simple example on the above issue or printscreen(even better) , i will be very grateful.
Thanks in advance</p>
Find more posts tagged with
Comments
There are no comments yet