I need to be able to access a Risk attribute in an ad hoc view. However, the checkbox to load to the data warehouse is grayed out. It is a virtual attribute in the RIM_RISKS_AND_ISSUES table. Data type is Number. Is there a way to do this?
Check if Risk object is enable to include in DWH. Once Object is enable for DWH and you are still facing issue to mark that attribute to DWH then i will suggest some work around as CA might have put some limitation to add that particular attribute to include in DWH, i will suggest using ppmdb link to fetch data from ca ppm to you report or create a new dummy attribute of dynamic lookup with Risk ID and that attribute value SQL which you can mark for DWH inclusion.
There is one thing that you can try JeffreyAnthony4202065.
You can update Include in DWH attribute from the database end by using an update query. This is definitely not something that CA suggests or recommends but you can check that option too.
Just for information I would like to tell you that there are some out of the box objects and attribute for which this Include in DWH option will remain grayed out. This is as per the current design. I guess you are already aware of this but still thought of mentioning in case that helps any other users who would be going through this discussion.
Hope that helps. Cheers!!!
Also, if you are using Chrome, are you having issue where an unchecked box is not white, but is the same color as the background color? We see this, and the initial reaction that one has is that the box is grayed out when it really is not.
There is a very subtle difference between "Populate Null Values with the Default" checkbox, which is grayed out, and the the other 4 checkboxes that are not. In IE, the grayed out boxes are gray, for us, and the non-grayed out boxes are white - not subtle at all, very clear.
In Chrome, not very clear. Perhaps there is a Chrome setting we need to change? We're just starting to use Chrome, so we have a bit to learn.
So, if you are in Chrome and have same issue that we have, go ahead and check the box - if its grayed out, it won't let you make change; if it is not really grayed out, your click will be recognized:
Here, I've gone ahead and clicked on what appeared to be two grayed out boxes - they really weren't grayed out!
Apparently, there is a Chrome CSS file/element that can be changed to fix this - haven't yet found it, but only starting search, now.
Retrieving data ...