In CA PPM 14.3, we can push the custom attributes to datawarehouse by checking attribute property which is fine. But we have several objects in BOXI which are not attributes by themselves. For example, CABI OOB Project universe has WBS Phase Activity Name, WBS Activity Name, WBS Record Type. These are not direct attributes but CABI universe has some SQL logic behind them. Is it possible to get these kind of fields in datawarehouse without doing lot of customization?
Please let me know
What I'd recommend you is to get the exact SQL query.To do this, add the same field in a Webi report, then click View SQL. Once you get the SQL you can use it as well in your SQL Jaspersoft reports. Alternatively you can use it to create a dynamic lookup field attribute on Project object, which you then can enable for DWH and add to your reports and ad-hoc views.
Hope this helps -Nika
I have SQLs already for the non custom attributes.I am not worried about in using them in Jaspersoft professional designer. My question is how to add these fields the domain without configuring application. I would like to add these fields to the domain so that they will be available for self service reporting users. Is creating an attribute in Project object and enable for DWH the only way? or Is there any other way to add the fields to domain without touching application