Clarity PPM1

Expand all | Collapse all

HOW TO SEPARATE OBS AND LOCATION IN JASPERSOFT FILTERS??

  • 1.  HOW TO SEPARATE OBS AND LOCATION IN JASPERSOFT FILTERS??

    Posted 11-10-2017 12:51 PM

    I'm doing a report on Jaspersoft, but I just want to filter by OBS.

    In the "OBS Path" filter it is shown together (OBS and Location) .

    How can I separate or filter it so that it only shows me the values of OBS?

     

     

     

    #clarityreportgeneration

    #cappmclarity

    #jaspersotreport

    #jaspersoftchart

    #lookupfilter

    #obspath



  • 2.  Re: HOW TO SEPARATE OBS AND LOCATION IN JASPERSOFT FILTERS??

    Posted 11-13-2017 03:10 PM

    Rodrigo.gregoriodelasheras

    My friend, I have not received help by this way
    Please help me

    Saludos



  • 3.  Re: HOW TO SEPARATE OBS AND LOCATION IN JASPERSOFT FILTERS??

    Posted 11-13-2017 03:17 PM

    Hi Karlos,

     

    What you could do is ask CA Mexico Pre sales o CA Mexico Services, if they know anything

     

    Saludos 



  • 4.  Re: HOW TO SEPARATE OBS AND LOCATION IN JASPERSOFT FILTERS??

    Posted 11-13-2017 05:42 PM

    Hi Rodrigo,

    Could you send me the CA Mexico Pre sales o CA Mexico Services contact information?
    Please

     

    Thanks



  • 5.  Re: HOW TO SEPARATE OBS AND LOCATION IN JASPERSOFT FILTERS??

    Posted 12-05-2017 02:39 AM

    Hi Karlo,

     

     

    I am afraid that this is not possible OOTB due to the design of the domains:

    For each OBS Type (e.g. Department or Location), you will get one piece of information, e.g. the ETC hours on a project.

    E.g.:

    Project NameETC HoursOBS TypeOBS Unit
    Project A140DepartmentSales
    Project A140Location

    London

    Project B42DepartmentSales
    Project B42LocationBerlin

     

    If you filter for Department Sales and Location London, you will get the first 3 rows which adds up the 140 hours twice.

    If you only want to fitler for either Department or Location, just add the OBS Type to your filter.

    If you want to filter both Department and Location, you have to transpose both values to columns using Calculated Fields:

    Name "Department Path": IF("OBS Type" == 'Department', "OBS Path", null)

    Name "Location Path": IF("OBS Type" == 'Location', "OBS Path", null)

     

    Now, you can filter by both fields

     

    I hope I could help!

     

    Regards

    Georg