Clarity

 View Only
  • 1.  Jaspersoft report development

    Posted Jan 12, 2016 08:32 AM

    Hi,

     

    I have started developing a SQL query based jasper report. I have custom attributes on project object which are not appearing in data warehouse project related tables. Project object is enabled for data warehouse load.

    How should I get these attributes in data warehouse db. Also how custom objects enabled for DHW load will show in data warehouse db after job completes?

     

    Thanks,

    Shiva



  • 2.  Re: Jaspersoft report development

    Broadcom Employee
    Posted Jan 12, 2016 09:29 AM

    To enable the custom attributes you can navigate to the object and select the attribute and there is a button called Include in Dataware house

     



  • 3.  Re: Jaspersoft report development

    Posted Jan 13, 2016 03:11 AM

    Hi Suman,

     

    I selected the custom attributes and enabled for DWH but for few attributes I am getting message like below.

    The below attributes could not be included in the Data Warehouse. If the attribute is lookup, query is not DWH compatible.

     

    Thanks,

    Shiva



  • 4.  Re: Jaspersoft report development
    Best Answer

    Broadcom Employee
    Posted Jan 13, 2016 03:17 AM

    Hi Shiva,

     

    The look up needs to have certain mandatory attribute for lookups in order to be allowed for Dataware house. Have a look at the articles Kathryn_Ellis publishe

     

     

    Rules for Including Dynamic Query Lookup Attributes in the Data Warehouse | CA PPM Cookbook

     

    CA PPM Tech Tip: Including Dynamic Query Lookup Attributes in the Data Warehouse

     

    Regards

    Suman Pramanik