AnsweredAssumed Answered

How to perform lookups in the CA_Clarity universe?

Question asked by mickloeb on Oct 27, 2010
Latest reply on Nov 19, 2010 by Chris_Hackett
Hi to all of you intrepid reporters,
I am developing a query from the stock CA_Clarity universe for a Crystal Report. I am trying to tie together lookup codes with values. I don't want to make any modifications to the universe, just use what is provided. For instance, I am trying to resolve the Status codes into Status values. A direct database query is so straightforward in SQL:

SELECT lookup_ENUM,l ookup_code
FROM niku.CMN_LOOKUPS
WHERE lookup_type = 'INVESTMENT_OBJ_STATUS'
ORDER BY lookup_enum

I am lost when trying to resolve the Investment status code into a value from a universe query. I can see @Lookup functions but I don't know how they work and this is poorly documented. I am still working with the Clarity v12.0 universe. I have used this blog before and received some very helpful suggestions in the past. Can someone share with me how this works?


Mickey

Outcomes