Skip to Content
avatar image
Former Member

Report to pull multiple Product Categories/Organizational Units per project

Hi Experts,

We are facing the following issue.

We have created a Project and have associated multiple Product Category & Organization to this project, many to One relationship. This we have achieved through customization. When we are pulling report for this project through Reports-> Project Summary Extract. Itu2019s giving us only one Product Category & one Org Unit per Project. The business wants us to pull all the Org Units & the Product categories associated with the Project, when we are displaying the report. This org units & product categories will be shown in Org Unit & Product category columns respectively separated by commas.

Looking forward for your help.

Thanks,

Ritik

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 08, 2011 at 10:42 PM

    Hi Ritik,

    It sounds like you have created custom fields/tables to capture multiple product categories and Org Units.

    The Project Summary Extract report, which is a standard (out of the box) report only queries the standard Product Category and Org Unit fields on the Project. In order to get the values from custom fields, you would have to create a custom query and update the SQL to query the custom fields.

    Regards,

    Vikram

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Mudit,

      We dropped the idea of showing the Product Category & Business Unit separated by comma(the example i have given in my earlier post). Now we want the the report in this format.

      Lets say Project P1 has 4 different Product Categories & Project P2 has 3 diff Product Categories. We want to display our report in the following format.

      Project: --Product Categories:

      -


      P1----


      PCAT1

      P1----


      PCAT2

      P1----


      PCAT3

      P1----


      PCAT4

      P2----


      PCAT5

      P2----


      PCAT6

      P2----


      PCAT7

      Following is the query i am trying right now.

      SELECT <%RESULTS%> FROM <%SCHEMA%>.FCI_PRO_PROJECTS T1 FULL OUTER JOIN <%SCHEMA%>.FCI_MAS_INTERNAL_CAT T3 ON T1.INTERNAL_CAT_OBJECT_ID= T3.OBJECTID WHERE T1.CREATED_AT >= ? AND T1.CREATED_AT <= ? <%ORDERBY%>.

      Its giving me the only Product Category for each project not all.

      Thanks,

      Ritik