Clarity

I'm not sure if this is the right place to ask - but I thought it would be a start. We have some custom attributes in for some of our objects within CA PPM, and we're finding that these Custom Attributes aren't appearing in our ODATA Feed when we're trying to create reports within Power BI. 

I can confirm that these custom attributes are selected to be included in the Data Warehouse, however, they aren't appearing in the few DWH Tables I'd think they'd be included. It appears they're loading in the "ODF_CA_PROJECT" table, but that table isn't coming up after I've done both a normal data warehouse job and a full load. Any ideas? 

The odf_ca_project table belongs to the NIKU schema. Try looking in your actual DWH schema for table: DWH_INV_PROJECT for your custom attributes. Since they are marked to be included in the DWH, and your load jobs run without error, these should be here. IF these fields are associated to lookups, then the actual lookups are uniquely written per lookup into tables as such: DWH_LKP.....and you'll have to join DWH tables to get the data.

I did a check in that table, and the custom attributes aren't showing up in when I load that table into Power BI.

 Custom Attributes appear in table DWH_INV_PROJECT in the Data warehouse schema.

How connecting to your database instance ( with sql developer or similar db tool) and verify the table contains your custom fields. I don't use MS Power BI tools at this time and can't validate as such.

We don't have tools like that - nor am I skilled enough in that aspect to understand where I would begin to search with those tools. 

Please consult with a DBA that supports your CA PPM installation. They should be able to assist you.

I'm not sure who that would be. We're a SaaS customer. 

Then you should be reaching out to your SAS support contact. Or raise a support ticket for more assistance.

Hi Shannon,

Have you tried running the Refresh DWH job? Here's a link to the OData Config documentation in case you want to check out:

Configure OData Access to the Data Warehouse