View Only
  • 1.  Jaspersoft report development

    Posted Jan 12, 2016 08:32 AM



    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?




  • 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.




  • 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



    Suman Pramanik